CockroachDB MCP Server by CData

Name: CockroachDB MCP Server by CData
Author: CDataSoftware

@CDataSoftware

About 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

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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.

Comments

More Databases MCP servers

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397

mcp_mysql_server

xwb602625136

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能；还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245