What SQL dialects does it support?

It generates standard SQL CREATE statements compatible with most major relational databases like PostgreSQL, MySQL, and SQLite.

Does it support visual diagrams?

Absolutely. The skill generates Mermaid syntax to create Entity-Relationship Diagrams (ERDs) that can be rendered directly in many Markdown viewers.

Can this skill normalize existing databases?

Yes, it can analyze existing schemas for redundancy and normalization violations, then provide a strategy to decompose them into 3NF or BCNF.

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

Yes, it automatically identifies the need for junction tables and defines the necessary foreign key constraints to maintain referential integrity.

Database Schema Designer

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

byintent-solutions-io

0•

Database Management

Designs and visualizes normalized database schemas while generating production-ready SQL scripts.

The Database Schema Designer skill empowers Claude to architect robust, high-performance database structures by applying formal normalization principles from 1NF to BCNF. It streamlines the development lifecycle by translating natural language requirements into complex entity-relationship mappings, generating Mermaid-based ERD diagrams for visual documentation, and producing optimized SQL CREATE statements with proper indexes and referential integrity constraints.

Key Features

01Complex relationship mapping including many-to-many join tables

02Performance optimization through strategic indexing and constraint definition

030 GitHub stars

04Production-ready SQL CREATE and ALTER script generation

05Automated normalization guidance from 1NF through BCNF

06Visual ERD generation using Mermaid diagram syntax

Use Cases

01Generating visual documentation and ERDs for existing database projects

02Architecting a new relational database from scratch based on application requirements

03Refactoring legacy flat-data structures into normalized relational schemas

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