supabase-db-architect

What problem does it solve?

This Skill makes it easy to design, validate, and defend production-grade Supabase schemas for multi-tenant real estate and fintech workloads without sacrificing RLS safeguards, audit trails, or migration safety.

Core Features & Use Cases

• Architectural Playbook: Guidance on choosing between Edge Functions, database functions, and PostgREST, selecting shared-schema vs schema-per-tenant, designing tenant_id-enriched tables, and configuring connection pooling strategies.
• Compliance & Fintech Patterns: Enforces NUMERIC currency columns, audit trail shadow tables, idempotent payments, temporal tables, double-entry accounting, and retention guardrails that every finance-heavy workflow demands.
• Production QA Signoff: Bundled db-qa-gate script plus reference docs to verify RLS coverage, tenant_id columns, indexes, migration naming, and function security before rolling out changes.
• Use Case: Onboard a new tenant-focused leasing or payment product by having the architect evaluate schema design, migrations, RLS policies, and QA gate findings to avoid data leaks and performance regressions.

Quick Start

Ask it to review your Supabase schema, RLS policies, migrations, and QA gate findings for tenant isolation and fintech readiness.