Does this skill support different SQL dialects?

Yes, it generates standard SQL CREATE statements that can be easily adapted for major engines like PostgreSQL, MySQL, and SQLite.

Can it help improve an existing database?

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

How are the diagrams rendered?

The skill generates diagrams using Mermaid.js syntax, allowing for clear, text-based visual representation of entities and their relationships.

Does it handle complex relationships like many-to-many?

Yes, it identifies when bridge or join tables are required and automatically defines the necessary primary and foreign key constraints.

Database Schema Designer

Name: Database Schema Designer
Author: intent-solutions-io

byintent-solutions-io

データベース管理

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

概要

This skill empowers Claude to act as a professional database architect, transforming natural language requirements into robust, normalized database structures. It applies rigorous normalization principles from 1NF to BCNF, maps complex entity relationships, and provides visual clarity through Mermaid-based ERD diagrams. Whether you are building a new application from scratch or optimizing a legacy system, this skill ensures data integrity and performance by generating precise SQL CREATE statements and implementing indexing best practices.

主な機能

Automated database normalization from 1NF through BCNF
Schema refactoring to eliminate data redundancy and improve integrity
Visual ERD generation using Mermaid syntax for clear mapping
0 GitHub stars
Standardized SQL generation for tables, constraints, and indexes
Intelligent relationship mapping including many-to-many join tables

ユースケース

Architecting the data layer for a new complex web application
Generating technical documentation and visual diagrams for existing schemas
Normalizing legacy flat-file data into a relational structure

概要

主な機能

Automated database normalization from 1NF through BCNF
Schema refactoring to eliminate data redundancy and improve integrity
Visual ERD generation using Mermaid syntax for clear mapping
0 GitHub stars
Standardized SQL generation for tables, constraints, and indexes
Intelligent relationship mapping including many-to-many join tables

ユースケース

Architecting the data layer for a new complex web application
Generating technical documentation and visual diagrams for existing schemas
Normalizing legacy flat-file data into a relational structure