sql-queries

Generate optimized SQL queries from natural language for multiple dialects.

Updated Mar 30, 2026
One-click install
npx skills add https://github.com/omeragaakbas/zoyare --skill sql-queries-omeragaakbas
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: sql-queries
Source: https://github.com/omeragaakbas/zoyare/tree/main/.claude/skills/sql-queries
Command: npx skills add https://github.com/omeragaakbas/zoyare --skill sql-queries-omeragaakbas

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Convert natural language questions and analysis requirements into correct, efficient SQL so teams can get insights without writing complex queries by hand.

Core Features & Use Cases

  • Multi-Dialect Support: Generate queries for BigQuery, PostgreSQL, MySQL, Snowflake, SQL Server and other SQL dialects.
  • Schema-Aware Generation: Read uploaded schema files, SQL dumps, or diagram descriptions to extract tables, columns, keys, and relationships.
  • Query Optimization & Testing: Produce production-ready SQL with explanatory comments, performance notes, suggested indexes or partitioning, and optional test scripts or sample data.
  • Use Case: Analysts or engineers can ask for a revenue-by-region BigQuery report, a cohort analysis in PostgreSQL, or a MySQL aggregation for dashboards without hand-coding joins and aggregations.

Quick Start

Generate a PostgreSQL query to find users who signed up in the last 30 days and had at least five active sessions using the uploaded schema file.

Frequently Asked Questions about sql-queries

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

FAQPage Schema
How do I generate optimized SQL queries from natural language for BigQuery or PostgreSQL?

To generate optimized SQL queries from natural language, describe your analysis requirements and upload a schema file. The system translates your text into production-ready SQL for BigQuery, PostgreSQL, MySQL, and Snowflake, complete with comments and performance notes.

Can I translate business questions into SQL without manually writing complex joins and aggregations?

Yes, you can translate business questions into SQL by providing a natural language description of the needed report. The system reads your schema to handle table relationships, generating the necessary joins and aggregations automatically without manual coding.

Does natural language SQL generation work with uploaded schema files and SQL dumps?

Yes, natural language SQL generation works with uploaded schema files, SQL dumps, or diagram descriptions. It extracts tables, columns, and keys from these inputs to ensure the generated queries respect your actual database structure and chosen SQL dialect.

What is the best way to perform query optimization and testing for generated SQL scripts?

The best way to perform query optimization and testing on generated SQL is to use the built-in performance notes, suggested indexes, and optional test scripts. These features ensure your queries are production-ready and efficient for analytics and reporting tasks.

Can I create a cohort analysis query in PostgreSQL using a natural language prompt?

Yes, you can create a cohort analysis query in PostgreSQL by asking for it in a natural language prompt. The system applies your specific SQL dialect and schema to produce the correct query logic for your analytics requirements.

Why should I include schema files when generating SQL queries for dashboards?

Including schema files when generating SQL queries ensures the output respects your actual database tables, columns, and relationships. This schema-aware generation prevents incorrect joins and produces accurate, production-ready queries for your dashboards.