Plan and execute database migrations with rollback and backfill strategies.
npx skills add https://github.com/PAISHU-AI/PAI-zong-NB --skill database-paishu-ai
Please help me install this Agent Skill. Skill: database Source: https://github.com/PAISHU-AI/PAI-zong-NB/tree/main/skills/07-database Command: npx skills add https://github.com/PAISHU-AI/PAI-zong-NB --skill database-paishu-ai
This Skill streamlines the process of designing, modifying, and querying database schemas, migrations, and SQL queries, ensuring efficient database management and data consistency.
Use the database skill to optimize the performance of your PostgreSQL database by adding an index to the 'users' table for the 'email' column.
High-intent search queries and answers about installing and using this skill.
Database migration planning involves designing step-by-step schema changes, executing backfill processes for existing records, and preparing rollback scripts to ensure data consistency and minimize lock risks during deployment.
SQL query performance optimization requires adding targeted indexes to high-frequency lookup columns and wrapping complex read or write operations in transactions to ensure data consistency and reduce execution latency.
Yes, database schema design and migration management supports PostgreSQL, MySQL, SQLite, SQL Server, Prisma, and ORM changes, allowing you to handle schema modifications and query optimization across multiple database environments.
Database schema design for data consistency involves structuring tables with appropriate constraints, defining relationships between entities, and using transactions to maintain integrity during concurrent read and write operations.
Handling lock risks during schema modifications requires careful migration planning, breaking changes into smaller batches, and using strategies like backfill and rollback to minimize table locks and maintain application availability.
Rollback strategies for database migrations are needed to revert schema changes safely if deployment fails, ensuring data consistency and allowing quick recovery without losing existing records or breaking application queries.
qauth-labsDefine PostgreSQL schema rules for QAuth user and credential models.
arrowInkneeeeeGenerate SQL migration scripts for schema changes across multiple databases.
tranhieuttDiagnose Prisma schema, migration, and query performance issues in Node.js projects.
AreteDriverDesign relational database schemas and generate migration scripts for PostgreSQL, MySQL, and SQLite.
