List tables
pg_list_tablesList PostgreSQL tables, views, materialized and foreign tables with estimated rows, disk size, and comments; filter by schema or name pattern and sort by size to find large tables.
Instructions
List tables (and optionally views, materialized views, foreign tables) with estimated row count, size on disk and comment.
Filter by schema and by a name pattern (* and ? wildcards; plain text matches
any name containing it). order_by="size" finds the biggest tables. Partitions are
hidden behind their parent unless include_partitions is true. Row counts are the
planner's estimates: instant, and close enough to choose a strategy.
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "pg_list_tables"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| kinds | No | ||
| limit | No | ||
| offset | No | ||
| schema | No | ||
| pattern | No | ||
| order_by | No | name | |
| connection | No | ||
| include_partitions | No |