# Supabase Deployment

> Deploy Supabase schema changes, manage migrations, maintain production database integrity.

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

---


# Supabase Deployment

Deploy database migrations safely with idempotent SQL and multi-tenant isolation.

## When to Use
- Creating new database migrations
- Deploying schema changes to production
- Troubleshooting migration issues
- Setting up new environments

## Quick Start
```bash
# 1. Create migration
npx supabase migration new your_change_description

# 2. Write idempotent SQL (see refs/migration-patterns.md)

# 3. Test locally
npx supabase db reset

# 4. Generate types
npx supabase gen types typescript --local > src/lib/database/types/database-generated.ts

# 5. Deploy to production
npx supabase db push
```

## Project Details
- **Project ID:** `yvnuayzslukamizrlhwb`
- **Region:** `ap-southeast-2` (Sydney)
- **Pooler (6543):** Serverless, API routes
- **Direct (5432):** Migrations, admin ops

## Pre-Deployment Checklist
- [ ] Migration is idempotent (IF NOT EXISTS, OR REPLACE)
- [ ] Foreign keys have CASCADE/RESTRICT
- [ ] RLS policies created
- [ ] Indexes added for performance
- [ ] Types generated and committed
- [ ] Tested locally with `db reset`
- [ ] Cultural review (if storyteller-facing)

## Critical Tables (Review Required)
- `elder_review_queue` - Elder approval workflow
- `cultural_protocols` - Community protocols
- `consent_change_log` - GDPR audit trail

## Reference Files
| Topic | File |
|-------|------|
| Migration patterns | `refs/migration-patterns.md` |
| Deployment workflow | `refs/workflow.md` |
| Troubleshooting | `refs/troubleshooting.md` |

## Related Skills
- `supabase-connection` - Database clients
- `supabase-sql-manager` - SQL operations
- `cultural-review` - Cultural safety check