profile_table

Scope: read · Signature: profile_table(workspace_id: str, table: str, columns: list[str] | None = None) -> Any

Use for one-call table triage before writing SQL.

Returns row_count, per-column SUMMARIZE statistics (type, min/max, quartiles, null_percentage), n_distinct (exact when n_distinct_exact, else an estimate on a very large table), and top values for the low-cardinality columns. table must be a name EXACTLY as describe_catalog reports it (works for inputs AND published result views). columns narrows the profile. For distribution questions beyond this, use query_sql.

Typed output: schema table_profile — generated from the backend pydantic model by scripts/export_mcp_schemas.py (the same SSOT as the React client types).

Powered by: DuckDB SUMMARIZE over the lakehouse views.