Health and performance · stop 3 of 13
table_stats
Shows size and activity for one table.
Works in read modeTool sets: dba · full
You might ask
“How big is the events table and when was it last vacuumed?”
Your assistant may call table_stats to answer.
How it works
- Size, row count, scans, inserts/updates/deletes, dead rows, last vacuum and analyze, plus per-column statistics.
Parameters
tablestringrequired- Table as "schema.name" (e.g. "public.orders"); a bare name is resolved if unambiguous.
connectionIdstring- Optional connection profile override — does not change session context.
databasestring- Database to use instead of the current one, on connectionId or the active connection.
What your assistant reads
The description nexql-mcp sends with the tool. It's how the assistant decides when to use it.
Get size, row-count, activity (scans, inserts/updates/deletes, dead tuples, vacuum/analyze times) and per-column statistics for a specific table.