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.
npx skills add https://github.com/onewave-ai/claude-skills --skill database-schema-designer