skills.rest
Eigo-Mt-Fuji
Eigo-Mt-FujiCOMMUNITY
Explore all skills by this author →
Website𝕏@EikichiEngineerGitHub

query-designer

Translate natural-language SQL requests into dialect-aware queries for PostgreSQL, MySQL, SQLite, SQL Server, and Oracle.

Updated Jan 10, 2026
Search Tags:#performance#SQL#queries#generate#dialects#nl2sql
One-click install
npx skills add https://github.com/Eigo-Mt-Fuji/portfolio-2026 --skill query-designer
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: query-designer
Source: https://github.com/Eigo-Mt-Fuji/portfolio-2026/tree/main/.claude/skills/query-designer
Command: npx skills add https://github.com/Eigo-Mt-Fuji/portfolio-2026 --skill query-designer

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill translates natural-language SQL requests into optimized, dialect-aware queries, enabling developers and analysts to convert vague requirements into precise instructions for databases.

Core Features & Use Cases

  • Dialect-aware generation: Produces SQL in PostgreSQL, MySQL, SQLite, SQL Server, and Oracle dialects.
  • Query composition: Handles multi-table joins, GROUP BY, window functions, and subqueries.
  • Performance guidance: Recommends indexing strategies and clean execution patterns; explains tradeoffs and suggests alternatives.
  • Use Case: When you have a natural-language request like "top 10 customers by revenue last 30 days," it outputs production-ready SQL and a plan outline.

Quick Start

The skill can be used by asking for a SQL query design, for example:

  • "Generate a PostgreSQL query to list the top 5 products by total sales in the last 30 days."

Frequently Asked Questions about query-designer

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

FAQPage Schema
How do I convert natural language to optimized SQL queries?▼

Natural language to SQL conversion translates plain-English requests into production-ready queries. This Skill accepts requests like 'top 10 customers by revenue' and outputs optimized SQL with dialect-specific syntax for PostgreSQL, MySQL, SQLite, SQL Server, or Oracle, plus indexing recommendations.

Can I generate SQL queries for multiple database dialects?▼

Yes, this Skill generates dialect-aware SQL across five databases: PostgreSQL, MySQL, SQLite, SQL Server, and Oracle. It adapts syntax, functions, and window-function implementations to each platform's specific requirements and performance characteristics.

Does it handle complex queries with joins and aggregations?▼

Yes, it composes multi-table joins, GROUP BY clauses, window functions, and subqueries. It translates complex analytical requests into structured SQL and explains execution patterns and performance tradeoffs for production deployment.

What SQL performance guidance does it provide?▼

Beyond query generation, it recommends indexing strategies, suggests alternative query patterns, and explains execution tradeoffs. This enables you to understand performance implications and deploy optimized, maintainable SQL in production.

When should I use natural language SQL generation instead of writing queries manually?▼

Use it when converting vague requirements into precise SQL quickly, onboarding non-SQL users, or validating query designs. It's most valuable for ad-hoc analytical requests and ensuring dialect compatibility across multiple database platforms.

Related Skills

Explore More Data & Analytics Skills→
dotlab-hqdotlab-hq

schema-exploration

List database tables, columns, data types, and foreign key relationships.

Official
Intermediate
weirdgmeweirdgme
4

platform-engineering

Design and implement scalable platform engineering patterns for internal developer platforms.

Community
Advanced
s710082105s710082105
1

fr-db

Detect database schemas and generate FineReport-ready SQL queries and XML fragments.

Community
Advanced
arbazkhan971arbazkhan971
26

query

Analyze EXPLAIN plans and recommend indexes for slow database queries.

Community
Advanced