amineelkouhen/mcp-cockroachdb
Developer toolsЭта страница переведена автоматически. Технические детали смотрите в оригинале. Открыть оригинал
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>",
}
}
}
}