Compact schema overview
pg_schema_overviewMap a PostgreSQL schema into a compact overview of tables, keys, row counts, views, and routines to guide query writing before deeper table inspection.
Instructions
Give a compact map of one schema that costs few tokens: one line per table in the
form orders(id bigint PK, customer_id int FK->customers.id, status order_status)
with primary keys, foreign key targets, unique columns and the estimated row count,
then the views (with their columns) and the number of functions, procedures and
sequences.
Use it first when you need to write queries against a schema. Partitions are folded
into their parent. limit caps the number of tables. For one table in full detail use
pg_describe_table.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"schema": "<schema>"
},
"name": "pg_schema_overview"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| schema | Yes | ||
| connection | No |