Skip to main content
Aurora’s native Supabase integration lets you manage both your front-end UI and your back-end database through a single, easy-to-use chat interface. In other words, you can design your app’s screens and set up a cloud PostgreSQL database without leaving Aurora. This unified approach makes powerful app development accessible to everyone – non‑technical users can rely on Aurora’s guidance, while experienced developers can tap into advanced Supabase features as needed.

​
Overview

Supabase is an open-source alternative to Firebase, providing a hosted PostgreSQL database with real-time capabilities, user authentication, file storage, and serverless functions. By connecting Supabase to your Aurora app, you instantly gain a production-ready backend without writing any boilerplate code or manually configuring servers. Supabase’s intuitive web dashboard makes it easy to manage your data and users, and its robust SQL foundation means you retain the full power and scalability of a PostgreSQL database.

​
Key features unlocked by Supabase integration

  • Database (PostgreSQL) – Store and query your app data with full SQL support. Aurora can automatically generate the necessary tables and schema based on your prompts.
  • User Authentication – Securely manage user sign-ups, logins, and access control. Aurora can add pre-built authentication flows (email/password, etc.) to your app with a simple prompt.
  • File Storage – Upload and serve images or other files via Supabase Storage. Great for user profile photos, uploads, or any static media your app needs to handle.
  • Real-time Updates – Supabase can stream live data changes to your app. This enables features like live chat, activity feeds, or collaborative dashboards that update instantly for all users.
  • Edge Functions (Serverless) – Run custom backend logic (in JavaScript/TypeScript) on Supabase’s infrastructure. Aurora will create and deploy these functions for tasks like sending emails, processing payments, or integrating with external APIs.

​
Why use Aurora’s Supabase integration?

With Aurora, you don’t have to juggle separate tools for front-end design and back-end setup. By simply conversing with Aurora’s AI, you can build your UI and have the underlying database and server functions created for you automatically. This means faster development and fewer integration headaches. For example, if you prompt Aurora with “Add a user feedback form and save responses to the database,” Aurora will generate the form UI and set up a Supabase table to store the feedback – all in one go. This seamless end-to-end generation is Aurora’s unique strength, empowering beginners to build complex apps and allowing power users to move faster.

​
Getting Started: Connecting Supabase to Aurora

Connecting a Supabase backend to your Aurora project is straightforward. You’ll need a Supabase account (free tier is fine) and an Aurora project ready.
1

Create a Supabase account

Register a new Supabase account at supabase.com or sign in if you already have one. No credit card required for the free tier.
2

Create a new project in Supabase

Click on + New Project, complete the necessary fields, and allow a few minutes for setup.
3

Initiate the Supabase connection in Aurora

In the Aurora editor, open the Integrations menu (usually found in the top-right toolbar). Click Connect Supabase. Aurora will prompt you to log in to Supabase if you aren’t already.
4

Authorize and select or create a project

A Supabase login screen will appear. Sign into your Supabase account and authorize Aurora. Next, you’ll be asked to choose a Supabase organization and project to link with your Aurora app. You can select an existing project or create a new one on the spot.
5

Wait for configuration to complete

After selecting the project, Aurora will automatically configure the connection. Within a few seconds, you should see a confirmation message in the chat (e.g. ”✅ Supabase connected”). At this point, your Aurora app is now linked to the Supabase database – ready to use authentication, data storage, and other backend features.
Both Aurora and Supabase offer generous free tiers for development. If your app grows or requires advanced features, you may eventually need paid plans for each service separately.

​
Adding User Authentication

One of the first things you’ll likely want is user authentication (so people can sign up and log into your app). Aurora’s Supabase integration makes this trivial to set up via chat.

​
Email and Password (Basic Setup)

Once your project is connected to Supabase, Aurora can generate authentication pages for you. For example, you can simply prompt: “Add login”. This will typically create a basic login page (and related signup flow) in your app, wired up to Supabase’s authentication system. After Aurora adds the login UI, you have a couple of ways to create users for testing:
  • Via your app’s signup form: Use the newly added interface in your app to register a user (this will communicate with Supabase to create the account).
  • Via Supabase Dashboard: Go to your Supabase project’s dashboard, navigate to Authentication > Users, and manually add a new user (email and password).
For development convenience, we recommend disabling email confirmation in Supabase while you test. This way, users can log in immediately without needing to verify an email. To do this, open your Supabase dashboard and go to Authentication > Settings (or Providers) > Email, then disable the “Confirm email” requirement. You can re-enable confirmations later in production for security.

​
Social Logins (e.g. Google)

