db-schema
Turn plain English app descriptions into fully normalized SQL schemas and entity relationship documentation.
skill install https://www.promptspace.in/skills/db-schemaWhat 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.
Use cases
- Generate 3NF normalized SQL schemas from high-level app ideas
- Create detailed SCHEMA.md manuals documenting all entity relationships
- Automate the creation of junction tables for many-to-many relationships
- Standardize audit fields like soft-deletes and timestamps across all tables
- Implement database-specific best practices for Postgres, MySQL, or SQLite
Example
Prompt
Sample output preview is available after purchase.