What problem does it solve? Working with relational databases often requires recalling dialect-specific syntax, connection flags, and optimization techniques across SQLite, PostgreSQL, and MySQL. This Skill consolidates those patterns so you can design schemas, write queries, run migrations, and tune performance without searching documentation. ## Core Features & Use Cases - Multi-Dialect Coverage: Provides concrete syntax for SQLite, PostgreSQL, and MySQL, including JSONB queries, enum types, and auto-increment differences. - Schema Design & Migrations: Includes table creation patterns, foreign keys, triggers, and a numbered SQL migration script with a tracking table. - Query Optimization: Covers EXPLAIN analysis, composite and partial indexes, covering indexes, and detecting unused indexes. - Use Case: You inherit a slow PostgreSQL reporting query. Use this Skill to run EXPLAIN ANALYZE, identify a sequential scan, and add a partial index that matches the query's filter conditions. ## Quick Start Ask the assistant to create a SQLite database with a users and orders table, then write a query showing each user's total spending.
