Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MCP_TRANSPORT | No | MCP server transport (stdio, see) | stdio |
| MAX_ROWS_LIMIT | No | Maximum number of rows can be returned | 1000 |
| JDBCX_LOG_LEVEL | No | Log level | DEBUG |
| MCP_SERVER_HOST | No | MCP server listening address | 0.0.0.0 |
| MCP_SERVER_NAME | No | MCP server name | JDBCX MCP Server |
| MCP_SERVER_PORT | No | MCP server listening port | 8080 |
| JDBCX_SERVER_URL | No | JDBCX server URL | http://localhost:8080 |
| DEFAULT_ROWS_LIMIT | No | Default number of rows can be returned | 100 |
| JDBCX_SERVER_TOKEN | No | JDBCX server access token | |
| DEFAULT_DATA_FORMAT | No | Default data format (md, jsonl, csv) | csv |
| DEFAULT_ACCEPT_ENCODING | No | Default accept-encoding | identity |
| DEFAULT_QUERY_TIMEOUT_SECONDS | No | Default query timeout (seconds) | 10 |
Schema
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| list_database_servers | List all available database servers configured in the JDBCX server. |
| inspect_database_server | Get structural metadata for a specific database server, including its catalogs, schemas, and tables. May take minutes for large servers. |
| query_database | Execute a SQL query against a specified database server and return formatted results. Maybe slow for complex queries. |