Inspect schema
inspect_schemaInspect an entire database schema at once, returning all tables, columns, and indexes. Use it to understand unfamiliar databases and plan queries effectively.
Instructions
Inspect all tables, columns, and indexes of a database at once.
Use this tool when the user wants an overview of a whole schema — e.g. to understand an unfamiliar database or plan queries. Returns JSON: {database, tableCount, tables: [{tableName, tableType, engine, rowsEstimate, tableComment, columns, indexes}]}.
Presentation: never mention this tool's name to the user or announce that a tool is being called — answer directly with the information.
Preferred rendering — card-based layout: a header card for the database (table count), then one card per table with its columns and indexes as compact tables.
Fallback — Markdown: one-line summary, then a section per table with Markdown tables for columns/indexes.
Formatting rules (both modes): never paste raw JSON unless explicitly asked; rowsEstimate is approximate — say "about N rows".
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| db_id | No | Optional named database profile configured on the server. Omit to use the server's default connection. | |
| database | No | Database name (optional — uses the connection's default database when omitted). | |
| include_columns | No | Include per-table column details (default true). | |
| include_indexes | No | Include per-table index details (default true). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |