Skip to main content
Glama

JDBCX MCP Server

query_database

Execute SQL queries on registered database servers with specified timeout and data format options. Returns results in markdown, JSON Lines, or CSV for efficient data retrieval.

Instructions

Execute a SQL query against a specified database server and return formatted results. Maybe slow for complex queries.

Args: database_server (str): The name of the database server to query (must be registered) sql_query (str): The SQL query to execute (will be wrapped in a SELECT statement) query_timeout_seconds (int, optional): Maximum time in seconds to wait for query execution. Defaults to DEFAULT_QUERY_TIMEOUT_SECONDS. data_format (str, optional): Output format for results. Options: "md" - Markdown table format "jsonl" - JSON Lines format (one JSON object per row) "csv" - Comma-separated values with header row Defaults to DEFAULT_DATA_FORMAT. rows_limit (int, optional): Maximum number of rows to return. Defaults to DEFAULT_ROWS_LIMIT. Returns: str: Query results as a string in the specified format

Input Schema

NameRequiredDescriptionDefault
data_formatNocsv
database_serverYes
query_timeout_secondsNo
rows_limitNo
sql_queryYes

Input Schema (JSON Schema)

{ "properties": { "data_format": { "default": "csv", "enum": [ "md", "jsonl", "csv" ], "title": "Data Format", "type": "string" }, "database_server": { "title": "Database Server", "type": "string" }, "query_timeout_seconds": { "default": 10, "title": "Query Timeout Seconds", "type": "integer" }, "rows_limit": { "default": 100, "title": "Rows Limit", "type": "integer" }, "sql_query": { "title": "Sql Query", "type": "string" } }, "required": [ "database_server", "sql_query" ], "title": "query_databaseArguments", "type": "object" }
Install Server

Other Tools from JDBCX MCP Server

Related Tools

    MCP directory API

    We provide all the information about MCP servers via our MCP API.

    curl -X GET 'https://glama.ai/api/mcp/v1/servers/jdbcx/pydbcx-mcp'

    If you have feedback or need assistance with the MCP directory API, please join our Discord server