sqlite-review

What problem does it solve?

This Skill addresses performance bottlenecks and schema inefficiencies within SQLite databases, ensuring optimal data storage and retrieval.

Core Features & Use Cases

• Schema Auditing: Reviews table structures, column types, constraints, and foreign keys for correctness and efficiency.
• Index Analysis: Identifies missing, redundant, or unused indexes by analyzing query execution plans.
• Query Tuning: Optimizes slow queries by recommending index additions or query rewrites.
• PRAGMA Optimization: Adjusts SQLite configuration pragmas (e.g., cache_size, journal_mode) for better performance.
• Use Case: After a new feature adds complex reporting queries, use this Skill to analyze the findings.db schema and query performance, identifying and adding necessary indexes to keep reports fast.

Quick Start

Use the sqlite-review skill to analyze the database located at /path/to/findings.db.