list_databases
Retrieve a list of available Hydrolix databases to enable schema exploration and data querying within LLM-based workflows via the mcp-hydrolix server.
Instructions
List available Hydrolix databases
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Implementation Reference
- mcp_hydrolix/mcp_server.py:130-145 (handler)The main handler function for the 'list_databases' tool. It connects to Hydrolix using the request credential, executes 'SHOW DATABASES', parses the result into a list of database names, and returns them as JSON.
@mcp.tool() def list_databases(): """List available Hydrolix databases""" logger.info("Listing all databases") client = create_hydrolix_client(get_request_credential()) result = client.command("SHOW DATABASES") # Convert newline-separated string to list and trim whitespace if isinstance(result, str): databases = [db.strip() for db in result.strip().split("\n")] else: databases = [result] logger.info(f"Found {len(databases)} databases") return json.dumps(databases) - mcp_hydrolix/mcp_server.py:130-145 (registration)The @mcp.tool() decorator registers this function as an MCP tool named 'list_databases' with the FastMCP server instance.
@mcp.tool() def list_databases(): """List available Hydrolix databases""" logger.info("Listing all databases") client = create_hydrolix_client(get_request_credential()) result = client.command("SHOW DATABASES") # Convert newline-separated string to list and trim whitespace if isinstance(result, str): databases = [db.strip() for db in result.strip().split("\n")] else: databases = [result] logger.info(f"Found {len(databases)} databases") return json.dumps(databases)