skills.rest
devCharuzu
devCharuzuCOMMUNITY
Explore all skills by this author →
GitHub

sql-database-assistant

Translate user requirements into SQL queries, migration scripts, and ORM patterns.

Updated Apr 16, 2026
Search Tags:#database#optimization#migration#sql#orm#prisma#schema-exploration
One-click install
npx skills add https://github.com/devCharuzu/philfida-taskmanage --skill sql-database-assistant-devcharuzu
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-database-assistant
Source: https://github.com/devCharuzu/philfida-taskmanage/tree/main/.windsurf/skills/sql-database-assistant
Command: npx skills add https://github.com/devCharuzu/philfida-taskmanage --skill sql-database-assistant-devcharuzu

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

The SQL Database Assistant reduces the manual effort required to write SQL queries, optimize performance, migrate schemas, and explore database structures, bridging the gap between application code and databases.

Core Features & Use Cases

  • Natural Language to SQL translates business requirements into correct, efficient SQL queries across PostgreSQL, MySQL, SQLite, and SQL Server.
  • Schema Exploration introspects live schemas and generates documentation, diagrams, and ORM-friendly patterns.
  • Migration Generation & ORM Integration creates up/down migration scripts and provides ORM-specific patterns for Prisma, Drizzle, TypeORM, and SQLAlchemy.
  • Query Optimization Aids analyzes queries, suggests indexes, and provides static analysis tools to improve performance.

Quick Start

Describe your database task in plain language to receive SQL queries, migrations, or schema insights.

Frequently Asked Questions about sql-database-assistant

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

FAQPage Schema
How do I translate natural language requirements into SQL queries for PostgreSQL and MySQL?▼

SQL queries are generated by translating plain language business requirements into correct, efficient SQL across PostgreSQL, MySQL, SQLite, and SQL Server. This process enforces best-practice guidelines and parameterization for safe execution.

Can I generate database migration scripts and ORM patterns for Prisma and TypeORM?▼

Migration scripts and ORM patterns for Prisma, Drizzle, TypeORM, and SQLAlchemy are generated by creating up/down migration scripts and providing ORM-specific schema patterns. This bridges the gap between application code and database structures.

What is the best way to optimize slow SQL queries and suggest database indexes?▼

Query optimization is achieved by analyzing SQL queries, suggesting indexes, and providing static analysis tools to improve performance. This reduces the manual effort required to identify bottlenecks and optimize database performance.

How does live schema introspection work for generating database documentation?▼

Schema introspection works by examining live database structures to generate documentation, diagrams, and ORM-friendly patterns. This allows you to explore database schemas and generate ready-to-use code without manual inspection.

Do I need a specific database dialect to get dialect-aware SQL recommendations?▼

No specific dialect is required, as dialect-aware recommendations are applied across PostgreSQL, MySQL, SQLite, and SQL Server. The system automatically adjusts generated SQL queries and migration scripts to match your target database.

Why should I use parameterized SQL queries for safe migrations and schema exploration?▼

Parameterized SQL queries are enforced to ensure safe migrations and prevent injection vulnerabilities during schema exploration. This best-practice guideline secures database interactions while translating requirements into executable code.

Related Skills

Explore More Software Engineering Skills→
mdnaimul22mdnaimul22
2

sql-database-assistant

Convert user requirements into dialect-aware SQL with schema introspection and migration templates.

Community
Advanced
hiroto0701hiroto0701

prisma-expert

Optimize Prisma ORM schemas, migrations, and queries across SQL databases.

Community
Advanced
IliyaBrookIliyaBrook
114

lint

Runs linting checks on shell scripts and Dockerfiles using automated tools.

Community
Basic
4lerman4lerman

sql-database-assistant

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

Community
Advanced