Core Library

The PostgreSQL admin console you’ve always wanted Query your Postgres data via raw SQL or use Retool's GUI wrapper to safely 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

A fast and simple PostgreSQL admin console

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

Experiment tracking tool

Build a custom experiment tracking tool to keep tabs on the experiments you run and grow your business faster.

Inventory management dashboard

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

Discount approval tool

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

A fast and simple PostgreSQL web IDE

Build on PostgreSQL in half the time with our easy to use web IDE.

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

Adam Louie

Senior Director of Business Operations at LeadGenius

Retool has enabled us to completely remodel and refine our systems, which in turn has freed up valuable engineering resources equivalent to 2-3 full stack engineers.

Try Retool today

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

Schedule a demo

dev