◌

Postgres

Connect to a PostgreSQL database and run parameterized SQL queries. Reads are enabled by default; writes require explicit per-connection approval.

Credentials form3 native toolsIcon needs-review

This catalogue entry describes the current repository definition. Availability, scopes, and production readiness should be confirmed during private-beta onboarding.

Native tools

POST

postgres_query

Run one parameterized SQL statement. Reads are always available; writes require connection-level approval.

native://postgres/query

3 parameters

Param	Type	Required	Description
sql	string	required	One parameterized PostgreSQL statement. Use $1, $2, ... placeholders for values.
params	array	optional	Optional scalar values matching the SQL placeholders.
maxRows	integer	optional	Maximum number of rows to return (1-1000; defaults to 100).

POST

postgres_list_tables

List tables and views in a PostgreSQL schema.

native://postgres/list_tables

1 parameter

Param	Type	Required	Description
schema	string	optional	Schema name; defaults to public.

POST

postgres_describe_table

List the columns and types for a PostgreSQL table.

native://postgres/describe_table

2 parameters

Param	Type	Required	Description
schema	string	optional	Schema name; defaults to public.
table	string	required	Table name to describe.

Request private-beta access