What it does

This skill transforms natural language requests into production-ready database architectures. It interprets high-level business requirements and automatically generates both the SQL DDL and comprehensive markdown documentation for your data layer.

Problem it solves

Designing a normalized database from scratch is time-consuming and prone to manual errors, such as missing indexes on foreign keys, inconsistent naming conventions, or improper data types for currency. This skill automates the drudgery of schema design while enforcing industry best practices from the start.

Supported Tools

• PostgreSQL: Default support with JSONB, BIGSERIAL, and automated updated_at triggers.
• MySQL: Optimized with UNSIGNED types and AUTO_INCREMENT syntax.
• SQLite: Lightweight syntax with CHECK constraints for enums.

Why use this skill

Unlike generic AI prompts, this skill applies strict 3rd Normal Form (3NF) logic, ensures every table includes audit timestamps and soft-delete support, and handles complex many-to-many junction tables automatically. It doesn't just give you code; it produces a professional SCHEMA.md directory of your entities and relationships for your team.