Design PostgreSQL, MySQL, and NoSQL schemas with indexes and migration plans.
npx skills add https://github.com/abnegate/claudes --skill database-design-abnegate
Please help me install this Agent Skill. Skill: database-design Source: https://github.com/abnegate/claudes/tree/main/skills/database-design Command: npx skills add https://github.com/abnegate/claudes --skill database-design-abnegate
It helps prevent slow queries, brittle schemas, and risky migrations by providing battle-tested patterns for PostgreSQL, MySQL, and NoSQL schema design and evolution.
Ask for a PostgreSQL schema and migration plan for a new feature by describing your tables, relationships, expected query patterns, and current production constraints.
High-intent search queries and answers about installing and using this skill.
To design a PostgreSQL schema for read-heavy workloads, apply normalization rules up to 3NF and perform deliberate denormalization. This ensures efficient, maintainable data models tailored to your specific access patterns.
The best way to run zero-downtime database migrations is using transactional templates, concurrent index creation, and batched backfills. This ensures safe schema changes without locking production tables.
Choose the right index types for query optimization by matching data access patterns to B-tree, composite, partial, GIN, or covering indexes. Validate selections by interpreting EXPLAIN ANALYZE signals to tune slow queries.
Yes, this database schema design approach works with NoSQL scenarios alongside PostgreSQL and MySQL. It provides battle-tested patterns to prevent brittle schemas and maintain reliable data models.
Your database migration likely locks tables because it lacks concurrent index creation and batched backfills. Implementing zero-downtime migration patterns with safe rollout steps prevents locking during schema changes.
sarimofficialDefine SQLModel schemas for Todo users and tasks with relationships and timestamps.
mindmorassApply expand-then-contract migration patterns to PostgreSQL databases with Alembic.
akaszubskiAutomate database schema design, migrations, and query-optimization planning for PostgreSQL and MySQL.
OneWave-AIDesign optimized SQL and NoSQL database schemas with ERDs and migration scripts.
