Skip to main content
Add a full-stack backend with a single prompt.Supabase is an open-source backend platform that bundles a PostgreSQL database, user authentication, file storage, and edge functions into a single service.When you connect Supabase to Rocket, you can describe features like “add user login” or “create a products table” in chat and Rocket generates the complete implementation: database schemas, auth flows, storage buckets, row-level security policies, and API calls.Supabase is the foundational backend for most Rocket apps. It pairs naturally with Stripe (for payments), Resend or SendGrid (for transactional emails), and much more.You need:

What you can use it for

Add sign-up, login, password reset, and protected routes with email/password or social providers like Google and GitHub.Try this prompt:
Add user authentication with email/password sign-up, login, and a protected
dashboard page. Include a forgot-password flow.
Rocket creates: sign-up and login forms, Supabase Auth configuration, session management, protected route middleware, and password reset emails.
Push live updates to your UI whenever rows are inserted, updated, or deleted in your Supabase tables.Try this prompt:
Show a table of orders with status, amount, and customer name.
Use Supabase real-time subscriptions so the table updates instantly when new orders come in.
Rocket creates: database table schema, real-time subscription logic, a sortable data table UI, and role-based access.
Let users upload images, documents, or other files with secure access controls.Try this prompt:
Add a profile page where users can upload an avatar image. Store the file
in Supabase Storage and display it on their profile.
Rocket creates: file upload component, Supabase Storage bucket with access policies, image preview, and database column linking the avatar URL to the user record.
Store and manage structured content in Supabase tables with row-level security policies that control who can read, create, edit, and delete each row.Try this prompt:
Create a posts table in Supabase with title, content, author, and published status.
Add row-level security so only the author can edit or delete their own posts.
Rocket creates: posts table schema, row-level security policies, CRUD operations, and author-scoped access control.
Create a backend where multiple organizations each see only their own data, with invite flows and role management.Try this prompt:
Build a multi-tenant app where users belong to organizations. Each org
has its own projects and members. Add invite-by-email and admin/member roles.
Rocket creates: organizations and memberships tables, row-level security policies scoped by org, invite system with email notifications, and role-based UI that shows admin controls only to org admins.

Detailed setup

Connect Supabase to Rocket

Choose your connection method

You can connect Supabase from a few different places:Method 1: From Account Settings
  • On the top-right corner of the homepage, click .
Profile icon button beside My Projects
  • Choose Account Settings
Account Settings
  • Click on the Integrations tab in the left menu.
Open Integration tabOpen Integration tab
  • Click Connect next to the Supabase option.
Connect Supabase integrationConnect Supabase integration
Method 2: From a Rocket project
  • Open any project and go to Integrations.
Integrations tabIntegrations tab
  • Scroll to Supabase and click Connect.
Supabase connect in IntegrationsSupabase connect in Integrations
Method 3: From Chat
  • If your prompt includes terms like “auth” or “database,” Rocket will suggest connecting.
  • Click Connect in the popup.
Supabase connect in chatSupabase connect in chat

Authorize your Supabase account

  • A secure Supabase authorization popup appears.
  • Sign in and review the requested permissions.
  • Click Authorize Rocket to continue.
Supabase OAuth screenSupabase OAuth screen
You will be asked to create or select your organization.If you do not have one yet:
  • You will be prompted to create one first.
Create Supabase orgCreate Supabase org
  • Click Create organization, then Rocket redirects you to select it.
If you already have one:
  • Select it from the dropdown.
Supabase OAuth screen with organization createdSupabase OAuth screen with organization created
  • Click Authorize Rocket to connect.
After authorization, you will see a confirmation message and be redirected back to Rocket with Supabase connected.

Need to create or select a Supabase project?

Once your Supabase account is authorized and your organization is selected, you will be prompted to link a project.If you already have one:
  • Choose it from the dropdown list.
Select Supabase projectSelect Supabase project
If you do not:
  • Click Create new Supabase project to open a quick-setup popup.
Create Supabase projectCreate Supabase project
  • Set your project name, password, and region.
  • Click Create a new project.
Want to switch projects later?
  • Head to Integrations and use the Supabase project dropdown to select a different project.
To disconnect only the currently linked project:
  • Go to Integrations.
  • Click Disconnect project.
Disconnect one projectDisconnect one project
You can disconnect Supabase from either global settings or from an individual project.Option A: From global Settings
  • Go to Account Settings > Integrations.
  • Click Disconnect next to the Supabase option.
  • In the popup that appears, click Yes, disconnect to confirm, or click to cancel.
Supabase disconnect popupSupabase disconnect popup
Option B: From an open project
  • Open the project that is connected to Supabase.
  • Go to Integrations.
  • Click Disconnect next to the org name under the Supabase option.
Disconnect via project settingsDisconnect via project settings

Prompt cookbook

Copy-paste these prompts after connecting Supabase to build common features:
Use casePrompt
User auth with emailAdd email/password sign-up and login with a protected dashboard page.
Database tablesCreate a products table with name, description, price, and image URL. Add a page to list and filter products.
File storageLet users upload profile avatars. Store images in Supabase Storage and display them on the profile page.
Edge functionsCreate a Supabase Edge Function that sends a welcome email when a new user signs up.
Row-level securityAdd row-level security so users can only read and edit their own records in the posts table.
Social loginAdd Google and GitHub login options to the sign-up page using Supabase Auth.
Real-time subscriptionsShow a live feed of new messages in the chat room using Supabase real-time subscriptions.
Email templatesCustomize the Supabase confirmation email template to match my app's branding.
Multi-tenant dataScope all queries to the current user's organization using RLS policies.
Password resetAdd a forgot-password page that sends a reset link via Supabase Auth.

Tips and limitations

  • OAuth connection, no manual API keys. Rocket connects to Supabase through OAuth, so you never need to copy or paste API keys.
  • One Supabase project per Rocket project. Each Rocket project links to a single Supabase project. Use different Rocket projects if you need separate databases.
  • Free tier limits. The Supabase free plan includes two projects, 500 MB database storage, and 1 GB file storage. Check the Supabase pricing page for current limits.
  • Use edge functions for server-side logic. When you need to run code that should not be exposed to the client (like sending emails or calling third-party APIs), ask Rocket to create a Supabase Edge Function.
  • Supabase dashboard for advanced operations. Row-level security debugging, database extensions, and connection pooling settings are managed directly in the Supabase dashboard.

Advanced guides

What’s next?