pydbcx-mcp
If you are the rightful owner of pydbcx-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
pydbcx-mcp is a Python implementation of an MCP server that facilitates communication with various data sources through the JDBCX server.
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.
