MCP.so
登录

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.

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

常见问题

1

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.

2

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.

3

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.

4

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.

5

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 服务器