List extensions
pg_extensionsLists installed and installable PostgreSQL extensions, with versions, schemas, upgrade options, and superuser requirements. Use it to see database capabilities and missing extensions.
Instructions
List the extensions installed in this database (version, schema, whether a newer version can be installed with ALTER EXTENSION ... UPDATE, comment) and the ones the server could install with CREATE EXTENSION.
Use it to see what a database can do (pg_stat_statements, PostGIS, pgvector, pg_cron...)
and what is missing. pattern filters by name (* wildcard); only_installed skips the
available list. For the available ones it says whether installing needs a superuser
(trusted extensions, PostgreSQL 13+, only need CREATE on the database). pg_extension_report
describes one installed extension.
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_extensions"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| pattern | No | ||
| connection | No | ||
| only_installed | No |