LogoSTMCP
Download
mcp-cockroachdb

CockroachDB MCP Server

CockroachDB MCP Server is a natural language interface for LLMs and agentic applications to manage, monitor, and query data in CockroachDB with seamless MCP client integration.

Tools

1. Cluster Monitoring

Get cluster health and node status, show currently running queries, analyze query performance statistics, and retrieve replication and distribution status.

2. Database Operations

Connect to a CockroachDB database, list, create, drop, and switch databases, get connection status and active sessions, and retrieve database settings.

3. Table Management

Create, drop, and describe tables and views, bulk import data into tables, manage indexes, list tables and views, and analyze schema structure and metadata.

4. Query Engine

Execute SQL queries with formatting options, run multi-statement transactions, explain query plans for optimization, and track and retrieve query history.

Open Graph image for CockroachDB MCP Server

JSON Config

{
    "mcpServers": {
        "cockroach": {
            "command": "<full_path_uv_command>",
            "args": [
                "--directory",
                "<your_mcp_server_directory>",
                "run",
                "src/main.py"
            ],
            "env": {
                "CRDB_HOST": "<your_cockroachdb_hostname>",
                "CRDB_PORT": "<your_cockroachdb_port>",
                "CRDB_DATABASE": "<your_cockroach_database>",
                "CRDB_USERNAME": "<your_cockroachdb_user>",
                "CRDB_PWD": "<your_cockroachdb_password>",
                "CRDB_SSL_MODE": "disable|allow|prefer|require|verify-ca|verify-full",
                "CRDB_SSL_CA_PATH": "<your_cockroachdb_ca_path>",
                "CRDB_SSL_KEYFILE": "<your_cockroachdb_keyfile_path>",
                "CRDB_SSL_CERTFILE": "<your_cockroachdb_certificate_path>"
            }
        }
    }
}

Useful Links

GitHubDeepWiki

Information

Categories

Tags

Back

More MCP Server

dbhub

DBHub

@bytebase/dbhub/

DBHub is a universal database gateway implementing the Model Context Protocol (MCP) server interface, allowing MCP-compatible clients to connect to and explore PostgreSQL, MySQL, MariaDB, SQL Server, and SQLite databases.

npxstdio
davinci-resolve-mcp

DaVinci Resolve MCP Server

@samuelgursky/davinci-resolve-mcp

A Model Context Protocol (MCP) server that connects AI coding assistants like Cursor and Claude Desktop to DaVinci Resolve, enabling natural language control and querying of video editing workflows.

npxstdio
data4library-mcp

📚 Data4Library MCP Server

@isnow890/data4library-mcp

Data4Library MCP Server is a comprehensive Model Context Protocol server that provides AI models with access to Korea's national public library data including book searches, loan status, reading statistics, and library information through 25 specialized tools.

npxstdio