Summary
Handles the full database design workflow from requirements gathering to production-ready schemas. It generates proper SQL or NoSQL table definitions with primary keys, foreign keys, and indexes, plus ASCII ERD diagrams and up/down migration scripts. The output follows solid conventions like snake_case naming, appropriate data types, and 3NF normalization with denormalization notes where performance matters. It covers both relational patterns (PostgreSQL, MySQL) and document stores (MongoDB) with different strategies for each. The structured format with sections for relationships, indexes, and optimization notes makes it easy to review or hand off to a team. Solid for greenfield projects or when you need to formalize an ad hoc schema that grew organically.
Install to Claude Code
npx -y skills add onewave-ai/claude-skills --skill database-schema-designer --agent claude-codeInstalls into .claude/skills of the current project.
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →
Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →
Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →
On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →
Files
SKILL.mdView on GitHub
Database Schema Designer
Design optimized, scalable database schemas with proper relationships and indexes.
Contents
references/schema-templates.md— SQL/NoSQL schema templates, ASCII ERD, and migration script templates.references/output-format.md— labeled section structure for the final deliverable.references/best-practices.md— naming, data types, indexes, relationships, SQL/NoSQL design rules, and the output quality checklist.
Workflow
-
Gather requirements. Determine the database engine (PostgreSQL, MySQL, MongoDB, etc.), application domain, main entities, most common queries, expected data volume and growth, performance requirements, and any compliance constraints.
-
Design the schema. Apply the engine-appropriate rules in
references/best-practices.md(SQL Database Design or NoSQL Database Design). -
Generate the complete schema. Produce CREATE TABLE statements or collection documents using the templates in
references/schema-templates.md. -
Create the entity relationship diagram in text format following the ERD template in
references/schema-templates.md. -
Provide migration scripts with both up and down (rollback) paths, per the migration template in
references/schema-templates.md. -
Format the complete output using the labeled sections in
references/output-format.md. -
Verify the result against the output quality checklist in
references/best-practices.md.
Example Triggers
- "Design a database schema for an e-commerce platform"
- "Create SQL tables for a blog system"
- "Help me design a MongoDB schema for a social network"
- "Optimize this database schema for performance"
- "Generate migration scripts for my schema"
Generate production-ready, optimized database schemas that scale.
Featured
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →
