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:
- 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.
- 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!).
- 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.
Watch the Full Tutorial Here!
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!