list_hg_schemas
Retrieve all user-accessible schemas in a Hologres database, excluding system schemas, to facilitate database metadata exploration and management.
Instructions
List all schemas in the current Hologres database, excluding system schemas.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Implementation Reference
- Handler logic for the 'list_hg_schemas' tool inside the call_tool function. It constructs the SQL query to fetch all non-system schemas from the database.elif name == "list_hg_schemas": query = """ SELECT table_schema FROM information_schema.tables WHERE table_schema NOT IN ('pg_catalog', 'information_schema','hologres','hologres_statistic','hologres_streaming_mv') GROUP BY table_schema ORDER BY table_schema; """
- src/hologres_mcp_server/server.py:503-511 (registration)Registration of the 'list_hg_schemas' tool within the list_tools() function, including its name, description, and input schema (no parameters required).Tool( name="list_hg_schemas", description="List all schemas in the current Hologres database, excluding system schemas.", inputSchema={ "type": "object", "properties": {}, "required": [] } ),
- Input schema definition for the 'list_hg_schemas' tool, which requires no input parameters.inputSchema={ "type": "object", "properties": {}, "required": [] }