skills.rest
zhangzhang-111-i
zhangzhang-111-iCOMMUNITY
Explore all skills by this author →
GitHub

database-designer

Analyzes SQL/JSON schemas and generates optimized migration scripts.

2|Updated Mar 13, 2026
Search Tags:#indexing#database#optimization#schema#migration#normalization
One-click install
npx skills add https://github.com/zhangzhang-111-i/claude-skills111 --skill database-designer-zhangzhang-111-i
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-designer
Source: https://github.com/zhangzhang-111-i/claude-skills111/tree/main/engineering/database-designer
Command: npx skills add https://github.com/zhangzhang-111-i/claude-skills111 --skill database-designer-zhangzhang-111-i

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines complex database design, optimization, and migration tasks, ensuring robust, performant, and maintainable database solutions.

Core Features & Use Cases

  • Schema Analysis: Detects normalization violations, data type issues, and missing constraints.
  • Index Optimization: Recommends optimal indexes for query performance and identifies redundancies.
  • Migration Generation: Creates safe SQL migration scripts, including zero-downtime strategies.
  • Use Case: Refactor a legacy database schema by analyzing its current state, identifying performance bottlenecks, and generating safe, incremental migration scripts for a modern, optimized structure.

Quick Start

Analyze the provided SQL schema 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 analyze a SQL schema for normalization and data type antipatterns?▼

Schema analysis detects normalization violations, data type issues, and missing constraints by examining your SQL DDL or JSON definitions. This process identifies structural flaws and naming convention violations to ensure a robust, maintainable database design.

What is the best way to generate zero-downtime database migration scripts?▼

Generating zero-downtime database migration scripts involves creating safe, incremental SQL commands based on schema analysis. This approach refactors legacy structures by identifying performance bottlenecks and applying safe migration strategies without service interruption.

How do I optimize database indexes and identify redundant indexes?▼

Index optimization recommends optimal indexes for query performance by analyzing your schema. It identifies existing redundancies and generates tailored recommendations to eliminate bottlenecks, ensuring efficient data retrieval and overall database performance.

Can I use a JSON schema definition to generate a Mermaid ERD diagram?▼

Yes, you can use a JSON schema definition to generate a Mermaid ERD diagram. The tool analyzes your provided schema file and outputs a visual entity-relationship diagram to help map and communicate the database structure.

When do I need database schema migration for legacy systems?▼

You need database schema migration for legacy systems when performance bottlenecks or structural deficiencies hinder maintainability. Analyzing the current state allows you to generate safe, incremental migration scripts for a modern, optimized database architecture.

Related Skills

Explore More Software Engineering Skills→
Tonybleything76Tonybleything76

Database Designer

Analyze SQL DDL and JSON schemas for normalization and constraints.

Community
Advanced
OneWave-AIOneWave-AI
245

database-schema-designer

Design optimized SQL and NoSQL database schemas with ERDs and migration scripts.

Official
Basic
4lerman4lerman

performance-profiler

Profile Node.js, Python, and Go applications for CPU, memory, and I/O bottlenecks.

Community
Advanced
AnasAhmed001AnasAhmed001
1

database-specialist

Design scalable SQL and NoSQL database schemas with migrations and indexing.

Community
Advanced