postgres-list-tables Tool
less than a minute
About
The postgres-list-tables tool retrieves schema information for all or
specified tables in a Postgres database.
postgres-list-tables lists detailed schema information (object type, columns,
constraints, indexes, triggers, owner, comment) as JSON for user-created tables
(ordinary or partitioned). The tool takes the following input parameters: *
table_names (optional): Filters by a comma-separated list of names. By
default, it lists all tables in user schemas.* output_format (optional):
Indicate the output format of table schema. simple will return only the
table names, detailed will return the full table information. Default:
detailed.
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: postgres_list_tables
type: postgres-list-tables
source: postgres-source
description: Use this tool to retrieve schema information for all or
specified tables. Output format can be simple (only table names) or detailed.
Reference
| field | type | required | description |
|---|---|---|---|
| type | string | true | Must be “postgres-list-tables”. |
| source | string | true | Name of the source the SQL should execute on. |
| description | string | true | Description of the tool that is passed to the agent. |
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.