sql-database-assistant

Generate SQL queries, introspect schemas, optimize performance, and create migration scripts.

Updated Apr 2, 2026

Search Tags:#database management #migration #sql #database optimization #orm integration

Ready to run

npx skills add https://github.com/4lerman/text_evaluator --skill sql-database-assistant-4lerman

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: sql-database-assistant
Source: https://github.com/4lerman/text_evaluator/tree/main/.agents/skills/engineering-advanced-skills/sql-database-assistant
Command: npx skills add https://github.com/4lerman/text_evaluator --skill sql-database-assistant-4lerman

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires sqlalchemy, prisma, drizzle-orm, typeorm, pgbouncer, proxysql, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill empowers users to manage SQL databases with ease, providing expert guidance for writing queries, optimizing performance, generating migrations, and exploring schemas.

Core Features & Use Cases

Natural Language to SQL: Translate requirements into SQL queries effortlessly.
Schema Exploration: Introspect live databases and generate schema documentation.
Query Optimization: Analyze and optimize query performance with EXPLAIN analysis and index recommendations.
Migration Generation: Create migration scripts for schema changes with zero-downtime strategies.
ORM Integration: Bridge the gap between application code and database engines with support for Prisma, Drizzle, TypeORM, and SQLAlchemy.
Use Case: A developer uses this Skill to quickly create a migration script for adding a new column to a database table, ensuring the migration is safe and efficient.

Quick Start

Use the sql-database-assistant skill to generate a migration for adding a new column 'email_verified' to the 'users' table.

Frequently Asked Questions about sql-database-assistant

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I generate SQL queries from natural language for database management?▼

SQL query generation from natural language translates development requirements directly into executable SQL queries. It bridges application code and database engines using Python scripts for execution.

What's the best way to create zero-downtime database migration scripts?▼

Creating zero-downtime database migration scripts involves generating safe schema change scripts for adding columns or modifying tables. This ensures database migrations are efficient and non-disruptive to live workloads.

Does this database optimization tool work with Prisma and Drizzle ORM?▼

Database optimization and ORM integration support Prisma, Drizzle ORM, TypeORM, and SQLAlchemy. This allows you to bridge application code with database engines for schema changes and query performance tuning.

How do I analyze query performance and get index recommendations using EXPLAIN?▼

Query optimization with EXPLAIN analysis evaluates SQL execution plans to identify performance bottlenecks. It provides targeted index recommendations to improve database query speed and overall efficiency.

Can I introspect a live database schema and generate documentation?▼

Schema exploration introspects live SQL databases to extract structural metadata. It generates comprehensive schema documentation, enabling developers to understand and navigate complex database architectures.