Database Designer - POWERFUL Tier Skill — Data

A comprehensive database design skill that provides expert-level analysis, optimization, and migration capabilities for modern database systems. It combines theoretical principles with practical tools to help architects and developers create scalable, performant, and maintainable database schemas.

engineering claude-code

📂 View skill on GitHub ↗ 🚀 How to use

✨ What it does

Automated normalization analysis (1NF through BCNF) and denormalization recommendations.
Index gap analysis, composite index strategy, and redundancy detection.
Zero-downtime migration planning with expand-contract patterns and rollback strategies.
ERD generation in Mermaid format from DDL.
Multi-database decision matrix and NoSQL considerations.
Query generation patterns for joins, CTEs, window functions, and aggregations.

🎯 When to use it

When designing a new database schema from scratch or refactoring an existing one.
When planning data migrations, especially zero-downtime migrations.
When optimizing query performance through index analysis and query pattern review.
When deciding between SQL and NoSQL databases for a specific use case.

🚀 How to use

Trigger by asking to design a database schema, plan a migration, or optimize queries. Provide your schema (SQL DDL or JSON) and optionally your hot query patterns. The skill runs three Python tools: schema_analyzer.py, index_optimizer.py, and migration_generator.py. Example prompts:

Analyze my schema.sql and generate an ERD.
Optimize indexes for my query patterns.
Generate a zero-downtime migration from current_schema.json to target_schema.json.

📄 Output: Produces analysis reports, index recommendations, migration SQL scripts, and Mermaid ERD diagrams.

📦 Add this skill to Claude Code

# 1. Get the skills repo
git clone --depth 1 https://github.com/alirezarezvani/claude-skills /tmp/claude-skills

# 2. Copy this skill into your project (or ~/.claude/skills for all projects)
mkdir -p .claude/skills
cp -r /tmp/claude-skills/engineering/skills/database-designer .claude/skills/database-designer

Skill source: engineering/skills/database-designer/SKILL.md

⚠️ Good to know

Requires Python 3 and the provided scripts; assumes input schemas are in SQL DDL or JSON format.

❓ FAQ

What tools does the skill use?

It uses three Python scripts: schema_analyzer.py, index_optimizer.py, and migration_generator.py.

Can it generate a zero-downtime migration?

Yes, the migration_generator.py supports a --zero-downtime flag that emits an expand-contract plan.

Does it support NoSQL databases?

It provides a decision matrix and considerations for NoSQL, but the tools focus on SQL schemas.

🤖 Overview, features, install steps and FAQ were generated from the project's SKILL.md on Sep 4, 2026. Always check the original source before running commands.