skills sourced live from GitHub · all skills listed are free · each skill is provided under its author's license.
home / Database / SQL Database Assistant Skill by @alirezarezvani
The skill is the engineering/skills/sql-database-assistant folder inside that repository. Copy it into the folder your agent loads skills from; check your agent's documentation for where that is.
Everyday SQL help: writing queries, reading EXPLAIN plans, adding indexes and generating ORM migrations.
Positioned as the operational companion to schema design. It translates plain language into SQL, offers query templates and introspection queries and handles migrations for tools like Prisma, Drizzle and SQLAlchemy.
The original SKILL.md is organised into these sections:
Written and maintained by @alirezarezvani. It is published under the MIT license, which allows reuse with attribution. See the author profile. SkillDirectory does not claim authorship: this page adds our own review and links back to the original, and the skill's text belongs to its author.
# 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 | …
Excerpt only, quoted from the author's repository. Open the repository for the complete file.