sql-database-assistant

原文涵盖的主题

• 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

这里只展示节选，请以完整原文和当前要求为准。