new-migration

To generate Drizzle ORM schema and SQL migrations with Row Level Security, use this Skill to create TypeScript schema tables, output associated migration scripts, and automatically configure RLS policies via pgPolicy for organization or user-scoped access control.

Adding organization-scoped RLS policies to a new Postgres table involves defining the schema and applying pgPolicy configurations. This Skill automates that process by generating the Drizzle schema and attaching the necessary Row Level Security rules based on your specified table scope.

Yes, you can create custom fields like text and integer when generating a new database schema. This Skill supports specifying custom field types and names during schema generation, producing TypeScript files that accurately define your Drizzle ORM table structure.

This migration generator supports global tables in addition to user-scoped and organization-scoped tables. It automatically adjusts the Row Level Security configuration, applying pgPolicy only where necessary, ensuring global tables remain accessible without restrictive tenant-level policies.

When the TUI blocks during schema generation, you can use the manual fallback to handle migration journal updates. This Skill detects TUI blocking conditions and provides a manual pathway to ensure your Drizzle migration journal remains accurately synchronized.

You need separate SQL migration files when adding a new feature table to track database schema changes incrementally. This Skill generates these distinct migration scripts alongside your Drizzle schema, ensuring your Postgres database structure remains version-controlled and reproducible.