List schemas
pg_list_schemasLists database schemas with owners, comments, table/view/sequence/function counts, and approximate sizes, excluding system schemas unless requested, to support initial database exploration.
Instructions
List the schemas (namespaces) of the database with owner, comment, how many tables, views, sequences and functions each holds, and approximate size.
The first step when exploring a database. System schemas (pg_catalog,
information_schema) are left out unless include_system is true. Sizes come from the
planner statistics, so they are instant and slightly behind; pg_sizes measures.
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_schemas"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connection | No | ||
| include_system | No |