get_schema_overview
Generate a markdown overview of database schema structure including tables, columns, data types, primary keys, foreign keys, constraints, and defaults. Filter by schemas or tables to focus on specific database components.
Instructions
Markdown overview of database schema: tables, columns, types, PKs, FKs, unique/check constraints, defaults. Use get_plantuml_diagram for visual ER output or describe_table for single-table detail.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| serverName | Yes | Server name from list_servers | |
| databaseName | Yes | Database name from list_databases | |
| includeSchemas | No | Optional comma-separated schemas to include (e.g. 'dbo,sales'). Overrides excludeSchemas. | |
| excludeSchemas | No | Optional comma-separated schemas to exclude (e.g. 'audit,staging'). Ignored if includeSchemas set. | |
| includeTables | No | Optional comma-separated tables to include (e.g. 'Users,Orders'). Overrides excludeTables. | |
| excludeTables | No | Optional comma-separated tables to exclude. Ignored if includeTables set. | |
| maxTables | No | Max tables to include (1-200, default 50) | |
| compact | No | true/false. Show only PK/FK columns without data types |