Does Retool integrate with PostgreSQL?
Yes — native integration
Yes. PostgreSQL is one of Retool's native resource types. You create a PostgreSQL resource, enter the host, port, database, and credentials, optionally enable SSL or an SSH tunnel, test the connection, and start querying. Retool supports both SQL reads and GUI-based writes against the database.
| Integration method | Native — PostgreSQL is a first-class, built-in Retool resource type. You create a PostgreSQL resource, supply connection credentials, and query it in SQL (read) or GUI (insert/update/delete) mode. No middleware is involved. |
|---|---|
| Sync direction | Two-way: Retool supports SQL mode for reads and GUI mode for write operations (insert, update, delete) against the database. |
| Plan required | No paid plan required to add a PostgreSQL resource. Self-hosted and cloud Retool both include it. Paid tiers add features like AWS IAM authentication and outbound region/static-IP controls. |
| Setup time | ~10 minutes unverified estimate |
How to connect Retool to PostgreSQL
- In Retool, open Resources and click "Create new" → "Resource", then select the PostgreSQL tile.
- Name the resource and enter the connection credentials: host, port (default 5432), database name, username and password.
- If the database isn't publicly reachable, enable the SSH tunnel option; for encrypted connections, enable SSL and supply CA/client certificates as needed.
- Click "Test connection" to confirm Retool can reach the database (allowlist Retool's outbound IPs on your firewall if the test fails).
- Click "Create resource", then build queries in an app — SQL mode for reads, GUI mode for inserts, updates and deletes.
Known friction points
- If the PostgreSQL server isn't publicly accessible, the connection test will fail until you configure an SSH tunnel or allowlist Retool's outbound IP addresses (cloud) / expose the database to your self-hosted Retool deployment. [source]
FAQ
- Does Retool integrate with PostgreSQL?
- Yes, natively. PostgreSQL is a built-in Retool resource type. You create a PostgreSQL resource with your connection credentials, test it, and then query the database directly — SQL mode for reads, GUI mode for inserts, updates and deletes. No middleware required.
- Can Retool write to a PostgreSQL database, or only read?
- Both. Retool supports SQL queries for reading and a GUI mode for write operations (insert, update, delete) against PostgreSQL resources.
- Do I need a paid Retool plan to connect to PostgreSQL?
- No. Adding a PostgreSQL resource works on free and self-hosted Retool. Paid tiers add features such as AWS IAM authentication and outbound region controls, but they aren't required for a basic connection.
✓ Last verified: 2026-06-10 · Every claim on this page links to a primary source. If the integration changed, the page is out of date — check the sources below.
Sources
- Retool docs — Connect to PostgreSQL (accessed 2026-06-10)
- Retool community — How to connect to a PostgreSQL database (accessed 2026-06-10)