Floralé relies on Supabase for its PostgreSQL database, Row Level Security policies, authentication, and theDocumentation Index
Fetch the complete documentation index at: https://mintlify.com/dlampatricio/florale/llms.txt
Use this file to discover all available pages before exploring further.
product-images storage bucket. This guide walks you through creating a brand-new Supabase project, wiring up the environment variables, and running the schema migration so the app is ready to use in minutes.
Create a Supabase account
Go to supabase.com and sign up for a free account, or sign in if you already have one. The free tier is sufficient to run Floralé in development and for low-traffic production stores — it includes 500 MB of database storage, 1 GB of file storage, and up to 50,000 monthly active users.
Create a new project
From your Supabase dashboard, click New project.Fill in the following details:
- Name — e.g.
floraleorflorale-production - Database password — choose a strong, unique password and save it somewhere safe (you will need it if you ever connect via a direct Postgres client)
- Region — pick the region closest to your users to minimize latency; for Uruguay-based customers, South America (São Paulo) is a good default
- Pricing plan — Free is fine to start
Copy the Project URL and anon key
Once your project is ready, navigate to Project Settings → API in the left sidebar.Under Project URL, copy the URL (it looks like
https://xxxxxxxxxxxxxxxxxxxx.supabase.co).Under Project API keys, copy the anon / public key.Open (or create) .env.local in the Floralé project root and add both values:Copy the Service Role key
Still on the Project Settings → API page, find the service_role / secret key under Project API keys. Click the eye icon to reveal it, then copy it.Add it to
.env.local:Open the SQL Editor
In the Supabase dashboard left sidebar, click SQL Editor, then click New query to open a blank editor pane. This is where you will run the Floralé schema migration in the next step.
Run the schema SQL
Copy the full contents of
supabase-schema.sql from the project root (or see the Database Schema page for the complete listing) and paste it into the SQL Editor.Click Run (or press Ctrl+Enter / Cmd+Enter). The script will:- Create the
categoriesandproductstables - Add an index on
products(category_id)for fast category filtering - Seed two default categories (
cajas,desayunos) and ten sample products - Enable Row Level Security on both tables with public-read / authenticated-write policies
- Create the
product-imagesstorage bucket with matching access policies
Success. No rows returned message for each statement.The schema seeds two default categories — Cajas de Regalo (
cajas) and Desayunos (desayunos) — along with ten sample products spread across both categories. All INSERT statements use ON CONFLICT (id) DO NOTHING, so re-running the script is safe and will not duplicate data.Create an admin user (optional)
The Floralé admin panel at
/admin/login uses Supabase Auth to authenticate store managers. To create your first admin user:- In the Supabase dashboard, go to Authentication → Users.
- Click Add user → Create new user.
- Enter an email address and a strong password.
- Click Create user.
http://localhost:3000/admin/login (or your production URL) using those credentials. Authenticated users are permitted to insert, update, and delete products and categories per the RLS policies applied in the schema.