alireza-database-designer
CommunityDesign, optimize, and migrate databases with expert precision.
Software Engineering#database design#SQL#normalization#schema analysis#index optimization#migration generation
Authormcauduro0
Version1.0.0
Installs0
System Documentation
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.
Dependency Matrix
Required Modules
None requiredComponents
scriptsreferencesassets
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: alireza-database-designer Download link: https://github.com/mcauduro0/Macro_Trading/archive/main.zip#alireza-database-designer Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.