JDBCX MCP Server

pydbcx-mcp is a Python implementation of MCP server for enabling communication with diverse data sources via JDBCX server.

Installation

Start JDBCX server

Starts the JDBCX server container. Check out here for more information.

# Start the server
docker run --rm --name bridge -d -p8080:8080 jdbcx/jdbcx server
# Test if the server if ready
curl -v 'http://localhost:8080/config'
# Check server logs
docker logs --tail=100 -f bridge
# Shutdown the server
docker stop bridge

Configure MCP server

To install JDBCX MCP server for Claude Desktop automatically via Smithery:

npx -y @smithery/cli install @jdbcx/pydbcx-mcp --client claude

Alternatively, add the MCP server into your JSON config file.

Development/Unpublished Server Configuration

{
  "mcpServers": {
    "jdbcx": {
      "command": "uv",
      "args": [
        "--directory",
        "</path/to/your/pydbcx-mcp/dir>",
        "run",
        "pydbcx-mcp"
      ],
      "env": {
        "DEFAULT_QUERY_TIMEOUT_SECONDS": "30",
        "JDBCX_SERVER_URL": "http://localhost:8080/",
        "JDBCX_SERVER_TOKEN": "",
        "MAX_ROWS_LIMIT": "5000"
      }
    }
  }
}

Published Server Configuration

{
  "mcpServers": {
    "jdbcx": {
      "command": "uvx",
      "args": ["pydbcx-mcp"],
      "env": {
        "DEFAULT_DATA_FORMAT": "md"
      }
    }
  }
}

Published SSE Server Configuration

{
  "mcpServers": {
    "jdbcx": {
      "url": "http://localhost:8080/sse"
    }
  }
}

Note: remember to start the SSE server first by JDBCX_SERVER_URL=http://localhost:8080/ DEFAULT_QUERY_TIMEOUT_SECONDS=30 uvx pydbcx-mcp --transport sse.

Configuration

Configure the server using environment variables:

Variable	Description	Default
`JDBCX_LOG_LEVEL`	Log level	`DEBUG`
`JDBCX_SERVER_URL`	JDBCX server URL	`http://localhost:8080`
`JDBCX_SERVER_TOKEN`	JDBCX server access token	None
`DEFAULT_ACCEPT_ENCODING`	Default accept-encoding	`identity`
`DEFAULT_QUERY_TIMEOUT_SECONDS`	Default query timeout (seconds)	`10`
`DEFAULT_DATA_FORMAT`	Default data format (md, jsonl, csv)	`csv`
`DEFAULT_ROWS_LIMIT`	Default number of rows can be returned	`100`
`MAX_ROWS_LIMIT`	Maximum number of rows can be returned	`1000`
`MCP_TRANSPORT`	MCP server transport (stdio, see)	`stdio`
`MCP_SERVER_HOST`	MCP server listening address	`0.0.0.0`
`MCP_SERVER_PORT`	MCP server listening port	`8080`
`MCP_SERVER_NAME`	MCP server name	`JDBCX MCP Server`

Note: It is highly recommended to enable access token in JDBCX server and configure JDBCX_SERVER_TOKEN accordingly for security reason.

JDBCX MCP Server

JDBCX MCP Server

Installation

Start JDBCX server

Configure MCP server

Configuration

Related MCP Servers

mcp-jdbc

mcp-netbird

salesforce-mcp

OpenLink MCP Server for JDBCofficial

New MCP Servers