database-schema-designer
database schema designer
What it does
- Entities (users, products, orders)
- Key relationships (users have orders, orders have items)
- Scale hints (high-traffic, millions of records)
- Database preference (SQL/NoSQL) - defaults to SQL if not specified
- [ ] Every table has a primary key
- [ ] All relationships have foreign key constraints
- [ ] ON DELETE strategy defined for each FK
Requirements & configuration
- | I need a database | "I need a database for tracking orders" |
- | OLTP | Online Transaction Processing - write-heavy, needs normalization |
- BAD: country depends on postalcode
- | Always reversible | Need to rollback |
Configuration: MATCHWHERE
Derived from the skill's own SKILL.md documentation · extracted 2026-07-23
database-schema-designer FAQ
What does the database-schema-designer skill do?
Design robust, scalable database schemas for SQL and NoSQL databases. Provides normalization guidelines, indexing strategies, migration patterns, constraint design, and performance optimization. Ensures data integrity, query performance, and maintainable data models. Entities (users, products, orders) Key relationships (users have orders, orders have items)
What does database-schema-designer require?
| I need a database | "I need a database for tracking orders" | | OLTP | Online Transaction Processing - write-heavy, needs normalization | BAD: country depends on postalcode | Always reversible | Need to rollback | Configuration keys: MATCH, WHERE.
How do I install database-schema-designer?
Run: npx -y skills add https://github.com/softaworks/agent-toolkit --skill database-schema-designer --agent claude-code — the source lives at github.com/softaworks/agent-toolkit.
Maintain database-schema-designer?
Let people know it's listed here — add the badge (live metrics, light/dark aware) or a plain link to your README or docs.
[database-schema-designer on getagentictools](https://getagentictools.com/skills/softaworks-agent-toolkit-database-schema-designer?ref=badge) npx agentictools info skills/softaworks-agent-toolkit-database-schema-designer The second line is the CLI lookup for this page — handy in READMEs and docs.
