Hi there, I have what I think is a very basic use case. Say you establish a ReTool app that manages a single table in Postgres. Is there a way in any of the ReTool API's to perform read/write operations on that table? If so, how would we do it and how is it secured? Thanks for any advice!

I've used workflows with a webhook trigger for this type of use-case before. For updates, you can post the data you want to update/insert to the webhook, and configure the workflow to insert the data from the payload into your postgres table. There's a template that is similar to this, called "Sync …

Does ReTool expose an API (REST, JS, etc) that would allow read/write of a Postgres table that a ReTool app manages?

💬 App Building

Darren May 17, 2025, 1:04am 4

Welcome to the community, @ericnograles! Thanks for reaching out.

I answered a similar question over here. Let me know if you have any clarifying questions.

Topic		Replies	Views
Documentation or advice on how to connect to Retool hosted Postgres db? 💬 App Building resource-connection	4	575	November 16, 2023
How to insert data to an existing Retool table using REST API? 💬 Queries and Resources	3	298	February 28, 2025
Should I use the retoolDB for an external app DB or connect retool and app to a hosted postgreSQL? 💬 App Building resource-connection , sql	4	458	September 2, 2024
How to query Retool from my React application? 💬 Queries and Resources javascript	2	584	July 27, 2023
Retool Database beta - backup + remote connection 💬 Queries and Resources	7	1414	July 27, 2023

Does ReTool expose an API (REST, JS, etc) that would allow read/write of a Postgres table that a ReTool app manages?

Related topics