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 Show more