Overview
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.
How It Works
- Schema Definition: Claude analyzes the user's request to understand the application's data requirements.
- Normalization & Relationship Mapping: Claude applies normalization principles (1NF to BCNF) and defines relationships between entities (one-to-one, one-to-many, many-to-many).
- ERD Generation: Claude generates a Mermaid diagram representing the Entity-Relationship Diagram.
- SQL Generation: Claude creates SQL CREATE statements for the tables, columns, indexes, and constraints.
When to Use This Skill
This skill activates when you need to:
- Design a new database schema from scratch.
- Normalize an existing database schema.
- Generate an ERD diagram for a database.
- Create SQL CREATE statements for a database.
Examples
Example 1: Designing a Social Media Database
User request: "Design a database schema for a social media application with users, posts, and comments."
The skill will:
- Design tables for users, posts, and comments, including relevant attributes (e.g., user_id, username, post_id, content, timestamp).
- Define relationships between the tables (e.g., one user can have many posts, one post can have many comments).
- Generate an ERD diagram visualizing the relationships.
- Create SQL CREATE TABLE statements for the tables, including primary keys, foreign keys, and indexes.
Example 2: Normalizing an E-commerce Database
User request: "Normalize a database schema for an e-commerce application with customers, orders, and products."
The skill will:
- Analyze the existing schema for normalization violations.
- Decompose tables to eliminate redundancy and improve data integrity.
- Create new tables and relationships to achieve a normalized schema (e.g., separating product details into a separate table).
- Generate SQL CREATE TABLE statements for the new tables and ALTER TABLE statements to modify existing tables.
Best Practices
- Normalization: Always aim for at least 3NF to minimize data redundancy and improve data integrity. Consider BCNF for more complex scenarios.
- Indexing: Add indexes to frequently queried columns to improve query performance.
- Relationship Integrity: Use foreign keys to enforce referential integrity and prevent orphaned records.
Integration
This skill can be integrated with other Claude Code plugins, such as a SQL execution plugin, to automatically create the database schema in a database server. It can also work with a documentation plugin to generate documentation for the database schema.
1---2name: designing-database-schemas-33description: This skill enables Claude to design and visualize database schemas. It leverages normalization guidance (1NF through BCNF), relationship mapping, and ERD generation to create efficient and well-structured databases. Use this skill when the user requests to "design a database schema", "create a database model", "generate an ERD", "normalize a database", or needs help with "database design best practices". The skill is triggered by terms like "database schema", "ERD diagram", "database normalization", and "relational database design".4---5
6## Overview
7
8This 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.
9
10## How It Works
11
121. **Schema Definition**: Claude analyzes the user's request to understand the application's data requirements.
132. **Normalization & Relationship Mapping**: Claude applies normalization principles (1NF to BCNF) and defines relationships between entities (one-to-one, one-to-many, many-to-many).
143. **ERD Generation**: Claude generates a Mermaid diagram representing the Entity-Relationship Diagram.
154. **SQL Generation**: Claude creates SQL CREATE statements for the tables, columns, indexes, and constraints.
16
17## When to Use This Skill
18
19This skill activates when you need to:
20- Design a new database schema from scratch.
21- Normalize an existing database schema.
22- Generate an ERD diagram for a database.
23- Create SQL CREATE statements for a database.
24
25## Examples
26
27### Example 1: Designing a Social Media Database
28
29User request: "Design a database schema for a social media application with users, posts, and comments."
30
31The skill will:
321. Design tables for users, posts, and comments, including relevant attributes (e.g., user_id, username, post_id, content, timestamp).
332. Define relationships between the tables (e.g., one user can have many posts, one post can have many comments).
343. Generate an ERD diagram visualizing the relationships.
354. Create SQL CREATE TABLE statements for the tables, including primary keys, foreign keys, and indexes.
36
37### Example 2: Normalizing an E-commerce Database
38
39User request: "Normalize a database schema for an e-commerce application with customers, orders, and products."
40
41The skill will:
421. Analyze the existing schema for normalization violations.
432. Decompose tables to eliminate redundancy and improve data integrity.
443. Create new tables and relationships to achieve a normalized schema (e.g., separating product details into a separate table).
454. Generate SQL CREATE TABLE statements for the new tables and ALTER TABLE statements to modify existing tables.
46
47## Best Practices
48
49- **Normalization**: Always aim for at least 3NF to minimize data redundancy and improve data integrity. Consider BCNF for more complex scenarios.
50- **Indexing**: Add indexes to frequently queried columns to improve query performance.
51- **Relationship Integrity**: Use foreign keys to enforce referential integrity and prevent orphaned records.
52
53## Integration
54
55This skill can be integrated with other Claude Code plugins, such as a SQL execution plugin, to automatically create the database schema in a database server. It can also work with a documentation plugin to generate documentation for the database schema.
majiayu000