PostgreSQL

Connect to PostgreSQL or Postgres-compatible databases (incl. Redshift, Aurora DSQL, CockroachDB) for read-only queries

Connect with: API key · Type: postgres · Tools: 3

Tool		What it does
postgres_describe_table	read	Show columns, types, constraints, and indexes for a specific table in the connected PostgreSQL database.
postgres_list_tables	read	List all tables in the connected PostgreSQL database with their schema, estimated row counts, and descriptions.
postgres_run_query	read	Execute a read-only SQL query against the connected PostgreSQL database.

Tool names are suffixed with the connection they run against when you have more than one — postgres_describe_table@production. With a single connection the bare name works.