CockroachDB MCP Server by CData

Name: CockroachDB MCP Server by CData
Author: CDataSoftware

@CDataSoftware

关于 CockroachDB 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 CockroachDB (beta): https://www.cdata.com/download/download.aspx?sku=HJZK-V&type=beta

#cockroachdb #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\\cockroachdb.prp"
      ]
    }
  }
}

工具

未检测到工具

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

概览

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.

数据库分类下的更多 MCP 服务器

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K

MCP MongoDB Server

kiliczsh

A Model Context Protocol Server for MongoDB

281

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.