Enforce PostgreSQL and Prisma schema integrity with migration-first workflows and RLS policies.
npx skills add https://github.com/oakoss/agent-skills --skill db-enforcer
Please help me install this Agent Skill. Skill: db-enforcer Source: https://github.com/oakoss/agent-skills/tree/main/skills/db-enforcer Command: npx skills add https://github.com/oakoss/agent-skills --skill db-enforcer
This Skill ensures your PostgreSQL database schema and your TypeScript application code stay perfectly in sync, preventing data integrity issues and enabling robust, type-safe database operations.
Use the db-enforcer skill to generate a migration script for adding a new 'status' enum to the 'orders' table.
High-intent search queries and answers about installing and using this skill.
You can sync TypeScript types with PostgreSQL CHECK constraints using Prisma by enforcing type-to-database synchronization, automatically aligning your application types with database schema rules for type-safe SQL operations.
A migration-first workflow for PostgreSQL schema changes requires generating and validating migration scripts before altering the Prisma schema, preventing accidental data loss and ensuring safe database migrations.
You can implement Row-Level Security (RLS) policies in PostgreSQL with Prisma by applying zero-trust access controls directly at the database level, ensuring secure and granular data governance for user roles.
Yes, Prisma supports PostgreSQL UUIDv7 and virtual columns through generated SQL and mapping features, enabling robust type-safe SQL and advanced schema design for data integrity.
To generate a migration script for adding an enum to a PostgreSQL table, use a migration-first approach to create the schema change script, ensuring your Prisma mapping and database constraints remain aligned.
WesleySmitsAnalyze database schemas and generate improvement recommendations for Prisma, TypeORM, or Drizzle.
GDSDNApply Row Level Security policies to PostgreSQL tables and generate SQL migration files.
nathanielcrowell12-specImplement Supabase RLS policies, type-safe queries, and storage operations for PhotoVault.
4lermanGenerate SQL queries, introspect schemas, optimize performance, and create migration scripts.
