get_mermaid_diagram
Generate Mermaid ER diagrams from SQL Server databases to visualize tables, columns, primary keys, and foreign key relationships with smart cardinality, saving diagrams to files for documentation and analysis.
Instructions
Generate a Mermaid ER diagram saved to a file. Shows tables, columns, PKs, and FK relationships with smart cardinality.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| serverName | Yes | Server name from list_servers | |
| databaseName | Yes | Database name from list_databases | |
| outputPath | Yes | File path for output (e.g. '/tmp/diagram.mmd') | |
| 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 non-key columns |