amineelkouhen/mcp-cockroachdb
Developer tools이 페이지는 AI로 자동 번역되었습니다. 기술적인 세부 사항은 원문을 확인하세요. 원문 보기
The CockroachDB MCP Server is a natural language interface designed for agentic applications to manage, monitor and query data in CockroachDB.
개요
The CockroachDB MCP Server is a designed for LLMs and agentic applications to manage, monitor, and query data in CockroachDB. It integrates seamlessly with clients, such as Claude Desktop or Cursor, enabling AI-driven workflows to interact directly with your database. - : AI agents can query and transact via natural language. - : Cluster status, node health, replication, slow queries, contention, index recommendations. - : List, create, drop, and switch databases. - : Create, drop, alter (add/drop/rename column), truncate, rename, describe; bulk-import; indexes, views, schemas. - : Parameterized SQL with json/csv/table output, multi-statement transactions, explain, history. - : Provision SQL users and roles, grant/revoke privileges. Lets you run the agent under a scoped non-root user. - : Similarity search with cosine/L2/inner-product metrics (auto-detected from index opclass), C-SPANN ANN index management (v25.2+).
README
원문 README의 일부입니다. 원문 보기.
CockroachDB MCP Server
Overview
The CockroachDB MCP Server is a natural language interface designed for LLMs and agentic applications to manage, monitor, and query data in CockroachDB. It integrates seamlessly with MCP (Model Content Protocol) clients, such as Claude Desktop or Cursor, enabling AI-driven workflows to interact directly with your database.
Table of Contents
- Overview
- Features
- Tools
- Installation
- Configuration
- Integrations
- Testing
- Contributing
- License
- Quality Badge
- Contact
Features
- Natural-Language Queries: AI agents can query and transact via natural language.
- Cluster Monitoring: Cluster status, node health, replication, slow queries, contention, index recommendations.
- Database Operations: List, create, drop, and switch databases.
- Table Management: Create, drop, alter (add/drop/rename column), truncate, rename, describe; bulk-import; indexes, views, schemas.
설치
docker run --rm --name cockroachdb-mcp-server -e CRDB_HOST=<cockroachdb_host> -e CRDB_PORT=<cockroachdb_port> -e CRDB_DATABASE=<cockroachdb_database> -e CRDB_USERNAME=<cockroachdb_user> mcp-cockroachdb설정
{
"mcpServers": {
"cockroach": {
"command": "<full_path_uv_command>",
"args": [
"--directory",
"<your_mcp_server_directory>",
"run",
"src/main.py"
],
"env": {
"CRDB_HOST": "<your_cockroachdb_hostname>",
"CRDB_PORT": "<your_cockroachdb_port>",
"CRDB_DATABASE": "<your_cockroach_database>",
"CRDB_USERNAME": "<your_cockroachdb_user>",
"CRDB_PWD": "<your_cockroachdb_password>",
"CRDB_SSL_MODE": "disable|allow|prefer|require|verify-ca|verify-full",
"CRDB_SSL_CA_PATH": "<your_cockroachdb_ca_path>",
"CRDB_SSL_KEYFILE": "<your_cockroachdb_keyfile_path>",
"CRDB_SSL_CERTFILE": "<your_cockroachdb_certificate_path>",
}
}
}
}