Database Designer

Analyze SQL DDL and JSON schemas for normalization and constraints.

Updated Mar 4, 2026

Search Tags:#schema design #database #normalization #performance tuning #sql migration #index optimization

Ready to run

npx skills add https://github.com/Tonybleything76/more-claude-skills --skill database-designer-tonybleything76

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: Database Designer
Source: https://github.com/Tonybleything76/more-claude-skills/tree/main/engineering/database-designer
Command: npx skills add https://github.com/Tonybleything76/more-claude-skills --skill database-designer-tonybleything76

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill addresses the complexities of database design, optimization, and migration, providing tools and principles to create robust, performant, and maintainable database schemas.

Core Features & Use Cases

Schema Analysis: Identifies normalization violations, data type issues, and missing constraints.
Index Optimization: Recommends optimal indexes based on query patterns and detects redundancy.
Migration Generation: Creates safe SQL migration scripts, including zero-downtime strategies.
Use Case: A development team needs to refactor a legacy database schema. This Skill can analyze the current schema, identify normalization issues, suggest improvements, and generate the SQL to safely migrate to a new, optimized schema.

Quick Start

Analyze the provided SQL DDL file 'schema.sql' and generate a Mermaid ERD diagram.

Frequently Asked Questions about Database Designer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I check my SQL schema for normalization violations and missing constraints?▼

To check SQL schema for normalization violations, analyze the DDL to identify data type issues, missing constraints, and naming convention enforcement, ensuring a robust and maintainable database structure.

What is the best way to generate safe SQL migration scripts for a database schema refactor?▼

The best way to generate safe SQL migration scripts is to compare schema versions and produce zero-downtime migration strategies, ensuring safe transitions between optimized database structures.

How do I optimize database indexes based on specific query patterns?▼

To optimize database indexes, analyze query patterns to recommend optimal indexes and detect redundancy, improving overall performance tuning without unnecessary overhead.

Can I analyze database schemas using JSON format instead of SQL DDL?▼

Yes, you can analyze database schemas using JSON format. The system supports both SQL DDL and JSON schema inputs for comprehensive analysis, comparison, and data type validation.

How do I generate a Mermaid ERD diagram from an existing database schema?▼

To generate a Mermaid ERD diagram, provide the SQL DDL file for schema analysis. The system processes the structural definitions to output a visual entity-relationship diagram.