CockroachDB MCP Server by CData
@CDataSoftware
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 CockroachDB (beta): https://www.cdata.com/download/download.aspx?sku=HJZK-V&type=beta
概览
What is CockroachDB MCP Server by CData?
CData’s read-only MCP Server for CockroachDB wraps the CData JDBC Driver for CockroachDB, allowing LLMs like Claude Desktop to query live CockroachDB data via natural language. It exposes CockroachDB tables as SQL models through the Model Context Protocol.
How to use CockroachDB MCP Server by CData?
Clone the repository, build with Maven (mvn clean install), download and install the CData JDBC Driver, license it, configure a .prp file with connection details, then add the server to your client’s MCP configuration (e.g., claude_desktop_config.json). The server runs via java -jar CDataMCP-jar-with-dependencies.jar <path_to>.prp and communicates over stdio.
Key features of CockroachDB MCP Server by CData
- Read-only access to CockroachDB data via MCP
- Three built-in tools:
get_tables,get_columns,run_query - Natural language queries – no SQL required by the user
- Powered by the CData JDBC Driver for CockroachDB
- Standard MCP interface compatible with Claude Desktop
- MIT licensed and open source
Use cases of CockroachDB MCP Server by CData
- AI assistants answering business questions from live CockroachDB tables
- Customer support triage by querying ticket databases without SQL
- Sales analytics dashboards powered by natural language requests
- Automated reporting of real-time CockroachDB data in chat interfaces
FAQ from CockroachDB MCP Server by CData
Is this server read-only?
Yes. The README explicitly states it is a read-only MCP server. For full CRUD capabilities, CData offers a separate free beta server.
What are the runtime requirements?
Java (to run the built JAR), Maven (to build), and the CData JDBC Driver for CockroachDB (downloaded and licensed separately) are required.
How is the server started?
Execute java -jar CDataMCP-jar-with-dependencies.jar /PATH/TO/cockroachdb.prp from the command line after building the JAR and configuring the .prp file.
What transport protocol does the server use?
The server uses stdio transport, so it can only be used with clients running on the same machine.
Are there example JSON-RPC requests?
Yes. The README provides JSON-RPC 2.0 examples for cockroachdb_get_tables, cockroachdb_get_columns, and cockroachdb_run_query.
