list_hg_schemas
Retrieve all user-created schema names from a Hologres database to understand its structure and available data organization.
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 'list_hg_schemas' tool: defines SQL query to list all non-system schemas from information_schema.tables.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)Registers the 'list_hg_schemas' tool in list_tools(), including description and empty input schema.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 'list_hg_schemas': empty object with no required properties.inputSchema={ "type": "object", "properties": {}, "required": [] }