postgres-list-schemas Tool
The “postgres-list-schemas” tool lists user-defined schemas in a database.
2 minute read
About
The postgres-list-schemas tool retrieves information about schemas in a
database excluding system and temporary schemas.
postgres-list-schemas lists detailed information as JSON for each schema. The
tool takes the following input parameters:
schema_name(optional): A text to filter results by schema name. Default:""owner(optional): A text to filter results by owner name. Default:""limit(optional): The maximum number of rows to return. Default:50.
Compatible Sources
This tool can be used with the following database sources:
| Source Name |
|---|
| PostgreSQL Source |
| AlloyDB for PostgreSQL Source |
| Cloud SQL for PostgreSQL Source |
Example
kind: tools
name: list_schemas
type: postgres-list-schemas
source: postgres-source
description: "Lists all schemas in the database ordered by schema name and excluding system and temporary schemas. It returns the schema name, schema owner, grants, number of functions, number of tables and number of views within each schema."
The response is a json array with the following elements:
{
"schema_name": "name of the schema.",
"owner": "role that owns the schema",
"grants": "A JSON object detailing the privileges (e.g., USAGE, CREATE) granted to different roles or PUBLIC on the schema.",
"tables": "The total count of tables within the schema",
"views": "The total count of views within the schema",
"functions": "The total count of functions",
}
Reference
| field | type | required | description |
|---|---|---|---|
| type | string | true | Must be “postgres-list-schemas”. |
| source | string | true | Name of the source the SQL should execute on. |
| description | string | false | Description of the tool that is passed to the LLM. |
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.