# Integrating Supabase

> Supabase Flutter integration for PostgreSQL, Auth, Realtime subscriptions, Storage, Edge Functions, and Row Level Security. Use when building backend features with supabase_flutter or configuring database policies.

- Skill: `poorgramer-zack/integrating-supabase` (Agent Skill, multi-file: 8 files)
- Install (CLI): `npx skillmds@latest add poorgramer-zack/integrating-supabase`
- Raw SKILL.md: https://api.skillmd.com/api/skills/poorgramer-zack/integrating-supabase/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Security
- Author: Poorgramer-Zack (https://skillmd.com/u/poorgramer-zack)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/poorgramer-zack/integrating-supabase

---


# Supabase Flutter Ecosystem (`supabase_flutter`)

## Goal
[Supabase](https://supabase.com/) is an open-source Firebase alternative built on **PostgreSQL**, supporting rich SQL queries, table joins, and a first-class Flutter SDK (`supabase_flutter`).

To ensure modularity and LLM readability, this skill is split into logical chapters. Before answering questions or writing code related to Supabase, you **MUST read the relevant reference chapters**.

## Process/Workflow
1. Identify the core Supabase service the user needs (Database, Auth, Storage, etc.).
2. **Read** the corresponding chapter(s) from the `references/` directory.
   - Example: If the user asks about deep linking Magic Links for login, read `01-setup.md` and `02-auth.md`.
3. Synthesize the guidelines exactly as documented within the chapters. **DO NOT hallucinate third-party packages or outdated practices**.
4. Maintain the Serverpod Mini BFF (Backend-For-Frontend) architecture whenever the user requires executing high-privilege operations that should bypass Row Level Security (RLS) entirely.

## Reference Files

*   **Setup & Deep Links**: Read [01-setup.md](./references/setup.md) for core initialization and the `app_links` requirement.
*   **Authentication**: Read [02-auth.md](./references/auth.md) for Email/OTP, Apple/Google native sign-in, and listening to stream changes.
*   **Database (Postgres)**: Read [03-database.md](./references/database.md) for strongly-typed `Freezed` mapping, `.select()`, and join strategies natively.
*   **Realtime & Presence**: Read [04-realtime.md](./references/realtime.md) for Postgres CDC subscriptions and User Presence management.
*   **Storage**: Read [05-storage.md](./references/storage.md) for cross-platform (Mobile vs Web) bucket manipulation.
*   **Edge Functions**: Read [06-edge-functions.md](./references/edge-functions.md) for executing remote serverless workflows.
*   **Serverpod Mini (BFF)**: Read [07-serverpod-mini.md](./references/serverpod-mini.md) for leveraging the pure `supabase` Dart library combined with the `SERVICE_ROLE_KEY` inside a secure backend.