A fast and simple PostgreSQL client

The PostgreSQL client 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

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

A fast and simple PostgreSQL web IDE

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

Food delivery tracker

Build a customer support tool tailored to food delivery and two-sided marketplaces use cases.

Experiment tracking tool

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

Customer onboarding dashboard

A dashboard to help you vet partners and customers before you start doing business with them.

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

Eddy Kim

Engineering Manager at Verishop

Using Retool, we've built internal tools for our retail and merchandising teams quickly, while maintaining our speed on feature development for our shoppers.

Try Retool today

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

Schedule a demo