skills.rest
Fantasia1999
Fantasia1999COMMUNITY
Explore all skills by this author →
WebsiteGitHub

database-designer

Analyzes SQL DDL schemas and generates zero-downtime migration scripts.

Updated Mar 12, 2026
Search Tags:#indexing#schema design#database#optimization#migration#sql
One-click install
npx skills add https://github.com/Fantasia1999/claude-skills-zh --skill database-designer-fantasia1999
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-designer
Source: https://github.com/Fantasia1999/claude-skills-zh/tree/main/translations/engineering/database-designer
Command: npx skills add https://github.com/Fantasia1999/claude-skills-zh --skill database-designer-fantasia1999

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, helping users create robust, high-performance, and maintainable database systems.

Core Features & Use Cases

  • Schema Analysis: Detects normalization issues, data type inefficiencies, and missing constraints.
  • Index Optimization: Identifies missing, redundant, or poorly designed indexes to improve query performance.
  • Migration Generation: Creates safe, zero-downtime migration scripts for schema evolution.
  • Use Case: A developer needs to refactor a legacy database schema to improve performance and scalability. This Skill can analyze the current schema, suggest optimal indexing strategies, and generate the SQL scripts for a zero-downtime migration.

Quick Start

Analyze the provided SQL DDL file 'schema.sql' and generate an 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 database schema for normalization issues and missing constraints?▼

Database schema analysis detects normalization issues, data type inefficiencies, and missing constraints. By providing a SQL DDL file or JSON schema definition, you receive expert-level recommendations to ensure your relational database architecture is robust and maintainable.

What is the best way to optimize SQL indexes for slow query performance?▼

SQL index optimization identifies missing, redundant, or poorly designed indexes to improve query performance. It analyzes query patterns against your schema to suggest optimal indexing strategies for performance tuning.

Can I generate zero-downtime database migration scripts from an existing schema?▼

You can generate safe, zero-downtime database migration scripts for schema evolution. The tool creates migration scripts that allow you to refactor legacy databases without interrupting service availability.

Does this database optimization tool support JSON schema definitions and SQL DDL inputs?▼

Yes, database optimization supports both SQL DDL and JSON schema definitions as input formats. This allows comprehensive database lifecycle management by analyzing structural definitions and query patterns for relational databases.

How do I generate an ERD diagram from a SQL DDL file?▼

To generate an ERD diagram from a SQL DDL file, you provide the schema file for analysis. The system processes the database schema definitions to produce an entity-relationship diagram visualizing the database structure.

Related Skills

Explore More Software Engineering Skills→
tapanshahtapanshah

Database Designer

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

Community
Advanced
xlelibertyxleliberty

database-designer

Analyze SQL schemas for normalization violations and generate index optimization reports.

Community
Advanced
johnlindquistjohnlindquist
24

db

Automate cross-database queries and schema management across SQLite, PostgreSQL, and MySQL.

Community
Intermediate
act70255act70255

database-design

Design database schemas and select object-relational mapping tools.

Community
Advanced