Agent skill · data analytics · alirezarezvani
database-designer
Design a database schema: tables, relationships, indexes, normalization, SQL vs NoSQL, migration plans. Use whenever the user asks how to structure their data, which database to pick, or before writing DDL.
Why this skill is useful
Adds 4 executable scripts for schema analysis, index optimization, migration generation, and verification that automate complex database design tasks.
What it needs
Requires python3 installed locally. About 7k tokens when loaded. Last updated 2026-08-05. 23,939 stars on the source repository.
What this skill does
Database Designer - POWERFUL Tier Skill Overview A comprehensive database design skill that provides expert-level analysis, optimization, and migration capabilities for modern database systems. This skill combines theoretical principles with practical tools to help architects and developers create scalable, performant, and maintainable database schemas. Core Competencies Schema Design & Analysis Normalization Analysis: Automated detection of normalization levels (1NF through BCNF) Denormalization Strategy: Smart recommendations for performance optimization Data Type Optimization: Identification of inappropriate types and size issues Constraint Analysis: Missing foreign keys, unique constraints, and null checks Naming Convention Validation: Consistent table and column naming patterns ERD Generation: Automatic Mermaid diagram creation from DDL Index Optimization Index Gap Analysis: Identification of missing indexes on foreign keys and query patterns Composite Index Strategy: Optimal column ordering for multi-column indexes Index Redundancy Detection: Elimination of overlapping and unused indexes Performance Impact Modeling: Selectivity estimation and query cost analysis Index Type Selection: B-tree, hash, partial, covering, and specialized indexes Migration Management Zero-Downtime Migrations: Expand-contract pattern implementation Schema Evolution: Safe column additions, deletions, and type changes Data Migration Scripts: Automated data transformation and validation Rollback Strategy: Complete reversal capabilities with validation Execution Planning: Ordered migration steps with dependency resolution Tool Workflow (run these — do not analyze schemas by hand) All paths relative to this skill folder; sample inputs in assets/. 1. Analyze the schema Accepts SQL DDL or JSON schema (assets/sampleschema.sql / sampleschema.json). …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills alirezarezvani/database-designer--3b9f00