Does this skill generate SQL code?

Yes, it generates standard SQL CREATE statements, including primary keys, foreign keys, constraints, and indexes.

Can I visualize the database layout?

Yes, the skill automatically generates Mermaid.js code to create visual Entity-Relationship Diagrams (ERDs) for better project documentation.

What normalization levels are supported?

The skill provides guidance and implementation for normalization principles ranging from First Normal Form (1NF) through Boyce-Codd Normal Form (BCNF).

Can it help optimize existing databases?

Absolutely. It can analyze your current schema to identify normalization violations and suggest refactoring steps to improve data integrity.

Database Schema Designer

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

byintent-solutions-io

0•

Database Management

Designs, normalizes, and visualizes robust relational database schemas using industry best practices 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 streamlines the development lifecycle by translating natural language requirements into structured entity-relationship mappings and visual diagrams. Beyond architectural planning, the skill generates production-ready SQL CREATE statements, including primary/foreign keys and optimized indexes, ensuring your database is built for both data integrity and high performance from day one.

Key Features

01Entity relationship mapping (1:1, 1:N, N:M)

020 GitHub stars

03Automated database normalization from 1NF to BCNF

04Schema refactoring and redundancy analysis

05Visual ERD generation using Mermaid syntax

06Production-ready SQL DDL statement generation

Use Cases

01Generating visual documentation for existing database architectures

02Refactoring legacy flat-file data into a normalized relational structure

03Architecting a new application backend from natural language requirements

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add intent-solutions-io/plugins-nixtla database-schema-designer

For use in Claude.ai and ChatGPT

Download Skill