Certinia MCP Server by CData

Name: Certinia MCP Server by CData
Author: CDataSoftware

@CDataSoftware

关于 Certinia MCP Server by CData

This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our free CData MCP Server for Certinia (beta): https://www.cdata.com/download/download.aspx?sku=HFZK-V&type=beta

#certinia #mcp-server #cdata

基本信息

分类

其他

传输方式

stdio

发布者

CDataSoftware

提交者

Cameron Leblanc

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "{classname_dash}": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\certinia.prp"
      ]
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is Certinia MCP Server by CData?

The Certinia MCP Server by CData is a read-only MCP server that allows large language models (like Claude Desktop) to query live data from Certinia using the CData JDBC Driver for Certinia. It wraps the driver in a simple MCP interface so users can ask natural language questions without writing SQL. It is intended for developers and data analysts who need AI-powered access to Certinia data.

How to use Certinia MCP Server by CData?

Clone the repository, build with mvn clean install, download and license the CData JDBC Driver for Certinia, create a .prp file with connection details, add the server to your Claude Desktop configuration (claude_desktop_config.json), and restart the client. The server runs on stdio, so it must be on the same machine as the client.

Key features of Certinia MCP Server by CData

Query Certinia data using natural language via LLMs
Exposes tools: get_tables, get_columns, run_query
Built on the CData JDBC Driver for Certinia
Read-only (write/update/delete available in separate CData MCP Server beta)
Supports any MCP client that runs on the same machine
Outputs results in CSV format

Use cases of Certinia MCP Server by CData

Ask “What is the correlation between my closed won opportunities and the account industry?”
Query “How many open tickets do I have in the SUPPORT project?”
Retrieve calendar events or other live Certinia data without writing SQL

FAQ from Certinia MCP Server by CData

Is this server read-only?

Yes, this project builds a read-only MCP server. For full read, write, update, delete, and action capabilities, check out the free CData MCP Server for Certinia (beta).

What are the runtime requirements?

Java is required to run the server and the JDBC driver. The project uses Maven to build and the CData JDBC Driver for Certinia must be installed and licensed.

Where does the data live?

Data remains in Certinia. The server connects to Certinia live via the CData JDBC Driver and does not store data locally.

What transport does this server use?

The server uses stdio as its transport, so it can only be used with MCP clients running on the same machine.

How do I authenticate to Certinia?

The JDBC Driver supports OAuth authentication. When configuring the connection string using the Driver’s utility, you will need to authenticate in your browser if OAuth is required.