Advertise
MCP.so
Sign In

CockroachDB MCP Server

@Swayingleaves

Repository

Basic information

Category

Databases

Transports

stdio

Author

Swayingleaves

About CockroachDB MCP Server

No overview available yet

CockroachDB MCP Server config

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

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

CockroachDB MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

Fetch the live tool list by running this server in a temporary sandbox using the button above.

Overview

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.

Frequently asked questions

1

How do I connect to a CockroachDB database?

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

2

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.

3

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.

4

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.

5

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.

Comments

More Databases MCP servers

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K

Redis

modelcontextprotocol

Model Context Protocol Servers

88.2K

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.

1

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539
Advertise