skills.rest
mcauduro0
mcauduro0COMMUNITY
Explore all skills by this author →
GitHub

alireza-database-designer

Analyze SQL DDL and JSON schemas to generate ERD diagrams and migration scripts.

1|Updated Feb 19, 2026
Search Tags:#database design#SQL#normalization#schema analysis#index optimization#migration generation
One-click install
npx skills add https://github.com/mcauduro0/Macro_Trading --skill alireza-database-designer
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: alireza-database-designer
Source: https://github.com/mcauduro0/Macro_Trading/tree/main/.claude/skills/alireza-database-designer
Command: npx skills add https://github.com/mcauduro0/Macro_Trading --skill alireza-database-designer

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill tackles the complexities of database design, offering tools to analyze schemas, optimize indexes, and generate safe migrations, ensuring robust and performant database systems.

Core Features & Use Cases

  • Schema Analysis: Detects normalization violations, data type antipatterns, and missing constraints.
  • Index Optimization: Recommends indexes to improve query performance and identifies redundant ones.
  • Migration Generation: Creates SQL scripts for schema changes, including zero-downtime strategies.
  • Use Case: A development team needs to refactor a legacy database schema. They can use this Skill to analyze the existing structure, identify areas for improvement (like missing indexes or normalization issues), and generate a safe, step-by-step migration plan to a new schema.

Quick Start

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

Frequently Asked Questions about alireza-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 violations and missing constraints?▼

To optimize database indexes, the tool analyzes your schema to identify redundant indexes and recommends new ones to improve query performance. It outputs a targeted index optimization report for your database structure.

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

To visualize database schemas, you provide a SQL schema file and the tool generates a Mermaid ERD diagram. This outputs a visual entity-relationship diagram representing your database structure for analysis.

Does database index optimization work with JSON schema inputs?▼

When refactoring a legacy database schema, the tool analyzes the existing structure to find missing indexes and normalization issues. It outputs a safe, step-by-step migration plan for transitioning to a new schema.

What is the best way to identify redundant indexes in a database schema?▼

Before schema analysis, provide SQL DDL or JSON schema files as input. This establishes the database structure baseline required to generate accurate analysis reports, ERD diagrams, and migration scripts.

Related Skills

Explore More Software Engineering Skills→
tapanshahtapanshah

Database Designer

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

Community
Advanced
williamzujkowskiwilliamzujkowski
6

Database Migration Script Generator

Generate database migration scripts for Liquibase, Flyway, or Alembic.

Community
Advanced
snoodleboot-iosnoodleboot-io
2

mermaid-erd-creation

Generate ERD blueprints from Mermaid syntax descriptions.

Official
Basic
amanhsnamanhsn

Database Designer - POWERFUL Tier Skill

Analyze SQL schemas for normalization, indexing, and constraint issues.

Community
Advanced