Add the CockroachDB MCP server to Claude Code

Config last verified Jun 1, 2026

The exact config to run CockroachDB in Claude Code — paste it in, restart, and the tools load.

Prerequisites

Claude Code installed.

Setup

1. Open `~/.claude.json`

2. Add this configuration

Add to ~/.claude.json

~/.claude.json

json

{
  "mcpServers": {
    "cockroachdb": {
      "command": "uvx",
      "args": [
        "--from",
        "git+https://github.com/amineelkouhen/mcp-cockroachdb.git",
        "cockroachdb-mcp-server",
        "--url",
        "postgresql://root@localhost:26257/defaultdb"
      ],
      "env": {
        "CRDB_HOST": "<CRDB_HOST>",
        "CRDB_PORT": "<CRDB_PORT>",
        "CRDB_DATABASE": "<CRDB_DATABASE>",
        "CRDB_USERNAME": "<CRDB_USERNAME>",
        "CRDB_PWD": "<CRDB_PWD>"
      }
    }
  }
}

Or via CLI

bash

claude mcp add cockroachdb -- uvx --from git+https://github.com/amineelkouhen/mcp-cockroachdb.git cockroachdb-mcp-server --url postgresql://root@localhost:26257/defaultdb

3. Restart Claude Code and confirm the CockroachDB tools load.

Gotchas

Claude Code stores MCP servers under an "mcpServers" object in ~/.claude.json. It also reads a project-scoped .mcp.json and supports adding servers from the command line with "claude mcp add". Each entry must declare either a "type" or a "command"; Claude Code refuses an entry that has neither. Remote servers connect natively over Streamable HTTP with OAuth.

← Back to the CockroachDB MCP server