sql-database-assistant - Write, optimize, and manage database SQL
Writes SQL, analyzes query performance, explores schemas, generates migrations, and supports Prisma, Drizzle, TypeORM, and SQLAlchemy workflows.
Tags
Updated: 2026-10-01Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Translate requirements into SQL
- Explore database schemas
- Analyze query performance
- Recommend indexes and rewrites
- Detect ORM N+1 queries
- Generate reversible migrations
- Generate schema documentation
- Support database dialect differences
Inputs
- User requirements
- SQL queries or query files
- Database schema information
- Database connection details
- Migration change descriptions
- Database dialect
- ORM context
Outputs
- SQL queries
- Query optimization recommendations
- Index recommendations
- Migration scripts
- Schema documentation
- ORM integration patterns
Requirements
- Python runtime for included scripts
- Database access for live introspection
- Database access for EXPLAIN analysis