sql-database-assistant

SKILL.md

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