sql-database-assistant
Write, fix and speed up SQL: slow queries, EXPLAIN plans, indexes, ORM migrations (Prisma, Drizzle, SQLAlchemy). Load whenever a query is slow or wrong, the user needs SQL written, or an ORM migration.
Target: Databases. Automatically collected · unverified.
Excerpt from the author’s documentation
Extracted from a fixed version of SKILL.md in its original language. This is the author’s documentation; installation, compatibility and runtime results have not been verified by this site.
Read the original English text
Topics in the source
- SQL Database Assistant - POWERFUL Tier Skill
- Overview
- Core Capabilities
- Tools
- Natural Language to SQL
- Translation Patterns
- Common Query Templates
- Schema Exploration
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. 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 | Script | Purpose | |--------|---------| | scripts/queryoptimizer.py | Static analysis of SQL queries for performance issues | | scripts/migrationgenerator.py | Generate migration file templates from change descriptions | | scripts/schemaexplorer.py | Generate schema documentation from introspection queries | -- When converting requirements to SQL, follow this sequence: 1. Id
This is an excerpt. Refer to the complete source and its current requirements.
- Source repository
- alirezarezvani/claude-skills
- Source file
- engineering/skills/sql-database-assistant/SKILL.md
- Fixed revision
- 8f082544116fc0d014188e521ca40304cdfc86b0
Requirements
- Only the author’s Skill metadata is included. Read the full instructions to check dependencies, licensing and conditions of use.
A small first task
先阅读原作者说明，再决定是否在自己的 AI 工具中使用。
Instructions for your AI tool
- Claude Desktop: resource-specific guide not available yet
- Claude Code: resource-specific guide not available yet
- Cursor: resource-specific guide not available yet
- Codex: resource-specific guide not available yet
Author documentation is not live verification by this site. Without evidence, we do not mark a resource as compatible, safe or free.
Sources and evidence
This record was collected automatically. Its documentation, suitability and runtime behavior have not been manually verified.
Author: alirezarezvani/claude-skills · original repository metadata. Documentation review: Not reviewed. Last source check: 2026-11-09T14:01:46.900Z.
Categories are inferred from names, descriptions and paths. They do not establish compatibility.
License and attribution
MIT. Third-party content and copyright remain with their authors. Refer to the original license and terms.
Original license ↗Synchronization, copying and user-reported success do not mark a resource as runtime-tested.
Limitations and notes
- Collecting metadata does not mean this site has installed, adapted, runtime-tested or security-reviewed the resource.