Retool connects to most databases, including PostgreSQL, MySQL, MS SQL, and MongoDB. Here's a list of all the currently supported data sources.
The connection details required by Retool depend on the type of database you want to connect. This information generally includes a host, port, user credentials, and connection string. Refer to your database's configuration or documentation to obtain this.
Add Retool's IP addresses to your database's allowlist so that Retool can connect to your database.
126.96.36.199/32 188.8.131.52/32 184.108.40.206/30 220.127.116.11/30
If you aren't sure where to add these IP addresses, refer to your database's documentation.
Resources represent connections to data sources and are what you query within your Retool apps. Log in to Retool and navigate to the Resources tab. Click Create new > Create a new resource and select the database you want to connect to. This opens the Connect a resource page where you add your connection information.
After you enter your connection details, click Test Connection to check Retool can successfully connect. Once complete, click Create resource to save the resource, then click Create an app to start building a new app.
If the connection fails, verify your connection details are correct and that you added Retool's IP addresses to your allowlist.
In the App editor, update
query1 to retrieve some information from a table in your database.
Click Save & Run. Query results are automatically displayed after the query completes.
Updated about 1 month ago