Postgres
Tools to query and explore a postgres database
1.0.1Arcade's Postgres toolkit connects agents to a PostgreSQL database, enabling schema discovery and read-only querying without any OAuth or API key flow.
Capabilities
- Schema & table discovery — enumerate all schemas and list all tables in the database before constructing any query.
- Table introspection — retrieve the full column structure of a specific table to ensure correct field names and types prior to querying.
- Read-only SQL execution — run
SELECTqueries with full support for joins, filters, aggregation, ordering, pagination (LIMIT/OFFSET), andHAVINGclauses;INSERT,UPDATE,DELETE, and DDL are blocked. - Guided query workflow — tools are designed to be called in a strict order (discover → inspect schema → query) to minimize runtime errors.
Secrets
POSTGRES_DATABASE_CONNECTION_STRING — A PostgreSQL connection string that encodes the host, port, database name, username, and password needed to reach your database instance. The standard format is postgresql://username:password@host:port/dbname (or postgres://...). Obtain the individual components from wherever your database is hosted — for example, the Connection or Database settings page of your cloud provider (e.g., AWS RDS, Supabase, Neon, Railway, Render, or a self-hosted server). Ensure the credentials belong to a database role with at least CONNECT and SELECT privileges on the target schemas and tables; granting write permissions is unnecessary and inadvisable. If your host requires SSL, append ?sslmode=require (or the appropriate sslmode value) to the connection string. See PostgreSQL connection URI documentation for full syntax details.
Store the secret in Arcade at https://api.arcade.dev/dashboard/auth/secrets and reference it in your tool configuration — see the Arcade secrets guide for setup instructions.
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 |