Does it provide guidance on indexing?

Yes, the skill suggests appropriate indexes for frequently queried columns to improve database performance as part of the design process.

Does this skill support different SQL dialects?

Yes, Claude can generate SQL compatible with PostgreSQL, MySQL, SQLite, and other major relational databases based on your specific project requirements.

How does it handle many-to-many relationships?

The skill automatically identifies many-to-many relationships and designs the necessary junction tables, foreign keys, and constraints to maintain referential integrity.

Can it help improve an existing database schema?

Absolutely. You can provide an existing schema, and the skill will analyze it for normalization violations and suggest structural improvements.

What visualization format does it use for diagrams?

It generates diagrams using Mermaid.js syntax, which can be easily rendered as visual Entity-Relationship Diagrams in most Markdown viewers and documentation tools.

Database Schema Designer

Name: Database Schema Designer
Author: jeremylongshore

byjeremylongshore

•

883

데이터베이스 관리

Designs, visualizes, and normalizes robust database schemas while generating SQL and Mermaid ERD diagrams.

소개

The Database Schema Designer skill empowers Claude to architect efficient data models by applying rigorous normalization principles from 1NF to BCNF. It bridges the gap between conceptual requirements and technical implementation by mapping complex entity relationships, visualizing them through Mermaid ERD diagrams, and automatically generating production-ready SQL CREATE statements. This tool is essential for developers looking to ensure data integrity, minimize redundancy, and document their database architecture directly within their coding workflow.

주요 기능

883 GitHub stars
Complex relationship mapping (1:1, 1:N, N:M)
Indexing and performance optimization recommendations
Mermaid-based ERD (Entity-Relationship Diagram) generation
Production-ready SQL DDL generation for tables and constraints
Automated data normalization from 1NF through BCNF

사용 사례

Generating visual documentation for existing data structures
Refactoring and normalizing a legacy database to eliminate redundancy
Architecting a new database schema for a greenfield application

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills database-schema-designer

For use in Claude.ai and ChatGPT

Download Skill

GitHub

소개