skills.rest
tarunccet
tarunccetCOMMUNITY
Explore all skills by this author →
GitHub

sql-queries

Generate dialect-specific SQL queries from natural language and schema files.

5|2|Updated Mar 27, 2026
Search Tags:#query optimization#postgresql#sql#mysql#bigquery#query generation
One-click install
npx skills add https://github.com/tarunccet/pm-skills --skill sql-queries-tarunccet
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-queries
Source: https://github.com/tarunccet/pm-skills/tree/main/pm-data-analytics/skills/sql-queries
Command: npx skills add https://github.com/tarunccet/pm-skills --skill sql-queries-tarunccet

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Convert ambiguous business questions and analysis needs into accurate, production-ready SQL so non-experts can get reliable database results without wrestling with dialect syntax or schema details.

Core Features & Use Cases

  • Multi-dialect SQL generation: Produce queries for PostgreSQL, MySQL, BigQuery, Snowflake, and more, adapting syntax and functions per platform.
  • Schema-aware queries: Read uploaded schema files or diagram descriptions to infer tables, columns, keys, and relationships before generating SQL.
  • Optimization & testing guidance: Include comments, performance suggestions (indexes, partitioning), and sample validation steps or test scripts for large datasets.
  • Use Case: Generate a BigQuery query to calculate monthly revenue by region with year-over-year growth, including performance notes for partitioned tables.

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 SQL queries from natural language for PostgreSQL and BigQuery?▼

To generate SQL queries from natural language, provide a text description of your analysis needs and the tool outputs optimized PostgreSQL or BigQuery syntax. It adapts functions per dialect and includes comments for validation.

Can I upload a database schema file to create accurate SQL queries?▼

Yes, you can upload a database schema file or describe a diagram to generate schema-aware SQL queries. The tool reads these inputs to infer tables, columns, keys, and relationships before producing the query.

Does this SQL query generator support performance optimization and indexing suggestions?▼

Yes, the SQL query generator supports performance optimization by suggesting indexes and partitioning strategies. It also provides sample validation steps and test scripts for large datasets within the generated output.

How do I write a BigQuery query for monthly revenue by region with year-over-year growth?▼

To write a BigQuery query for monthly revenue by region with year-over-year growth, describe the calculation need in natural language. The tool generates the dialect-specific query and adds performance notes for partitioned tables.

What is the best way to convert business questions into production-ready SQL for Snowflake?▼

The best way to convert business questions into production-ready SQL for Snowflake is to input your analysis requirements in plain text. The tool handles dialect-specific syntax and schema details to output reliable database results.

Do I need to know SQL syntax to build reports from a MySQL database?▼

No, you do not need to know SQL syntax to build reports from a MySQL database. Provide a natural language description of the report and the tool generates the correct MySQL query with testing guidance.

Related Skills

Explore More Data & Analytics Skills→
taishan1994taishan1994
30

schema-exploration

Identify and describe relational database schemas with tables, columns, keys, and relationships.

Community
Intermediate
nimrodfishernimrodfisher
351

query-validation

Validate SQL queries for correctness, performance, and best practices.

Community
Intermediate
jc180105jc180105

Analytics Reporter

Transform raw data into structured business insights and executive-ready reports.

Community
Advanced
marquesfelipmarquesfelip

sql-injection-prevention

Identify and fix SQL injection vulnerabilities in data access layers.

Community
Advanced