postgres-list-installed-extensions Tool

The “postgres-list-installed-extensions” tool retrieves all PostgreSQL extensions installed on a Postgres database.

About

The postgres-list-installed-extensions tool retrieves all PostgreSQL extensions installed on a Postgres database.

postgres-list-installed-extensions lists all installed PostgreSQL extensions (extension name, version, schema, owner, description) as JSON. The does not support any input parameter.

Compatible Sources

This tool can be used with the following database sources:

Source Name
PostgreSQL Source
⚠️ Source not found at path: integrations/alloydb-pg
Cloud SQL for PostgreSQL Source

Example

kind: tools
name: list_installed_extensions
type: postgres-list-installed-extensions
source: postgres-source
description: List all installed PostgreSQL extensions with their name, version, schema, owner, and description.

Reference

fieldtyperequireddescription
typestringtrueMust be “postgres-list-active-queries”.
sourcestringtrueName of the source the SQL should execute on.
descriptionstringtrueDescription of the tool that is passed to the LLM.