sql-database-assistant

# SQL Database Assistant - POWERFUL Tier Skill ## Overview The operational companion to database design. While **database-designer** focuses on schema architecture and **database-schema-designer** handles ERD modeling, this skill covers the day-to-day: writing queries, optimizing performance, generating migrations, and bridging the gap between application code and database engines. ### Core Capabilities - **Natural Language to SQL** — translate requirements into correct, performant queries - **Schema Exploration** — introspect live databases across PostgreSQL, MySQL, SQLite, SQL Server - **Query Optimization** — EXPLAIN analysis, index recommendations, N+1 detection, rewrite patterns - **Migration Generation** — up/down scripts, zero-downtime strategies, rollback plans - **ORM Integration** — Prisma, Drizzle, TypeORM, SQLAlchemy patterns and escape hatches - **Multi-Database Support** — dialect-aware SQL with compatibility guidance ### Tools | Script | Purpose | |--------|---------| | `scripts/query_optimizer.py` | Static analysis of SQL queries for performance issues | | `scripts/migration_generator.py` | Generate migration file templates from change descriptions | | `scripts/schema_explorer.py` | Generate schema documentation from introspection queries | --- ## Natural Language to SQL ### Translation Patterns When converting requirements to SQL, follow this sequence: 1. **Identify entities** — map nouns to tables 2. **Identify relationships** — map verbs to JOINs...