get_database_schema_info
Retrieve schema names, owners, permissions, object lists, and size statistics for a PostgreSQL database to analyze namespace structure and access.
Instructions
[Tool Purpose]: Retrieve detailed information about database schemas (namespaces) and their contents
[Exact Functionality]:
Show all schemas in a database with their owners and permissions
Display schema-level statistics including table count and total size
List all objects (tables, views, functions) within specific schema
Show schema access privileges and usage patterns
[Required Use Cases]:
When user requests "database schema info", "schema overview", "namespace structure", etc.
When analyzing database organization and schema-level permissions
When exploring multi-schema database architecture
[Strictly Prohibited Use Cases]:
Requests for actual data inside tables
Requests for schema structure changes or DDL operations
Requests for individual table details (use get_table_schema_info for that)
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"database_name": "<database_name>"
},
"name": "get_database_schema_info"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema_name | No | Specific schema name to analyze (if None, shows all schemas) | |
| database_name | Yes | Database name to query (REQUIRED - specify which database to analyze) |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |