Database Schema Analysis
CommunityOptimize your database schema for performance
AuthorStrategicMilk
Version1.0.0
Installs0
System Documentation
What problem does it solve?
It helps developers and data engineers identify design flaws, missing indexes, and migration risks in SQLite, PostgreSQL, or ORM‑based schemas, preventing performance degradation and data integrity issues.
Core Features & Use Cases
- Schema extraction: Reads tables, columns, constraints, and relationships from a live database or model files.
- Normalization & index assessment: Detects redundant data, missing or redundant indexes, and evaluates normalization levels.
- Query pattern analysis & migration safety: Provides execution‑plan insights, risk assessments, and rollback strategies for schema changes.
- Report generation: Outputs a structured JSON report with prioritized recommendations for immediate action.
Quick Start
Use the database schema analysis skill to generate an optimization report for the project's SQLite memory database.
Dependency Matrix
Required Modules
None requiredComponents
Standard packageđź’» 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: Database Schema Analysis Download link: https://github.com/StrategicMilk/Vetinari-Orchestrastor/archive/main.zip#database-schema-analysis 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.