Internal Dashboards with Retool


This Page Is for an Old Version of

Some of the information may be out of date. If you have questions, please get in touch at [email protected]

Retool has become a very popular tool for companies to build internal dashboards. It allows first-class connections to Postgres resources, so creating a dashboard widget for data is really easy! We'll go over how to do that today.

For the purposes of this guide, I'll be using sample sales data from Kaggle. Once I have the csv file, I drag it into and create a new repository (this can be done either on the landing page or a repo you already have opened)


Once you have your data in, head to your Retool home page and create a new Postgres Resource in Retool. You can get all the details you need (hostname, port, username, password) all in the Connect menu at!


Creating a new Postgres resource in Retool


The Connect menu in your repository, which has everything you need to connect to your data.

Once you enter in the fields to connect to, your repo will be connected to Retool! Let's see how we can create a Retool widget to show this data:

To start, in your Retool app, create a new Resource query, and connect to the resource we just made.


From there, you can make any SQL query against your database. To keep it simple, we will copy-paste the SQL query from's query editor (make sure the remove the count identifier so we get the rows themselves).


Next paste that into the SQL editor on Retool. You can preview the query to make sure its working properly. Make sure to save the query!


From there, you can attach the query's data to a new table component.


And you're all set!

Using as the backend for your Retool dashboard allows the data on to act as one source of truth. You don't need to worry about potentially having multiple versions of your data strewn across data science and sales teams. It's also powerful for monitoring custom statistics: for example, your data science team can create custom views for important statistics for your organization. Retool can connect directly to these views, allowing your sales team to monitor vital statistics.

What did you think of this blog post? Was it helpful and/or was something confusing? Please let us know in the Discussions tab!