Cockroachdb MCP Server

Name: Cockroachdb MCP Server
Author: amineelkouhen

@amineelkouhen

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

基本情報

カテゴリ

データベース

トランスポート

stdio

公開者

amineelkouhen

投稿者

Amine El Kouhen

設定

以下の設定を使って、このサーバーを 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"
      ]
    }
  }
}

ツール

ツールは検出されませんでした

ツールは 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

FAQ from Cockroachdb MCP Server

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.

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

mcp_mysql_server

xwb602625136

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能；还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245