Core Library

The PostgreSQL web IDE you've always wanted Query your Postgres data to safely and easily write, update, and delete without accidentally dropping tables. You can also inspect your schema, save and share queries, and run ad hoc analyses quickly. Pull queries into a text or table component for easy reference and inspection.

Industry

Software as a Service•

End users

Engineering•

Components

Table

Text

Text Input

Dropdown

Components

Build from a handful of drag-and-drop components

Table display the output of a query and control your table appearance and the visible columns.

Text the simplest components out there — use text components statically as labels, or dynamically to display values.

Button trigger actions that do things like run queries, export data, or open other apps.

Text Input take a text input to modify the parameters of a query — say the `ILIKE` in a SQL statement, or a URL parameter in a REST query based on the value of the component.

Dropdown allow users to select one value from a list of options.

Container organize your admin panel by using containers as top-level components and to nest other components.

Data source

Connect directly to your PostgreSQL database, run raw SQL, issue commands via a GUI and easily 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 a SQL query and marks that user as approved.

1. Create resource

2. Read data

3. Connect data with UI

Related use cases

What you can build with Retool

Discount approval tool

Build a tool to validate, approve, and keep track of discounts and offer redemptions.

Know Your Customer (KYC) user explorer

Build a KYC user explorer and move new customers through the KYC compliance process faster than ever.

Inventory management dashboard

Build an app to see what's in stock, add SKUs, track the status of orders.

From startups to Fortune 500s, the world's most effective teams use Retool to build custom business software. Our customers

Dean McRobie

CTO at CommonBond

I tell every technology leader I talk to that they should look at Retool as a way to reduce the burden of building admin UIs and democratize that kind of stuff across their company.

Try Retool today

Start building an internal tool or customer portal in under 10 minutes

Schedule a demo