Does this skill support NoSQL databases?

While primarily focused on relational schemas and SQL normalization, it can provide structural advice and entity mapping for document-based systems.

Which SQL dialects are supported?

The skill generates standard SQL CREATE statements compatible with most major relational databases including PostgreSQL, MySQL, and SQLite.

Does it handle database indexing?

Yes, the skill identifies frequently queried columns and recommends indexing strategies to ensure optimal query performance.

Can it help improve an existing database?

Yes, it can analyze your current schema to identify normalization violations and suggest refactoring steps to improve data integrity.

What diagram formats does it produce?

It generates Entity-Relationship Diagrams (ERDs) using Mermaid.js syntax, which is natively supported by many IDEs and documentation platforms.

Database Schema Designer

Name: Database Schema Designer
Author: jeremylongshore

byjeremylongshore

•

884

Database Management

Designs, normalizes, and visualizes relational database schemas with automated ERD and SQL generation.

About

The Database Schema Designer skill empowers Claude to architect robust, efficient, and highly structured databases. By applying industry-standard normalization principles from 1NF to BCNF, it helps developers map complex entity relationships and eliminate data redundancy. Whether you are starting a new project or optimizing an existing legacy system, this skill automates the creation of Mermaid ERD diagrams and production-ready SQL CREATE statements to streamline your backend development workflow.

Key Features

Normalization guidance from 1NF through BCNF
Automated Mermaid ERD diagram generation
Production-ready SQL CREATE statement generation
Complex relationship mapping (1:1, 1:N, N:M)
Performance optimization via indexing recommendations
884 GitHub stars

Use Cases

Architecting a new application backend from scratch
Refactoring and normalizing legacy database tables to reduce redundancy
Visualizing complex data structures for documentation and team reviews

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