skills.rest
Tonybleything76
Tonybleything76COMMUNITY
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/Tonybleything76/more-claude-skills --skill database-designer-tonybleything76
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
tapanshahtapanshah

Database Designer

Analyze SQL and NoSQL schemas, recommend indexes, and generate migration scripts.

Community
Advanced
jcodogjcodog

convex-migration-helper

Manage breaking schema changes and data backfills for Convex databases.

Community
Advanced
mohamedgshoaibmohamedgshoaib
5

supabase-performance-tuning

Diagnose and optimize PostgreSQL and Supabase query performance with pg_stat_statements.

Community
Advanced
luisgustavooliveiraluisgustavooliveira

reversa-data-master

Analyze DDL, migrations, and ORM models to generate ERDs and database documentation.

Community
Advanced