get_database_schema_info
Retrieve detailed schema information including objects, sizes, and permissions to analyze database organization and access patterns.
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)
Args: database_name: Database name to query (REQUIRED - specify which database to analyze) schema_name: Specific schema name to analyze (if None, shows all schemas)
Returns: Detailed database schema information including objects, sizes, and permissions
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database_name | Yes | ||
| schema_name | No |