home / mcp / certinia mcp server

Certinia MCP Server

This read-only MCP Server allows you to connect to Certinia data from Claude Desktop through CData JDBC Drivers. For full CRUD support, check out our MCP Server for Certinia (https://www.cdata.com/drivers/certinia/download/mcp).

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "cdatasoftware-certinia-mcp-server-by-cdata": {
      "command": "java",
      "args": [
        "-jar",
        "/PATH/TO/CDataMCP-jar-with-dependencies.jar",
        "/PATH/TO/Salesforce.prp"
      ]
    }
  }
}

This MCP Server provides a read-only interface to Certinia data via the CData JDBC Driver, letting you query live data with natural language requests. It exposes Certinia data through a simple MCP API so your AI client can retrieve information without writing SQL.

How to use

You use this MCP Server with an MCP-compatible client to ask questions about Certinia data and receive live results. The server is designed for read-only access, so you can query opportunities, accounts, tickets, and other Certinia data that the JDBC driver exposes. When you ask questions, the AI client can leverage the built-in tools to discover data shapes, read table data, and run read queries through the MCP interface.

How to install

Prerequisites: you need Java installed on your machine and Maven to build the server. Ensure you have internet access to download dependencies and the CData JDBC Driver after the build step.

Clone the project and build the server locally.

git clone https://github.com/cdatasoftware/certinia-mcp-server-by-cdata.git
cd certinia-mcp-server-by-cdata
mvn clean install

Additional configuration and running the server

After building, you will run the MCP server using the generated JAR and a properties file that contains your JDBC connection details. The final step launches the server process on the local machine.

Here is the run command you will use once you have certinia.prp prepared with your JDBC connection details.

java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/Salesforce.prp

Troubleshooting and notes

If you cannot see or connect to the MCP Server, ensure the process is running on the same machine as your client and that the JDBC connection string is valid. If OAuth is involved, complete any browser authentication prompts during connection setup. If you encounter issues, quit and relaunch the client to refresh the MCP server list.

Configuration details and tools

The server provides read-only access via three tools. Replace {servername} with your actual server name in your client requests.

Tools & Descriptions

- {servername}_get_tables retrieves a list of tables available in the data source. The output is in CSV format with column headers in the first line.

- {servername}_get_columns retrieves a list of columns for a specified table. The output is in CSV format with column headers in the first line.

- {servername}_run_query executes a SQL SELECT query against the data source.

Available tools

certinia_get_tables

Retrieves a list of tables available in the data source. The output is returned in CSV format with the first line containing column headers.

certinia_get_columns

Retrieves a list of columns for a specified table. The output is returned in CSV format with the first line containing column headers.

certinia_run_query

Executes a SQL SELECT query against the Certinia data source and returns the results.