designing-database-schemas

What problem does it solve?

This skill assists in designing robust and normalized database schemas. It provides guidance on normalization principles, helps map relationships between entities, generates ERD diagrams for visualization, and ultimately produces SQL CREATE statements, saving design time and ensuring data integrity.

Core Features & Use Cases

• Normalization Guidance: Apply 1NF through BCNF principles for efficient schema design.
• ERD Generation: Visualize database relationships with Mermaid diagrams.
• SQL CREATE Statements: Automatically generate SQL for tables, columns, indexes, and constraints.
• Use Case: Design a new database schema for a social media application, including users, posts, and comments, complete with relationships and SQL creation scripts.

Quick Start

User request: "Design a database schema for a social media application with users, posts, and comments."

The skill will:

1. Design tables for users, posts, and comments, including relevant attributes (e.g., user_id, username, post_id, content, timestamp).
2. Define relationships between the tables (e.g., one user can have many posts, one post can have many comments).
3. Generate an ERD diagram visualizing the relationships.
4. Create SQL CREATE TABLE statements for the tables, including primary keys, foreign keys, and indexes.