Supabase operational knowledge for migrations, RLS optimization, MCP tool benchmarks, and ADR-003 compliance. Use when validating database migrations, optimizing Row-Level Security policies, checking MCP tool performance, or ensuring Supabase operational standards. Triggers on: migration validation, RLS patterns, Supabase benchmarks, ADR-003, database state tracking, schema governance.
SUPABASE_MASTERY::[MIGRATION_VALIDATION+RLS_OPTIMIZATION+MCP_BENCHMARKS+ADR_003_COMPLIANCE]→PRODUCTION_OPERATIONAL_EXCELLENCE
MIGRATION_VALIDATION::migration-protocols.md::[ 7_step_workflow, backwards_compatible_schema_changes, multi_app_deployment_safety, CI_gated_deployment[preferred_over_direct_MCP] ]
RLS_OPTIMIZATION::rls-optimization.md::[ proven_patterns→<50ms_query_performance, InitPlan_optimization, policy_consolidation ]
MCP_BENCHMARKS::mcp-benchmarks.md::[ performance_characteristics, best_practices, production_measurements ]
ADR_003_COMPLIANCE::adr-003-compliance.md::[ backwards_compatible_migration_governance, verification_checklist ]
STATE_TRACKING::state-tracking.md::[ local_remote_sync_validation, database_state_awareness_procedures ]
MIGRATION_OPERATIONS::[ before_applying_migrations→validation_checklist, after_schema_changes→compliance_verification, debugging_migration_divergence, CI_deployment_flow→PR_with_deploy_migrations_label ]
RLS_DESIGN::[ optimizing_slow_queries_with_RLS, designing_new_security_policies, benchmarking_RLS_performance_impact ]
DATABASE_OPERATIONS::[ selecting_appropriate_MCP_tools, validating_current_database_state, checking_security_performance_advisors ]
COMPLIANCE::[ verifying_ADR_003_backwards_compatibility, multi_app_testing_requirements, emergency_rollback_procedures ]
ALLOWED_TOOLS::[ Read::"Access local migration files and documentation", mcp__supabase__list_tables::"Inspect current schema structure", mcp__supabase__list_extensions::"Verify installed extensions", mcp__supabase__list_migrations::"Compare local/remote migration state", mcp__supabase__get_advisors::"Check security/performance compliance" ]
SECURITY_JUSTIFICATION::"Skills guide operations but don't mutate state. Write operations (apply_migration, execute_sql) remain with authorized agents."
CONSULTED_BY::[ supabase-expert[domain_authority_with_BLOCKING], implementation-lead[migration_execution], technical-architect[schema_design] ]
PROVIDES::[ migration_validation_checklists, RLS_optimization_patterns, MCP_tool_selection_guidance, compliance_verification_procedures, CI_deployment_guidance[gated_auto_deploy] ]
PREFERRED_FLOW::[ 1::create_PR_with_migrations, 2::add_deploy_migrations_label, 3::CI_validates_locally, 4::merge_triggers_production_deploy, 5::audit_log_entry_created ]
DIRECT_MCP_APPLICATION::[ STATUS::fallback_only, WHEN::CI_unavailable_OR_emergency, REQUIREMENT::always_create_local_file_first, WARNING::bypasses_CI_validation ]
CI_REFERENCE::[ WORKFLOW::".github/workflows/ci.yml (deploy-migrations job)", SECRET::"SUPABASE_ACCESS_TOKEN required", LABEL::"deploy-migrations", DR_PLAYBOOK::".coord/docs/001-OPS-DISASTER-RECOVERY-PLAYBOOK.md" ]