memstack-development-database-architect

Design Supabase/Postgres schemas with tables, relationships, RLS policies, and migration SQL.

412|45|Updated Feb 19, 2026

Search Tags:#schema design #database #rls #migration #supabase #sql #postgres

Ready to run

npx skills add https://github.com/cwinvestments/memstack --skill memstack-development-database-architect

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: memstack-development-database-architect
Source: https://github.com/cwinvestments/memstack/tree/main/skills/development/database-architect
Command: npx skills add https://github.com/cwinvestments/memstack --skill memstack-development-database-architect

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill addresses the complexity of designing robust and scalable database schemas for Supabase/Postgres, ensuring proper structure, relationships, and security policies are in place from the outset.

Core Features & Use Cases

Schema Generation: Creates production-ready SQL for table definitions, relationships, and indexes.
RLS Policy Creation: Designs Row Level Security policies to enforce data access control.
Migration SQL: Generates SQL scripts for database migrations.
Use Case: When starting a new project, use this skill to define the core data model for users, posts, and comments, including foreign key constraints and appropriate RLS policies.

Quick Start

Use the database architect skill to design tables for a blog with posts and comments, including RLS policies.

Frequently Asked Questions about memstack-development-database-architect

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

FAQPage Schema

How do I design a Supabase schema with row level security policies?▼

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.

What is the best way to generate Postgres migration SQL for a new application data model?▼

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.

Can I use this to create a data model for users, posts, and comments with foreign key constraints?▼

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.

Does this skill handle naming conventions and indexing best practices for Postgres?▼

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.

When do I need to implement RLS policies in my database schema?▼

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.