By Maria Alonso
Published 11th January 2022
Deploying Retool with PostgreSQL
Retool is a low-code platform that makes it fast and easy to build internal tools. Retool offers many integrations through APIs to data sources like GraphQL, Firebase, MongoDB, Amazon S3, Google Sheets and more and allows you to create GUIs and dashboards around any of these. Developers can use Retool to quickly build powerful tools like dashboards, admin panels or custom apps.
This guide will walk you through the steps to deploy Retool from its official Docker image and set up a PostgreSQL database which Retool will use to store its configuration.
Create a new PostgreSQL database. In the networking options, keep TLS enabled and External Access disabled. You can start with the
nf-compute-10plan with 4GB of storage and one replica.
When TLS is enabled, a Let’s Encrypt TLS certificate is provisioned for the addon, which will ensure secure communication between the addon and the service we will later create in this project.
This PostgreSQL will store the Retool configuration data, not any analytics or dashboards. You will connect your databases or other data sources for GUIs or dashboards once Retool is set up.
Create a deployment service. Choose external image as deployment source and the image path will be
tryretool/backend:latestfrom DockerHub. By default Port 3000 will be publicly exposed with the HTTP protocol and Ports 3001 and 3002 will automatically be detected and created using the TCP protocol.
The configuration and deployment of the Retool instance requires more compute, therefore for this deployment service, we recommend starting with the
nf-compute-100-2plan (1 vCPU and 2048 MB memory) and one instance. Smaller plans may not be enough for Retool to start properly.
Create a new secret group which will store the environment variables and build arguments. We will manually add key value secrets and link the PostgreSQL database we created earlier.
The unique service code.run deployment URL or linked custom domain (hostname only)
Your license key for Retool
256 character random key
64 character random key
ENCRYPTION_KEYcan be generated using our random key generator in the secret groups or environment editors. Click the key icon in the top right to generate a random key.
If you are running Linux you can run
cat /dev/urandom | base64 | head -c 256and
cat /dev/urandom | base64 | head -c 64.
Descriptions for the keys required can be found in the Retool documentation here.
Inherited connection details from the database
Variable name Alias
All of the alias values can be found in this Github page, except the Alias for
tlsEnabledwhich is found in this Retool documentation page.
Inheriting environment variables ensures that the database connection details are automatically injected in the environment, avoiding the need to manually copy and paste them.
Once your secret group is created, go back to the deployment service and rollout restart the service to make sure the environment variables are updated. Once the restart is finished, go to the service URL where you will be prompted to create your Retool user and connect to your data sources!
Northflank allows you to deploy your code and databases within minutes. Sign up for a Northflank account and create a free project to get started.
- Multiple read and write replicas
- Observe & monitor with real-time metrics & logs
- Low latency and high performance
- Backup, restore and fork databases
- Private and optional public load balancing as well as Northflank local proxy
Deploying Metabase with PostgreSQL
Metabase is an easy and open-source way for everyone in your company to ask questions and learn from data. Once you connect your database to Metabase, you can begin to create insightful dashboards with a powerful user interface and without knowing SQL.
17th December 2021 • Adam Charvat