# Sc Supabase

> (STUB / NOT IMPLEMENTED YET) Supabase backend as an alternative to self-hosted Convex. Create project, apply migrations from supabase/migrations, deploy Edge Functions, generate types. For projects where Postgres + Row-Level-Security is a better fit than Convex's reactive query model.

- Skill: `rahmanef63/sc-supabase` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add rahmanef63/sc-supabase`
- Raw SKILL.md: https://api.skillmd.com/api/skills/rahmanef63/sc-supabase/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: DevOps & Infra
- Author: rahmanef63 (https://skillmd.com/u/rahmanef63)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/rahmanef63/sc-supabase

---


# /sc-supabase — Supabase (STUB)

> **Status:** boilerplate only.

## When to use

- Project needs Postgres (relational, complex joins, mature SQL tooling) more than Convex's reactive model.
- Project wants Supabase Auth's social providers without self-hosting JWKS.
- Project already has Supabase migrations.

## Scope when implemented

- Provision a new Supabase project via the Management API.
- Apply `supabase/migrations/*.sql` in order.
- Deploy Edge Functions from `supabase/functions/`.
- Generate TypeScript types: `supabase gen types typescript`.
- Write `NEXT_PUBLIC_SUPABASE_URL` + `NEXT_PUBLIC_SUPABASE_ANON_KEY` to project `.env`.

## Env vars

| Var | Purpose |
|---|---|
| `SUPABASE_ACCESS_TOKEN` | Personal token, https://supabase.com/dashboard/account/tokens |
| `SUPABASE_ORG_ID` | Org to create projects under |

## Suggested file layout

```
sc-supabase/
├── SKILL.md
└── scripts/
    ├── project.js     # create + capture project ref + db password
    ├── migrate.js     # apply migrations
    ├── functions.js   # deploy edge functions
    └── types.js       # generate TS types
```

## Implementation notes

- API base: `https://api.supabase.com/v1`
- Auth: `Authorization: Bearer <SUPABASE_ACCESS_TOKEN>`
- Project creation returns a DB password ONCE — capture it directly into the selected Supabase named connection as a private one-time credential.
- For migrations, the `supabase` CLI may be required as a sub-process — wrap it in `lib/supabase.js` (TODO).