Connecting Retool to Supabase (Postgres Database & S3 Storage)

Hey there!

I'm excited to share a detailed tutorial on integrating Retool with Supabase.

Supabase is an incredible choice for Retool backends because it offers a highly scalable Postgres database and S3-compatible file storage, which is often preferred for production apps that need to scale beyond Retool's native database/storage.

What Does the Tutorial Cover?

In this video, I walk through the full, end-to-end setup process, tackling common configuration pitfalls along the way:

  1. Postgres Database Connection: How to correctly use the Session Puller connection string to set up your Supabase Postgres resource in Retool. This lets you run all your CRUD operations via SQL queries.
  2. S3 Storage Configuration: The specific steps needed to connect to Supabase's S3-compatible Storage. This includes:
  • Generating the necessary Access Keys and Secret Keys.
  • The crucial step of configuring the Custom S3 Endpoint URL in your Retool S3 resource (a step that frequently causes issues!).
  1. File Upload Example: A quick demonstration of building a Retool query to successfully upload a file to your Supabase storage bucket.

Why Connect to Supabase?

  • Scalability: Leverage the power of a dedicated, production-grade Postgres database.
  • Performance: Achieve potentially lower latency than some native options.

:movie_camera: Watch the Full Tutorial Here!

https://youtu.be/ZQhtM3gep1I


I hope this helps anyone looking to migrate or start a new project with a powerful external backend! Feel free to drop any questions.

Happy building!

4 Likes

Amazing! Great content, so helpful :shooting_star:

1 Like