supabase-architect

Automate Supabase migrations, TypeScript type synchronization, and RLS auditing.

Updated Dec 23, 2025
One-click install
npx skills add https://github.com/sf-bcca/PromptArchitect-Studio --skill supabase-architect
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: supabase-architect
Source: https://github.com/sf-bcca/PromptArchitect-Studio/tree/main/.gemini/skills/supabase-architect
Command: npx skills add https://github.com/sf-bcca/PromptArchitect-Studio --skill supabase-architect

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

Automates Supabase migrations, type synchronization, and RLS auditing to streamline database lifecycles.

Core Features & Use Cases

  • Migration automation: Generates timestamped migrations and guides type syncing.
  • Type synchronization: Regenerates TypeScript definitions from the local Supabase instance.
  • Security auditing: Audits migrations to verify RLS policies and security best practices.
  • Use Case: Imagine you are updating a schema and need to ensure types stay in sync while validating RLS enforcement.

Quick Start

Run the Supabase architect scripts to create a migration, synchronize types, and audit the schema in your local project.

Frequently Asked Questions about supabase-architect

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate Supabase migrations and keep TypeScript types in sync?

Automating Supabase migrations generates timestamped migration files and regenerates TypeScript definitions directly from your local instance to keep types synchronized during schema updates.

How do I audit Row Level Security policies in Supabase?

Auditing Row Level Security in Supabase involves scanning migrations to verify that RLS policies are enforced and align with security best practices across local and remote environments.

What's the best way to create deterministic Supabase schema migrations?

Creating deterministic Supabase migrations requires generating timestamped files for every schema change to ensure consistent ordering and reproducible database lifecycles across environments.

Can I validate Supabase RLS enforcement when updating a database schema?

Validating Supabase RLS enforcement during schema updates is possible by running an audit script that checks your migrations for security policy compliance and best practices.

Does Supabase type synchronization work with a local database instance?

Supabase type synchronization works by regenerating TypeScript definitions from your local Supabase instance, ensuring your codebase accurately reflects local schema changes.

Why should I audit migrations for Supabase RLS compliance?

Auditing migrations for Supabase RLS compliance prevents security vulnerabilities by verifying that Row Level Security policies are actively enforced whenever new tables or schema updates are introduced.