CockroachDB MCP Server

@Swayingleaves

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

Swayingleaves

关于 CockroachDB MCP Server

暂无概览

CockroachDB MCP Server 配置

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

{
  "mcpServers": {
    "cockroachdb-mcp-server-swayingleaves": {
      "command": "npx",
      "args": [
        "-y",
        "@smithery/cli",
        "install",
        "@Swayingleaves/cockroachdb-mcp-server",
        "--client",
        "claude"
      ]
    }
  }
}

CockroachDB MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

点击上方按钮,在临时沙箱中运行此服务器并实时获取工具列表。

概览

What is CockroachDB MCP Server?

CockroachDB MCP Server is an MCP server for Cursor that allows direct interaction with a CockroachDB database. It implements the Model Context Protocol (MCP) specification, providing tools, resources, and prompts for database operations.

How to use CockroachDB MCP Server?

Install dependencies with pip install -r requirements.txt and install uv via the official install script. Configure the server in Cursor by adding a JSON entry under mcpServers with the command uv, its arguments pointing to the server directory, and the JDBC URL, username, and password. The server can then be used through Cursor's MCP integration.

Key features of CockroachDB MCP Server

Connect to and disconnect from CockroachDB databases.
Retrieve all tables and table schema information.
Execute SQL queries directly.
Provide database status resources and SQL query templates.
Automatic reconnection and TCP keep-alive mechanisms.
Detailed rotating logs for troubleshooting.

Use cases of CockroachDB MCP Server

Query CockroachDB databases interactively from Cursor.
Browse database tables and their structures without a separate client.
Execute ad‑hoc SQL queries during development or debugging.

常见问题

How do I connect to a CockroachDB database?

Use the `connect_database` or `initialize_connection` tool with the JDBC URL, username, and password.

What if I encounter connection problems?

Check the server log file `logs/cockroachdb_mcp.log` for details. Common issues include connection refused, authentication failed, and connection timeout.

Does the server handle special characters in passwords?

Yes, it uses psycopg2 which automatically handles special characters such as `@`, `%`, and `&` without requiring additional URL encoding.

How does the server prevent connection timeouts?

The server enables TCP keep‑alive by default: it sends keepalive packets after 30 seconds of idle time, every 10 seconds, and gives up after 5 attempts.

What transport does the server use?

The server runs as a subprocess via the `uv` command and communicates with Cursor through the MCP stdio transport. Authentication is passed as configuration parameters.