Design database schemas and migration plans for PostgreSQL, MySQL, and NoSQL systems.
npx skills add https://github.com/ricable/mcai --skill database-design-ricable
Please help me install this Agent Skill. Skill: database-design Source: https://github.com/ricable/mcai/tree/main/.agents/skills/database-design Command: npx skills add https://github.com/ricable/mcai --skill database-design-ricable
This Skill helps you design reliable databases, avoid schema mistakes, and improve query performance without sacrificing data integrity.
Ask for a production-ready database schema, migration plan, and indexing strategy for your application.
High-intent search queries and answers about installing and using this skill.
Schema design for PostgreSQL involves modeling normalized or denormalized tables, planning effective indexes, and defining constraints to maintain data integrity. Analyzing query execution plans further reduces slow scans and ensures production reliability.
Zero-downtime database migrations require creating safe migration paths, backfills, and constraint changes without disrupting production traffic. This process enforces transactional safety and integrity controls throughout the schema transition.
Query optimization for slow SQL scans works by analyzing query execution plans and planning effective indexes to reduce full table scans. This ensures performance tuning improves retrieval speed without sacrificing data integrity.
Yes, this approach supports both relational databases like PostgreSQL and MySQL, as well as NoSQL systems. It handles document-oriented workflows, applying normalization or denormalization strategies appropriate to each data model.
Denormalization in database schema design is needed when query performance requires reducing complex joins, often for read-heavy workloads. It involves intentionally modeling tables to combine data, balancing redundancy against improved query execution speed.
DauQuangThanhDesign relational and NoSQL database schemas from business requirements.
icartshAnalyze EXPLAIN plans and implement indexing strategies to optimize SQL queries.
akaszubskiAutomate database schema design, migrations, and query-optimization planning for PostgreSQL and MySQL.
0xBigBossEnforce Atlas best practices for declarative and versioned database migrations.
