data-write-query

Generate optimized SQL queries from natural language descriptions.

114|13|Updated Jan 17, 2026
One-click install
npx skills add https://github.com/frumu-ai/tandem --skill data-write-query
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: data-write-query
Source: https://github.com/frumu-ai/tandem/tree/main/src-tauri/resources/skill-templates/data-write-query
Command: npx skills add https://github.com/frumu-ai/tandem --skill data-write-query

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill automates the generation of SQL queries from natural language descriptions, ensuring optimization for specific SQL dialects and adherence to best practices.

Core Features & Use Cases

  • Natural Language to SQL: Translate plain English requests into executable SQL queries.
  • Dialect Optimization: Generates queries tailored to various SQL dialects (PostgreSQL, Snowflake, BigQuery, etc.).
  • Best Practice Adherence: Incorporates CTEs, proper aliasing, filtering, and performance considerations.
  • Use Case: A data analyst needs to find the total revenue per product category for the last quarter. They can describe this to the Skill, which will then generate an optimized SQL query for their specific database.

Quick Start

Ask the skill to write a query to count orders.

Frequently Asked Questions about data-write-query

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

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

To generate SQL queries from natural language, you describe your data retrieval requirements in plain English, and the system translates your request into executable SQL optimized for your specific database dialect.

Can I write optimized SQL for different database dialects like PostgreSQL and Snowflake?

Yes, you can write optimized SQL for different dialects like PostgreSQL and Snowflake. The system tailors query generation to specific SQL dialects, ensuring the syntax and functions match your database environment.

Does natural language to SQL generation follow best practices like using CTEs and aliasing?

Yes, natural language to SQL generation incorporates best practices by structuring queries with Common Table Expressions (CTEs), proper aliasing, efficient filtering, and performance considerations for optimized data retrieval.

What is the best way to write SQL for data analysis without deep SQL knowledge?

The best way to write SQL for data analysis without deep SQL knowledge is using natural language query generation. You simply describe your analytical needs, such as total revenue per category, to receive an executable, optimized SQL query.

Do I need to provide a database schema to generate optimized SQL queries?

For warehouse-connected scenarios, the system uses schema introspection to understand your database structure. Providing your schema ensures the generated SQL queries are accurately aligned with your tables and columns.

What are the limitations of generating SQL from natural language for data manipulation?

Generating SQL from natural language requires clear user-defined requirements and accurate schema understanding. Complex analytical logic may need precise descriptions to ensure the generated query returns the correct data manipulation results.