designing-database-schemas

Featured

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".

AI & Automation 2,926 stars 433 forks Updated yesterday MIT

Install

View on GitHub

Quality Score: 93/100

Stars 20%
100
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
100
Issue Health 10%
50
License 10%
100
Description 5%
100

Skill Content

## 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 1. **Schema Definition**: Claude analyzes the user's request to understand the application's data requirements. 2. **Normalization & Relationship Mapping**: Claude applies normalization principles (1NF to BCNF) and defines relationships between entities (one-to-one, one-to-many, many-to-many). 3. **ERD Generation**: Claude generates a Mermaid diagram representing the Entity-Relationship Diagram. 4. **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: 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 vi...

Details

Author
jeremylongshore
Repository
jeremylongshore/claude-code-plugins-plus-skills
Created
1 years ago
Last Updated
yesterday
Language
Python
License
MIT

Integrates with

Bundled in these plugins

Similar Skills

Semantically similar based on skill content — not just same category

AI & Automation Listed

database-schema-design

Design normalized database schemas with tables, relationships, indexes, and constraints for any application domain. Use when the user requests database schema design or provides relevant inputs for this workflow.

258 Updated 3 months ago
seb1n
AI & Automation Featured

modeling-nosql-data

This skill enables Claude to design NoSQL data models. It activates when the user requests assistance with NoSQL database design, including schema creation, data modeling for MongoDB or DynamoDB, or defining document structures. Use this skill when the user mentions "NoSQL data model", "design MongoDB schema", "create DynamoDB table", or similar phrases related to NoSQL database architecture. It assists in understanding NoSQL modeling principles like embedding vs. referencing, access pattern optimization, and sharding key selection.

2,926 Updated yesterday
jeremylongshore
Data & Documents Featured

generating-database-documentation

This skill enables Claude to automatically generate comprehensive documentation for existing database schemas using the database-documentation-gen plugin. It is triggered when the user requests database documentation, ERD diagrams, or a data dictionary. The plugin supports multiple database engines and generates documentation that includes ERD diagrams, table relationships, column descriptions, indexes, triggers, stored procedures, and interactive HTML documentation. Use this skill when you need to document existing database schemas for team onboarding, architectural reviews, or data governance purposes. The trigger terms include "database documentation", "ERD diagram", "data dictionary", and `/db-docs`.

2,926 Updated yesterday
jeremylongshore