Establishing a Connection
The CData MCP Server for EnterpriseDB defines each connection to EnterpriseDB as a named configuration that Claude can use when sending natural language queries.
You create and manage these configurations using the MCP Configuration Tool. The tool automatically handles formatting, storage, and registration with Claude Desktop.
Understanding Connection Configurations
Each connection configuration is stored in a .mcp file. This file includes the details needed to initialize the connector when Claude starts a session.
- On Windows, configuration files are stored in "~/AppData/Roaming/CData/EnterpriseDB Data Provider/".
- On macOS, configuration files are stored in "~/Library/Application Support/CData/EnterpriseDB Data Provider/".
The .mcp file is a text file that contains a list of connection properties and a timestamp. For example:
#Tue May 20 15:48:40 EDT 2025 AuthScheme=Basic User=myUser Password=myPassword Security Token=myToken
The configuration tool handles these settings automatically. Each saved configuration enables Claude to launch a dedicated MCP Server instance with the correct connector and options. Manual file editing is not required.
Connecting to EnterpriseDB
The following connection properties are required in order to connect to data.
- User: The user which will be used to authenticate with the EnterpriseDB server.
- Password: The password which will be used to authenticate with the EnterpriseDB server.
- Server: The host name or IP of the server hosting the EnterpriseDB database.
- Port: The port of the server hosting the EnterpriseDB database.
You can also optionally set the following:
- Database: The default database to connect to when connecting to the EnterpriseDB Server. If this is not set, the user's default database will be used.