Flarite Docs

Supabase Integration

Query your database, inspect projects, manage users, and explore edge functions — without writing code.

What you can do

  • Projects — List all Supabase projects under your account.
  • Schema Explorer — Inspect tables, columns, and database relationships.
  • SQL Runner — Execute raw SQL queries (read and write) directly from the chat.
  • Edge Functions — List, inspect, and invoke your Supabase Edge Functions.
  • Storage — Browse buckets and manage storage objects.
  • Auth & Users — View registered users and their metadata.
  • RLS Audit — Quickly check which tables have Row-Level Security enabled.

Getting your Supabase Personal Access Token

Flarite uses your Personal Access Token (PAT) — not your project's service role key. The PAT allows management-level operations across all your projects via the Supabase Management API.

  1. Go to supabase.com/dashboard → Account → Access Tokens.
  2. Click "Generate new token".
  3. Give it a name like "Flarite Access" and click Generate token.
  4. Copy the token — it will look like sbp_xxxxxxxx...
  5. Paste it into Flarite → Supabase → API Tokens.
💡
NoteOptionally, enter a Project Reference ID if you want Flarite to default to a specific project. You can find the Project Ref in your Supabase dashboard URL: supabase.com/dashboard/project/[your-ref]. Leave blank to auto-discover from your first project.
⚠️
ImportantYour PAT grants access to all projects in your Supabase account. Treat it like a password. Flarite encrypts it with AES-256 before storage and never exposes it to the AI model.

Example prompts

"List all my Supabase projects"

"Show me the tables in my production database"

"Which tables don't have row-level security enabled?"

"Run this query: SELECT count(*) FROM users WHERE created_at > now() - interval '7 days'"

"List all edge functions in project xyzabcdefg"

"Show me storage buckets and their public/private status"

Important notes

  • SQL queries run directly against your database — write operations will affect real data.
  • The Supabase Management API is separate from your project's database API. Flarite uses both as needed.
  • Free-tier Supabase projects may be paused. Flarite will report a project status of INACTIVE for paused projects.