Configure a connection in Devart MCP Server

You can configure a connection to your data source in one of these ways:

Use the Devart MCP Server connection manager.
Use the MCP Server configuration file.

Prerequisites

1. Install and activate Devart ODBC Driver.

2. Configure an ODBC DSN for the target data source.

For instructions on configuring the DSN connection, see the corresponding driver documentation:

Database data sources

Cloud data sources

Configure a connection using the connection manager

To configure the ODBC connection to the data source:

1. Open Devart MCP Server and click New.

Create a new MCP Server

2. On the ODBC Settings tab, specify the connection details:

2.1. Under NAME, enter a name for your connection.

2.2. Under ODBC CONNECTION, select one of these options:

Use a preconfigured DSN:

1. Select Use system or user data source.

2. In Dsn, select your data source.

Create a new ODBC connection using a preconfigured DSN

Use a connection string:

1. Select Use Connection String.

2. In Connection String, click the ellipsis (…).

3. On the Machine Data Source tab, select your data source name in the list or click New and follow the wizard instructions to create a new DSN, then click OK.

4. Verify your DSN settings in the configuration dialog, then click OK.

If the connection succeeds, the connection string appears in the Connection String box.

Create a new ODBC connection using a connection string

Note

To create a connection string manually, see the Connection options topic in your driver documentation.

3. Optional: Click Test Connection to verify your connection settings.

4. On the MCP Settings tab, select the transport protocol:

STDIO – Uses the standard input/output streams.
HTTP – Uses the Hypertext Transfer Protocol. Specify the port number to use.

Specify the transport protocol as HTTP

5. Click Save.

6. In the connection list, click the ellipsis (…) next to your connection and select Start.

Click Start to launch the MCP Server

Devart MCP Server starts.

The MCP Server is running

Tip

When Devart MCP Server is running, Start changes to Stop.

To stop the server, select Stop.

To access your data source from an AI tool, register the connection with the AI tool. For instructions, see AI integration.

Edit a data source connection

To edit a connection:

1. Double-click the connection to open it. Alternatively, click the ellipsis (…) and select Edit.

Select Edit to update the connection settings

2. On the Edit MCP Server page, update the connection settings as needed.

3. If you’ve already integrated Devart MCP Server with an AI tool, on the Integration tab, click Unregister, then click Register.

4. Click Save.

5. Click the ellipsis (…), select Stop, then select Start.

Delete a data source connection

To delete a connection:

1. Click the ellipsis (…) next to the required connection and select Delete.

2. In the confirmation dialog, click Yes.

The connection is removed from the MCP Servers page.

Configure a connection using the configuration file

To configure a connection manually, create and configure the mcpserver.json file.

1. Create an mcpserver.json file in one of these locations:

The MCP Server installation folder.
C:\ProgramData\Devart\<MCP Server for ...>

where <MCP Server for ...> is the name of the specific MCP Server. For example,

C:\ProgramData\Devart\MCP Server for PostgreSQL.

2. Configure the parameters, depending on the transport protocol used by the MCP Server:

STDIO

{
  "Connections": [
    {
      "Name": "My_Connection_1",
      "Driver": "Devart ODBC Driver",
      "DsnName": "My_DSN",
      "ConnectionString": null,
      "ProtocolType": "Stdio"
    }
  ]  

}

where:

Name is the name of the ODBC connection.
Driver is the name of the specific ODBC Driver.
DsnName is the name of your data source.
ConnectionString is set to null because DsnName is used.
ProtocolType specifies the transport protocol.

Note

To use ConnectionString instead of DsnName, specify the connection string for the specific driver and set DsnName to null.

For more information on connection string configuration, see the Connection options topic in your driver documentation.

HTTP

{
  "Connections": [
    {
      "Name": "My_Connection_1",
      "Driver": "Devart ODBC Driver",
      "DsnName": "My_DSN",
      "ConnectionString": null,
      "ProtocolType": "Http",
      "HttpPort": 8080
    }
  ]  

}

where:

Name is the name of the ODBC connection.
Driver is the name of the specific ODBC Driver.
DsnName is the name of your data source.
ConnectionString is set to null because DsnName is in use.
ProtocolType specifies the transport protocol.
HttpPort specifies the HTTP port.

3. Save the file.

4. Start the MCP Server.