Enforce safe Prisma/PostgreSQL migrations with Expand & Contract and CONCURRENTLY indexing.
npx skills add https://github.com/imehr/vet --skill database-guidelines
Please help me install this Agent Skill. Skill: database-guidelines Source: https://github.com/imehr/vet/tree/main/.claude/skills/database-guidelines Command: npx skills add https://github.com/imehr/vet --skill database-guidelines
This Skill provides guardrails and best practices for Database Reliability Engineering, focusing on data integrity, performance, and zero-downtime migrations, ensuring teams avoid common pitfalls.
To begin, instruct the AI to review the project’s Prisma/schema and apply safe migration and indexing recommendations across existing models and migrations.
High-intent search queries and answers about installing and using this skill.
To perform zero-downtime migrations in PostgreSQL using Prisma, apply the Expand & Contract pattern to safely evolve schemas without service interruptions. This approach ensures backward compatibility throughout the migration process.
To create indexes concurrently in PostgreSQL and avoid locking tables, use the CONCURRENTLY index creation pattern. The database guidelines skill provides procedural requirements for this operation to maintain database reliability and uptime.
The Expand & Contract pattern for database schema changes is a zero-downtime migration strategy that separates schema expansion from contraction. It enables safe data migrations and backfilling data while maintaining application stability.
Prevent N+1 queries and optimize indexing in a Prisma stack by applying database reliability engineering guidelines. These guardrails help optimize queries and indexing to improve overall database performance.
The best way to backfill data during a database migration is to follow audit-ready migration checklists and zero-downtime patterns. This ensures data integrity and performance optimization during schema changes.
Yes, operational playbooks for testing and rolling out PostgreSQL schema changes provide standard practices for backups and safe migrations. These playbooks ensure teams avoid common pitfalls during database reliability engineering.
KhaledaunDiagnose and resolve Prisma ORM schema, migration, and query issues.
jtucker9Generate ordered migration scripts and rollback plans from schema diffs.
shynlee04Generate secure, optimized SQL queries for PostgreSQL, MySQL, SQLite, Prisma, and Sequelize.
multiplex-aiPlan and execute reversible database migrations across PostgreSQL and MySQL.
