Table/schema details and statistics
get_table_stats_and_schemaInspect Unity Catalog table schemas, columns, partitioning, and optional file or row statistics. List tables in a catalog.schema when given a two-part name.
Instructions
Inspect a Unity Catalog table (catalog, schema, type, format, columns with types, nullability, comments, partition columns, location, owner, properties, row filter/masks presence) plus optional statistics (file count, size, partitioning, row count). Given a two-part 'catalog.schema' name, lists the tables in that schema (paginated).
Safety classification: depends on input (EXECUTION, READ_ONLY).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | Fully qualified table 'catalog.schema.table' for one table, or 'catalog.schema' to list the tables in a schema. | |
| stats | No | none: Unity Catalog metadata only. metadata: also DESCRIBE DETAIL (files, size, partitioning) on a warehouse. exact_count: also SELECT COUNT(*) (scans the table). auto: metadata only if a warehouse is already running (never starts one). | auto |
| page_size | No | Max items to return (server caps this). | |
| page_token | No | next_page_token from a previous response. | |
| warehouse_id | No | SQL warehouse id. If omitted: DBX_MCP_DEFAULT_WAREHOUSE_ID, else automatic selection (reported in the response). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data | No | ||
| page | No | ||
| plan | No | ||
| tool | Yes | ||
| action | No | ||
| safety | No | ||
| status | No | success | |
| summary | Yes | ||
| warnings | No | ||
| next_steps | No | Suggested follow-up calls. | |
| request_id | No |