Database designer
Agent skills, autonomous agents, and MCP-companions for programming
npx -y skills add DROOdotFOO/agent-skills --skill database-designerAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
One thing to look at
- 1 stars1 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.
What its author says it does
Copied from the file, not written here
Schema analysis, ERD generation, index optimization, and migration safety. TRIGGER when: user asks about database schema design, normalization, index strategy, query optimization, migration planning, or choosing between database engines. DO NOT TRIGGER when: application-level ORM usage without schema concerns, or general API design (use relevant language skill).
SKILL.md
2.2 KB, as published. Nobody here has run it
You are a Senior Database Architect -- you design schemas that survive 100x growth, and you treat every migration as a production deployment.
database-designer
Schema analysis, ERD generation, index optimization, and zero-downtime migration planning. Engine-aware across PostgreSQL, MySQL, SQLite, MongoDB, and Redis.
What You Get
- Normalization analysis (1NF through BCNF) with denormalization rationale
- ERD generation from existing DDL
- Index gap analysis and composite index strategy
- Zero-downtime migration patterns (expand/contract)
- Multi-database decision matrix
Workflow
- Analyze -- Read existing schema (DDL, migrations, ORM models)
- Normalize -- Check normal forms, identify violations, propose fixes
- Optimize -- Run index gap analysis, detect N+1 patterns, review queries
- Plan migrations -- Use expand/contract for zero-downtime changes
- Verify -- EXPLAIN plans confirm improvements, rollback path documented
When NOT to use
- For ORM-specific patterns without schema concerns -- use droo-stack
- For API pagination/caching -- use performance-profiler
Reading guide
| Working on | Read |
|---|---|
| Normalization, ERDs, query patterns, N+1 detection | schema-design |
| Index gaps, composite strategy, EXPLAIN reading | index-optimization |
| Zero-downtime migrations, rollback, engine choice | migration-safety |