database

Database

Schema files, migrations, and type generation. Architecture and core rules are in the builder agent.

Schema File Organization

supabase/database/
├── cluster/
│   └── extensions/                     # one file per extension (cluster-level)
│       ├── pg_graphql.sql
│       ├── pg_net.sql
│       ├── pg_cron.sql
│       └── pgmq.sql
├── rbac/                               # RBAC reference DATA (rows, not schema)
│   ├── roles.sql                       # synced by the RBAC reconcile, NOT by db apply
│   ├── permissions.sql
│   └── role_permissions.sql
├── config/                             # role-level settings pg-delta can't model (imperative)
│   └── db_pre_request.sql              # ALTER ROLE authenticator SET pgrst.db_pre_request
├── queue/                              # pgmq queues — imperative, prod-safe, self-healing
│   └── agentlink_tasks.sql             # DO $$ … pgmq.create('agentlink_tasks') … $$
├── cron/                               # pg_cron jobs — imperative
│   └── process-stale-tasks.sql         # fires the queue worker every minute
├── storage/                            # buckets + storage.objects policies — imperative
│   └── avatars.sql
└── schemas/                            # DECLARATIVE — applied by db apply / diffed into migrations
    ├── api/                            # functions only — never create tables here
    │   ├── schema.sql                  # CREATE SCHEMA api + grants / default privileges
    │   └── functions/
    │       ├── tenant_create.sql       # one RPC per file
    │       ├── profile_get.sql
    │       └── chart_create.sql        # custom api.chart_create
    └── public/
        ├── schema.sql                  # public schema-level grants (e.g. supabase_auth_admin USAGE)
        ├── tables/
        │   ├── profiles.sql            # one table + its grants/RLS/indexes/triggers
        │   ├── tenants.sql
        │   └── charts.sql              # custom entity table (example)
        └── functions/
            ├── _auth_tenant_id.sql     # one function per file
            ├── _internal_admin_handle_new_user.sql
            └── _hook_before_user_created.sql