skills.rest
Patasse97
Patasse97COMMUNITY
Explore all skills by this author →
GitHub

sql-database-assistant

Translate natural language requests into SQL queries and migrations across multiple dialects.

Updated Apr 9, 2026
Search Tags:#migrations#optimization#schema#queries#sql#orm#dialects
One-click install
npx skills add https://github.com/Patasse97/claude-skills --skill sql-database-assistant
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-database-assistant
Source: https://github.com/Patasse97/claude-skills/tree/main/engineering/sql-database-assistant
Command: npx skills add https://github.com/Patasse97/claude-skills --skill sql-database-assistant

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

Writes correct SQL queries, generates migrations, and provides ORM-ready patterns across multiple dialects to help software engineers manage database tasks more reliably.

Core Features & Use Cases

  • Natural Language to SQL: translate requirements into accurate queries for PostgreSQL, MySQL, SQLite, and SQL Server.
  • Migration Generation & Schema Exploration: create up/down scripts and inspect database schemas to align application code with the data layer.
  • ORM Patterns & Multi-Database Support: provide guidance and templates for Prisma, Drizzle, TypeORM, and SQLAlchemy, with dialect-aware recommendations.

Quick Start

Create a migration to add an orders table with an id primary key and a user_id foreign key.

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 migrations from natural language for PostgreSQL or MySQL?▼

Natural language to SQL translation converts plain database requests into accurate queries and ORM-ready patterns. It maps types dialect-aware across PostgreSQL, MySQL, SQLite, and SQL Server to ensure portable changes.

Can I use this to generate ORM patterns for Prisma, Drizzle, TypeORM, and SQLAlchemy?▼

Yes, it provides guidance and templates for Prisma, Drizzle, TypeORM, and SQLAlchemy. It aligns application code with the data layer using dialect-aware recommendations across supported databases.

How do I write cross-dialect SQL queries that work safely across different database engines?▼

Cross-dialect SQL queries are generated with dialect-aware type mapping and validation checks. This ensures accurate, portable query execution across PostgreSQL, MySQL, SQLite, and SQL Server from a single natural language request.

What is the best way to explore a database schema and tune SQL performance?▼

Schema exploration inspects database structures to align application code with the data layer, while performance tuning optimizes the generated SQL queries. This approach streamlines database tasks reliably for software engineers.

Does this SQL assistant support schema validation checks for migration scripts?▼

Yes, migration generation includes validation checks to ensure safe and portable schema changes. It creates up and down scripts with dialect-aware type mapping to prevent migration errors across supported database dialects.

Related Skills

Explore More Software Engineering Skills→
FabianrzsFabianrzs

prisma-database-setup

Configure Prisma across PostgreSQL, MySQL, SQLite, MongoDB, and SQL Server.

Community
Advanced
jabrenajabrena
423

513-frameworks-micronaut-db-migrations-flyway

Manage Flyway database migrations in Micronaut applications.

Community
Advanced
FaysilAlshareefFaysilAlshareef
4

ef-migrations

Automate EF Core migration creation, application, and management in .NET projects.

Community
Advanced
4lerman4lerman

sql-database-assistant

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

Community
Advanced