CockroachDB MCP

A Model Context Protocol server that provides a natural-language interface for LLMs and agents to manage, monitor, and query data in CockroachDB. Supports schema exploration, query plan inspection, and running SQL, with a read-only-by-default posture so agents can investigate a distributed SQL cluster safely.

{
  "mcpServers": {
    "cockroachdb": {
      "command": "npx",
      "args": [],
      "env": {
        "COCKROACHDB_URL": "<YOUR_COCKROACHDB_URL>"
      }
    }
  }
}

{
  "type": "object",
  "required": [
    "sql"
  ],
  "properties": {
    "sql": {
      "type": "string",
      "description": "SQL statement to execute"
    }
  }
}

{
  "type": "object",
  "properties": {
    "table": {
      "type": "string",
      "description": "Optional table name to describe"
    }
  }
}