write-query

Translate natural-language data needs into dialect-specific SQL queries.

1|Updated Mar 27, 2026
One-click install
npx skills add https://github.com/qytay-palo/gen-e2-analysis-workflow --skill write-query-qytay-palo
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: write-query
Source: https://github.com/qytay-palo/gen-e2-analysis-workflow/tree/main/.claude/skills/data-analysis-lifecycle/write-query
Command: npx skills add https://github.com/qytay-palo/gen-e2-analysis-workflow --skill write-query-qytay-palo

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Translate natural-language data needs into optimized SQL queries tailored to your SQL dialect, handling complex structures with clarity and speed.

Core Features & Use Cases

  • Dialect-aware SQL generation: Produces queries optimized for Snowflake, BigQuery, Postgres, Redshift, and more.
  • Multi-CTE and complex joins: Builds expressive queries with clear structure and maintainable aliases.
  • Performance-conscious defaults: Applies best practices like explicit column selection, early filtering, and appropriate join types.
  • Use Case: For example, describing "yearly revenue by region for last quarter" yields a single, readable SQL statement suitable for production deployment.

Quick Start

Describe your data need and dialect to generate the corresponding SQL query instantly.

Frequently Asked Questions about write-query

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

FAQPage Schema
How do I write optimized SQL queries from natural language descriptions?

To write optimized SQL queries from natural language, you describe your data need and specify your SQL dialect. The tool then identifies required output columns, filters, aggregations, and joins to construct a performant, readable query.

Does this tool support generating SQL for multiple dialects like Snowflake and BigQuery?

Yes, it supports dialect-aware SQL generation for multiple platforms including Snowflake, BigQuery, Postgres, and Redshift. It tailors the query syntax and performance optimizations to the specific dialect you specify.

How do I build complex SQL queries with multiple CTEs and joins?

To build complex SQL queries with multiple CTEs and joins, you provide a natural-language description of your data need. The tool constructs an expressive, readable query using clear structure and maintainable aliases for production deployment.

What is the best way to optimize SQL queries for large data volumes?

The best way to optimize SQL queries for large data volumes is to apply performance-conscious defaults. This tool uses explicit column selection, early filtering, and appropriate join types to ensure production-grade performance.

Can I use this for production-grade analytics tasks across different database systems?

Yes, you can use this for production-grade analytics tasks across different database systems. It is specifically designed to handle large data volumes and generate maintainable, performant SQL statements tailored to your specific dialect.

Why does my generated SQL query need explicit column selection and early filtering?

Your generated SQL query needs explicit column selection and early filtering because they are performance-conscious best practices. Applying these defaults ensures the query remains performant and readable when processing large data volumes.