MCP.so
ログイン

JDBC-MCP - Database Access for AI Assistants

@guanghuang

JDBC-MCP - Database Access for AI Assistants について

JDBC MCP modified from quarkus-mcp-servers

基本情報

カテゴリ

データベース

ライセンス

Apache-2.0 license

ランタイム

java

トランスポート

stdio

公開者

guanghuang

設定

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

{
  "mcpServers": {
    "jdbc-mcp": {
      "command": "docker",
      "args": [
        "run",
        "-d",
        "--name",
        "jdbc-mcp",
        "\\"
      ]
    }
  }
}

ツール

ツールは検出されませんでした

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is JDBC-MCP - Database Access for AI Assistants?

JDBC-MCP is a Model Context Protocol (MCP) server that enables AI assistants to interact with databases through JDBC connections. It allows large language models (LLMs) to inspect, query, create, and modify database content. This fork of the Quarkus MCP JDBC Server adds Docker deployment support and enhanced security with write queries disabled by default.

How to use JDBC-MCP - Database Access for AI Assistants?

Run the server as a Docker container using either SSE (Streaming Server Events) or STDIO transport. Set required environment variables (jdbc.url, jdbc.user, jdbc.password) and optionally enable.write.sql. For STDIO with Claude Desktop, configure the Docker command in claude_desktop_config.json. An environment file (.env) can be used for configuration.

Key features of JDBC-MCP - Database Access for AI Assistants

  • Docker deployment via SSE or STDIO transport.
  • Write queries (INSERT, UPDATE, DELETE) disabled by default for security.
  • Supports multiple database types through JDBC.
  • Configurable via environment variables.
  • Compatible with Claude Desktop and other MCP clients.

Use cases of JDBC-MCP - Database Access for AI Assistants

  • AI assistants querying read-only database content.
  • Developers inspecting database schemas with a language model.
  • Securely modifying database records when explicitly enabled.
  • Automating database interactions from containerized environments.

FAQ from JDBC-MCP - Database Access for AI Assistants

How do I enable write operations?

Set the environment variable enable.write.sql=true when running the Docker container.

What database types are supported?

For details on supported JDBC variants, refer to the original Quarkus MCP JDBC Server documentation.

How can I restrict the server to read-only access?

Leave enable.write.sql unset or set to false (the default). Also use a read-only database user for additional security.

What transport modes are available?

SSE (HTTP) and STDIO. For SSE, the endpoint is http://localhost:8080/mcp/sse. STDIO requires the environment variables quarkus.mcp.server.stdio.enabled=true, quarkus.log.console.enable=false, and quarkus.log.console.stderr=false.

Where does the data live?

The server connects to an external database specified by the jdbc.url; data remains in that database. The server itself does not store data persistently.

コメント

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