Cockroachdb MCP Server
@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.
基本信息
配置
使用下面的配置,将此服务器添加到你的 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 服务器
Postgres Mcp
crystaldbaPostgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.
Elasticsearch/OpenSearch MCP Server
cr7258A Model Context Protocol (MCP) server implementation that provides Elasticsearch and OpenSearch interaction.
MCP Server for MySQL based on NodeJS
benborlaA Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.
mcp_mysql_server
xwb602625136Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼!更加好用!不仅止于mysql的增删改查功能; 还包含了数据库异常分析能力;且便于开发者们进行个性化的工具扩展
mcp-server-qdrant: A Qdrant MCP server
qdrantAn official Qdrant Model Context Protocol (MCP) server implementation
评论