Build internal tools with PostgreSQL
Retool makes it easy to build admin panels, dashboards, and utilities on top of your PostgreSQL data.
Connecting Retool to Postgres takes just a few minutes, and lets you quickly build internal tools like admin panels on top of your Postgres data.
Retool connects directly to your PostgreSQL database and lets you use SQL to manage the data in your PostgreSQL tables. For example, you can render users from Postgres into a Table and add a button that, when clicked, runs an SQL query and marks that user as approved.
Retool supports both reading to and writing from Postgres. When writing data, we give you a point and click interface that makes it easy to perform the actions you want and hard to unintentionally do anything destructive.
Rohan Chopra
Director of Engineering at Doordash
These tools took months to build, but without them, our operators were completely blocked.
Supported operations for PostgreSQL
Read documentationView your data
Visualize and search all of your database tables.
Insert a record
Insert a record in an existing table.
Delete a record
Delete an existing record from an existing table.
Update or create a new record
Update a record in an existing table, or optionally create a new record if none is found.
Update an existing record
Update an existing record in an existing table.
Join with other datasources
Easily join with other Retool connected datasources like GraphQL or the Twilio API.
Bulk insert records
Insert a list of records into an existing table.
Bulk update via a primary key
Update a group of records using a column as a primary key.
Bulk upsert via a primary key
Insert a list of rows (or update if existing rows are found) using a column as a primary key.
What you can build with Retool
View all templatesIn Retool, you can join PostgreSQL with anything
Retool connects to most databases and nearly anything with a REST or GraphQL API. Read in data from mongoDB, join it via SQL, record user approvals, and POST the result to Stripe to create invoices.
Retool empowers you to work with all of your data sources inside of a single app.
