Database Schema Analysis

Name: Database Schema Analysis
Availability: InStock
Author: strategicmilk

Analyze SQLite, PostgreSQL, or ORM schemas and output a JSON report.

Updated Mar 3, 2026

Search Tags:#performance #database #schema #analysis #migration #index

Ready to run

npx skills add https://github.com/StrategicMilk/Vetinari-Orchestrastor --skill database-schema-analysis

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: Database Schema Analysis
Source: https://github.com/StrategicMilk/Vetinari-Orchestrastor/tree/main/vetinari/skills/catalog/worker/database-schema-analysis
Command: npx skills add https://github.com/StrategicMilk/Vetinari-Orchestrastor --skill database-schema-analysis

SYSTEM DOCUMENTATION & REQUIREMENTS

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.

Frequently Asked Questions about Database Schema Analysis

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I analyze a database schema for performance issues?▼

To analyze database schema performance, you extract tables, columns, and constraints to detect missing indexes, redundant data, and normalization flaws. This process generates a structured JSON report with prioritized recommendations for immediate optimization actions.

What is the best way to check database migration safety and rollback risks?▼

Checking database migration safety involves assessing execution plans, evaluating risk levels, and preparing rollback strategies for schema changes. This analysis identifies potential data integrity issues and performance degradation before applying changes to your database.

Can I use schema analysis tools with PostgreSQL and ORM model files?▼

Yes, schema analysis works with SQLite, PostgreSQL, and ORM-based model files. It reads live databases or model definitions to evaluate query patterns, index coverage, and relationships, producing a JSON report detailing schema details and optimization steps.

Why does my database query run slowly even with indexes present?▼

Slow database queries often result from redundant or missing indexes, poor normalization, or flawed schema design. Analyzing query patterns and execution plans helps identify these structural issues and provides prioritized recommendations to resolve performance bottlenecks.

How do I identify missing or redundant indexes in my SQL database?▼

Identifying missing or redundant indexes requires assessing your schema against query patterns to evaluate index coverage. The analysis detects redundant data and missing indexes, outputting a JSON report with prioritized actions to optimize database performance.