CockroachDB MCP Server

@Swayingleaves

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

Swayingleaves

CockroachDB MCP Server について

概要はまだありません

CockroachDB MCP Server の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "cockroachdb-mcp-server-swayingleaves": {
      "command": "npx",
      "args": [
        "-y",
        "@smithery/cli",
        "install",
        "@Swayingleaves/cockroachdb-mcp-server",
        "--client",
        "claude"
      ]
    }
  }
}

CockroachDB MCP Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

上のボタンで一時的なサンドボックスでこのサーバーを実行し、ツール一覧を取得できます。

概要

What is CockroachDB MCP Server?

CockroachDB MCP Server is an MCP server for Cursor that allows direct interaction with a CockroachDB database. It implements the Model Context Protocol (MCP) specification, providing tools, resources, and prompts for database operations.

How to use CockroachDB MCP Server?

Install dependencies with pip install -r requirements.txt and install uv via the official install script. Configure the server in Cursor by adding a JSON entry under mcpServers with the command uv, its arguments pointing to the server directory, and the JDBC URL, username, and password. The server can then be used through Cursor's MCP integration.

Key features of CockroachDB MCP Server

Connect to and disconnect from CockroachDB databases.
Retrieve all tables and table schema information.
Execute SQL queries directly.
Provide database status resources and SQL query templates.
Automatic reconnection and TCP keep-alive mechanisms.
Detailed rotating logs for troubleshooting.

Use cases of CockroachDB MCP Server

Query CockroachDB databases interactively from Cursor.
Browse database tables and their structures without a separate client.
Execute ad‑hoc SQL queries during development or debugging.

よくある質問

How do I connect to a CockroachDB database?

Use the `connect_database` or `initialize_connection` tool with the JDBC URL, username, and password.

What if I encounter connection problems?

Check the server log file `logs/cockroachdb_mcp.log` for details. Common issues include connection refused, authentication failed, and connection timeout.

Does the server handle special characters in passwords?

Yes, it uses psycopg2 which automatically handles special characters such as `@`, `%`, and `&` without requiring additional URL encoding.

How does the server prevent connection timeouts?

The server enables TCP keep‑alive by default: it sends keepalive packets after 30 seconds of idle time, every 10 seconds, and gives up after 5 attempts.

What transport does the server use?

The server runs as a subprocess via the `uv` command and communicates with Cursor through the MCP stdio transport. Authentication is passed as configuration parameters.

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

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.