Supabase supports OAuth logins like Google, GitHub, Twitter, and more. You can integrate these into your Aurora app as well:
  1. Enable the provider in Supabase: In your Supabase dashboard, navigate to Authentication > Providers. You’ll see a list of external login providers. Toggle on Google (for example) and follow the instructions to provide the required OAuth Client ID and Secret from Google. Save the settings – your Supabase project now knows how to handle Google logins.
  2. Update your Aurora app’s UI: Next, you can prompt Aurora to add a social login option. For instance: “Add a ‘Sign in with Google’ button to the login page.” Aurora will modify the authentication page, adding a Google sign-in button and the necessary code to initiate the OAuth flow via Supabase.
Once this is done, users of your app will be able to click “Sign in with Google”, be redirected to Google for authentication, and then return to your app as logged-in users.

​
Managing Data with Supabase

Beyond authentication, the core of most apps is reading and writing data. With Aurora and Supabase, you can create database tables and connect them to your UI without leaving the chat prompt.

​
Creating Database Tables via Aurora

1

Describe the feature and data you need

In Aurora’s chat, request a feature that involves data storage. For example: “Add a feedback form and save responses in a database table.” Be as clear as possible about what data you want to store.
2

Review the generated SQL snippet

Aurora’s AI will propose updates to your app. Since your request involves storing data, Aurora will also produce a SQL schema snippet – essentially the commands to create the necessary table(s) or columns in Supabase. This snippet appears in the chat or sidebar for you to copy.
3

Run the SQL in Supabase

Open your Supabase dashboard and go to the SQL Editor. Paste the SQL snippet from Aurora and execute it, which will create the new table (or alter an existing table) in your database. You can verify in the Supabase Table Editor that the table now exists with the specified columns.
4

Confirm and let Aurora finish integration

Back in Aurora, confirm that you ran the SQL. Aurora will then finalize the integration: it updates your app’s UI to bind form inputs, lists, or other components to the new Supabase table.
You didn’t have to manually design a database schema or write any backend code – Aurora and Supabase handled it from your description. You can repeat this process for any new data feature (blog posts, comments, products, etc.).

​
File Storage (Images & Media)

When your Aurora app needs to handle file uploads (for example, user profile pictures, attachments, or any media), Supabase integration has you covered. Supabase includes a Storage service for hosting files (images, videos, PDFs, etc.) conveniently alongside your database. If you add an Upload component or an image upload feature in your Aurora app, Aurora will utilize Supabase Storage behind the scenes. Uploaded files will be stored in a storage bucket within your Supabase project, and you’ll get a URL or reference to use for displaying or downloading the file later.
By default, Supabase’s free tier allows files up to 50MB each to be uploaded. This is plenty for most images or short videos. If your app needs to handle larger files, Supabase’s paid plans support bigger uploads.
Example: Suppose your app has user profiles and you want users to add a profile picture. You might prompt Aurora: “Add a profile picture upload to the account settings page.” Aurora will create the UI for uploading an image. Thanks to the Supabase integration, when a user uploads a file, it’s saved in your Supabase Storage, and Aurora will handle retrieving that image URL to display the profile picture in your app.

​
Storing Secrets (API Keys & Config)

Many applications require secret keys or API credentials to connect with third-party services — for example, Stripe for payments or OpenAI for AI features. When Supabase is connected, Aurora offers a secure way to manage and use these secrets. Aurora automatically detects when a feature requires a secret and prompts you with a UI to input the necessary values. These secrets are stored securely in Supabase’s Edge Function secret manager for your project. They are encrypted and kept safe on the backend. For example, if you integrate Stripe for payments, you would store your Stripe Secret Key as a secret. When Aurora deploys a payment-processing function to Supabase, it will automatically include that key from the secret store so the function can authenticate with Stripe. This way, you never have to hard-code secrets into your app.

​
Backend Logic with Edge Functions

Sometimes your app needs custom backend logic beyond basic data CRUD (Create, Read, Update, Delete). Supabase Edge Functions are serverless functions (similar to AWS Lambda) that let you run code on the backend triggered by events or requests. Aurora’s integration means you can define desired backend behavior in plain language, and Aurora will write and deploy the necessary Edge Function code to Supabase for you.

​
Typical use cases for Edge Functions:

  • Using AI services (e.g. processing input with OpenAI or Anthropic APIs)
  • Sending emails or notifications (e.g. welcome email when a user signs up)
  • Processing payments (e.g. creating a checkout session with Stripe)
  • Scheduled tasks (e.g. cleanup or summary jobs)
  • Complex computations or third-party integrations
To add a backend function, simply describe what you need in the Aurora chat. For example: “When a user submits the feedback form, analyze the text using OpenAI and store a sentiment score.” Aurora will generate the code for this logic as a Supabase Edge Function and deploy it to your Supabase project.
Before going live: Supabase’s default security rules are permissive for development, but you should set up Row Level Security (RLS) policies to protect your data in production. RLS allows you to define who can read or write each row in your database tables. Always review and test these policies in the Supabase dashboard under Auth > Policies.