skills.rest
4lerman
4lermanCOMMUNITY
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/4lerman/text_evaluator --skill sql-database-assistant-4lerman
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
FindMalekFindMalek
9

prisma-database-setup

Configure Prisma for multiple database providers and set up the client.

Community
Intermediate
89jobrien89jobrien
4

database-optimization

Optimize slow SQL queries and resolve N+1 problems in relational databases.

Community
Advanced
rnavarychrnavarych
14

role-database:connection-management

Configure database connection pooling across PostgreSQL and MySQL engines.

Community
Advanced
porcupine-mdporcupine-md
11

migration

Detect ORMs, update schemas, generate migrations, and validate changes.

Official
Advanced