memstack-development-database-architect

To design a Supabase schema with RLS, define table structures and relationships, then generate SQL policies enforcing granular data access controls. This skill outputs production-ready migration SQL including foreign key constraints, indexes, and RLS policies.

The best way to generate Postgres migration SQL is to define table structures, foreign key constraints, and indexes upfront. This skill creates production-ready migration scripts following best practices for naming conventions and database schema design.

Yes, you can create a data model for users, posts, and comments with foreign key constraints. This skill designs application data models including table relationships, indexes, and appropriate RLS policies to ensure secure data access from the outset.

Yes, this skill enforces naming conventions and indexing best practices for Postgres. It ensures proper schema structure, relationships, and security policies are established from the outset, adhering to production-ready database design standards.

You need to implement RLS policies when your database schema requires granular data access controls. This skill designs Row Level Security policies alongside table definitions to enforce secure data access from the beginning of database development.