Cockroachdb MCP Server

@amineelkouhen

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

amineelkouhen

投稿者

Amine El Kouhen

Cockroachdb MCP Server について

The CockroachDB MCP Server is a natural language interface designed for agentic applications to manage, monitor and query data in CockroachDB.

#database #mcp#cockroachdb#llm #generative-ai #mcp-server

Cockroachdb MCP Server の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "cockroach": {
      "command": "docker",
      "args": [
        "run",
        "--rm",
        "-i",
        "-e",
        "CRDB_HOST=<cockroachdb_host>",
        "-e",
        "CRDB_PORT=<cockroachdb_port>",
        "-e",
        "CRDB_DATABASE=<cockroachdb_database>",
        "-e",
        "CRDB_USERNAME=<cockroachdb_user>",
        "mcp-cockroachdb"
      ]
    }
  }
}

Cockroachdb MCP Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is Cockroachdb MCP Server?

Cockroachdb MCP Server is a natural language interface that enables LLMs and agentic applications to manage, monitor, and query data in CockroachDB. It integrates with MCP (Model Context Protocol) clients such as Claude Desktop and Cursor, allowing AI-driven workflows to interact directly with the database.

How to use Cockroachdb MCP Server?

Install and run the server using uvx with a CockroachDB connection URI or individual parameters. Alternatively, use a Docker image or clone the repository for development. Configure via command-line arguments or environment variables (e.g., CRDB_HOST, CRDB_PORT, CRDB_DATABASE). Connect any MCP client (like Claude Desktop) by editing its config file to point to the server.

Key features of Cockroachdb MCP Server

Natural language queries and transaction creation
Cluster health and node status monitoring
Database operations: create, drop, list, switch
Table management including indexes, views, and schemas
SQL query execution with JSON, CSV, or table formatting
Multi-statement transaction support and query plan analysis

Use cases of Cockroachdb MCP Server

AI agents querying CockroachDB using natural language
Monitoring cluster health and replication status
Managing schemas, tables, and indexes programmatically
Running and analyzing SQL queries through an LLM interface

よくある質問

What runtime dependencies does it require?

Python 3.13 or higher is required. The recommended way to run it is via `uvx` (from `uv` package manager) or using Docker.

How do I connect the server to my CockroachDB instance?

You can provide a connection URI (`--url postgresql://user:pass@host:port/db`) or specify individual parameters like `--host`, `--port`, `--db`, `--user`, and `--password`. SSL/TLS options are also available for secure connections.

What transport protocols does it support?

Currently only the `stdio` transport is supported. Support for `streamable-http` transport will be added in a future release.

Where does the data reside?

The server connects to your own CockroachDB instance; it does not store data itself. All data operations are executed directly against the database you specify.

Are there any known limitations or breaking changes?

The `main` branch is under active development and may contain breaking changes. It is recommended to use a tagged release (e.g., `0.1.0`) for stable usage.

「データベース」の他のコンテンツ

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note