postgres-list-views
The “postgres-list-views” tool lists views in a Postgres database, with a default limit of 50 rows.
About
The postgres-list-views tool retrieves a list of top N (default 50) views from a Postgres database, excluding those in system schemas (pg_catalog, information_schema). It’s compatible with any of the following sources:
postgres-list-views lists detailed view information (schemaname, viewname, ownername) as JSON for views in a database. The tool takes the following input parameters:
viewname(optional): A string pattern to filter view names. The search uses SQL LIKE operator to filter the views. Default:""limit(optional): The maximum number of rows to return. Default:50.
Example
tools:
list_views:
kind: postgres-list-views
source: cloudsql-pg-source
Reference
| field | type | required | description |
|---|---|---|---|
| kind | string | true | Must be “postgres-list-views”. |
| source | string | true | Name of the source the SQL should execute on. |
| description | string | false | Description of the tool that is passed to the agent. |