Postgres
Tools to query and explore a postgres database
1.0.2Arcade's Postgres toolkit connects agents to a PostgreSQL database, enabling schema discovery, table inspection, and read-only SQL querying.
Capabilities
- Schema & table discovery — enumerate all schemas and tables in a database before constructing queries, ensuring exact identifiers are known.
- Table structure inspection — retrieve column definitions, types, and index information for any named table prior to querying.
- Read-only querying — execute parameterized
SELECTstatements with full support for joins, filtering, aggregation, ordering, and pagination; no write operations (INSERT,UPDATE,DELETE) are permitted. - Guided query construction — built-in rules enforce best practices: always select explicit columns, use case-insensitive and trimmed string comparisons, prefer
LIKEover regex, and join only on indexed or primary-key columns.
Secrets
POSTGRES_DATABASE_CONNECTION_STRING — A standard PostgreSQL connection URI (e.g., postgresql://user:password@host:5432/dbname) that includes the hostname, port, database name, username, and password. Construct this string from your database host's credentials; the exact format is documented in the libpq connection string reference. For managed providers (AWS RDS, Google Cloud SQL, Supabase, etc.), retrieve the host, port, and credentials from that provider's console and assemble the URI manually. Ensure the database user has at least CONNECT and SELECT privileges on the relevant schemas and tables.
Store this secret in Arcade by following the Arcade secrets guide or add it directly via the Arcade dashboard.
Available tools(4)
| Tool name | Description | Secrets | |
|---|---|---|---|
Discover all the schemas in the postgres database. | 1 | ||
Discover all the tables in the postgres database when the list of tables is not known.
ALWAYS use this tool before any other tool that requires a table name. | 1 | ||
You have a connection to a postgres database.
Execute a SELECT query and return the results against the postgres database.
No other queries (INSERT, UPDATE, DELETE, etc.) are allowed.
ONLY use this tool if you have already loaded the schema of the tables you need to query.
The final query will be constructed as follows:
SELECT {select_query_part} FROM {from_clause} JOIN {join_clause}
WHERE {where_clause} HAVING {having_clause}
ORDER BY {order_by_clause} LIMIT {limit} OFFSET {offset}
When running queries, follow these rules which will help avoid errors:
* Never "select *" from a table. Always select the columns you need.
* Always order your results. Use the most important columns or the primary key if you're unsure.
* Always use case-insensitive queries to match strings in the query.
* Always trim strings in the query.
* Prefer LIKE queries over direct string matches or regex queries.
* Only join on columns that are indexed or the primary key. Do not join on arbitrary columns. | 1 | ||
Get the schema/structure of a postgres table in the postgres database
when the schema is not known, and the name of the table is provided.
This tool should ALWAYS be used before executing any query.
All tables in the query must be discovered first,
so that their exact names are known. | 1 |