skills.rest
ano4l
ano4lCOMMUNITY
Explore all skills by this author →
GitHub

sql-database-assistant

Automate SQL queries, migrations, and ORM integration across multiple databases.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Bridges the gap between database design and application code by providing guided SQL query generation, migration templating, and ORM integration workflows.

Core Features & Use Cases

  • Natural-language to SQL translation for PostgreSQL, MySQL, SQLite, and SQL Server
  • Migration generation templates (up/down) across dialects and ORMs
  • ORM pattern references for Prisma, Drizzle, TypeORM, and SQLAlchemy
  • Schema exploration and documentation assistance via introspection queries

Quick Start

Provide a database task description and the assistant will generate SQL queries, migrations, or ORM code.

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 PostgreSQL and MySQL?▼

To generate SQL queries from natural language for PostgreSQL and MySQL, you provide a task description and the assistant translates it into the appropriate dialect, handling query optimization and schema introspection.

Can I use this to generate migration templates for Prisma and TypeORM?▼

Yes, you can generate migration templates for Prisma and TypeORM. The assistant provides up/down migration generation across dialects and offers ORM pattern references for multiple frameworks.

What's the best way to explore a database schema using introspection queries?▼

The best way to explore a database schema is using introspection-driven queries. The assistant automates schema discovery and generates documentation assistance to map your database structure accurately.

Does this assistant support cross-ORM migrations with dialect mapping?▼

Yes, cross-ORM migrations are supported with dialect mapping. It handles multi-ORM patterns and applies error handling to map between PostgreSQL, MySQL, SQLite, and SQL Server workflows.

How do I create up and down migrations across different SQL dialects?▼

You create up and down migrations across SQL dialects by providing a database task description. The assistant generates migration templates tailored to your specific dialect and ORM integration requirements.

Related Skills

Explore More Software Engineering Skills→
ripgraphicsripgraphics

database-expert

Analyze database query plans and optimize performance across PostgreSQL, MySQL, MongoDB, and SQLite.

Community
Advanced
DanielPodolskyDanielPodolsky
274

database-fundamentals

Analyze database schema design, SQL queries, and ORM usage for correctness.

Community
Basic
jeremylongshorejeremylongshore
2.6k

generating-orm-code

Generate ORM models and database schemas across multiple frameworks.

Community
Intermediate
zmh13928433602-syszmh13928433602-sys

drizzle

Define and manage PostgreSQL schemas and migrations with Drizzle ORM in TypeScript.

Community
Intermediate