CockroachDB MCP Server

MCPOpen SourceMIT30.1

by amineelkouhen • Data & Databases

A natural-language MCP server that lets LLMs and agentic applications manage, monitor, and query CockroachDB clusters.

Example Use Cases

1
Monitor CockroachDB cluster health, node status, running queries, and replication/distribution status programmatically.
2
Run natural-language-driven SQL queries and multi-statement transactions against CockroachDB and receive results formatted as JSON, CSV, or tables.
3
Manage databases, tables, indexes, schema descriptions, and perform bulk imports into CockroachDB as part of automated workflows.

Description

CockroachDB MCP Server exposes CockroachDB operations via the MCP (Model Content Protocol) so agents can perform cluster monitoring, database and table management, and execute SQL queries and transactions using natural language. It supports stdio transport today and integrates with MCP clients such as Claude Desktop, OpenAI Agents SDK, VS Code, Cursor and tooling like uvx and Docker. The server provides tools for cluster health, query analysis, schema and index management, bulk import, and formatted query outputs (JSON/CSV/table). It is open-source (MIT) and designed to be lightweight and easy to run for AI-driven workflows.

Capabilities(29 total)

Tools (29)

get_cluster_status

Get cluster health and node distribution. Args: detailed (bool): If True, returns all node details. If False, returns summary info. Returns: Details about the cluster's status and how nodes/ranges are distributed or an error message.

detailed:boolean

show_running_queries

Show currently running queries on the cluster. Args: node_id (int): Node ID to filter (default: 1). user (str): Username to filter (default: 'root'). min_duration (str): Minimum query duration (default: '1:0', format: 'minutes:seconds'). Returns: The queries running on the cluster.

node_id:integeruser:stringmin_duration:string

get_replication_status

Get replication and distribution status for a table or the whole database. Args: table_name (str): Table name to filter (default: "", for all tables). Returns: Details about range replication for a specific table or the current database.

table_name:string*

connect

Connect to the default CockroachDB database and create a connection pool. Returns: A success message or an error message.

connect_database

Connect to a CockroachDB database and create a connection pool. Args: host (str): CockroachDB host. port (int): CockroachDB port (default: 26257). database (str): Database name (default: "defaultdb"). username (str): Username (default: "root"). password (str): Password. sslmode (str): SSL mode (default: disable - Possible values: allow, prefer, require, verify-ca, verify-full). sslcert (str): Path to user certificate file. sslkey (str): Path to user key file. sslrootcert (str): Path to CA certificate file. Returns: A success message or an error message.

host:string*database:string*port:integer*username:string*password:string*sslmode:string*sslcert:string*sslkey:string*sslrootcert:string*

Quick Actions

View on GitHub

Security

Scanned 3 month(s) ago

Risk Level

MODERATE

Can modify files, state, or send data externally

Trust Score

C54/100

5/17 checks passed

Scores are informational only and provided “as is” without warranty. AgentHotspot assumes no liability for actions taken based on these ratings.

Quick Stats

Service TypeMCP

Pricing ModelFree

Capabilities29 Tools / 0 Prompts / 0 Resources

Owneramineelkouhen

CategoryData & Databases

DependenciesStandalone

Set Your Username