Extension report
pg_extension_reportInspect an installed PostgreSQL extension to report its version, schema, created objects, settings, and extension-specific details such as indexes, jobs, or foreign tables.
Instructions
Report on one installed extension: version, schema, the objects it created (functions, types, tables, operators), its settings, and extension-specific facts.
Specific parts exist for pg_stat_statements (entries), pg_buffercache (cache summary), pg_trgm (trigram indexes), hypopg (hypothetical indexes), vector/pgvector (vector columns, hnsw and ivfflat indexes), postgis (version, geometry columns, SRID, spatial indexes), pg_cron (jobs and last runs), pg_partman (configured tables), pgaudit, postgres_fdw and dblink (servers, foreign tables, never user mapping options), pgstattuple, pgcrypto and timescaledb (hypertables). Any other extension gets the generic part. If the extension is not installed the error says how to install it; pg_extensions lists what exists.
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": {
"extension": "<extension>"
},
"name": "pg_extension_report"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| extension | Yes | ||
| connection | No |