JDBC MCP Server

JDBC MCP Server

A local MCP server for read-only access to PostgreSQL, Oracle, and Microsoft SQL Server databases. It lets AI agents such as Claude Code, Cursor, VS Code Copilot, and others write SQL queries, inspect execution plans, and explore database structure: tables, columns, indexes, foreign keys, views, functions, and sequences.

PostgreSQL, Oracle, and Microsoft SQL Server JDBC drivers are bundled into the fat jar, so no extra driver installation is required.

The server exposes 49 MCP tools and can optionally expose catalog-qualified MCP resources for table and column metadata. Tools may update the local SQLite catalog, but they never write to the inspected PostgreSQL, Oracle, or SQL Server database.

One server process can serve several databases: name them in connections.json and pass connection to any tool. The tool manifest stays a single set regardless of how many databases are configured, and pools are opened only for the databases actually used.

Quickstart

1. Get the jar — download jdbc-mcp-server.jar from the latest release (JDK 21+ required; all JDBC drivers are bundled), or build it yourself:

./gradlew bootJar   # → build/libs/jdbc-mcp-server.jar

2. Describe your databases in ~/.jdbc-mcp-server/connections.json:

{
  "connections": {
    "myapp": {
      "url": "jdbc:postgresql://db.example.com:5432/myapp",
      "username": "ai_readonly",
      "password": "secret",
      "description": "Application database — customers, orders, shipments"
    }
  }
}

Use a read-only database user; five minutes there outweighs every other protection in this server.

3. Register the server with your MCP client — with no database settings in the client config:

{
  "command": "java",
  "args": ["-jar", "<absolute-path>/jdbc-mcp-server.jar"],
  "env": {}
}

For Claude Code that is one command:

claude mcp add --scope user jdbc java -jar /path/to/jdbc-mcp-server.jar

4. Ask the agent for listConnections. It answers with the databases this server serves; every other tool takes that name as its first argument:

{"connection": "myapp", "sql": "SELECT count(*) FROM orders"}

Full details: Databases and Credentials, Connecting an AI Client, Serving Several Databases from One Server.

Databases and Credentials

Every database this server serves is described in one JSON file. Nothing about a database — URL, credentials, schema, timeouts, limits — comes from the environment.

The connections file

Shortened. The full README is on GitHub.