Is the generated code optimized for performance?

Absolutely. The skill includes performance notes and suggests optimizations like indexing, partitioning, or alternative query structures for handling large datasets.

Do I need to be a SQL expert to use this?

No, it is designed for product managers and analysts as well as engineers, providing clear explanations of the query logic to help users learn and validate the output.

Can it read my existing database structure?

Yes, it can analyze uploaded SQL schema files, database documentation, or text descriptions of diagrams to understand your specific table relationships and constraints.

Which SQL dialects are supported by this skill?

The skill supports a wide range of dialects including BigQuery, PostgreSQL, MySQL, Snowflake, SQL Server, and other common SQL standards.

SQL Query Generator

Name: SQL Query Generator
Author: autostay-kr

byautostay-kr

•

数据库管理

Generates optimized SQL queries from natural language across multiple database dialects using context-aware schema analysis.

The SQL Query Generator skill streamlines the bridge between business requirements and technical implementation by transforming natural language descriptions into production-ready SQL code. It intelligently analyzes provided schema files, documentation, or diagram descriptions to understand table relationships, data types, and keys, ensuring high accuracy for complex joins and aggregations. Supporting a wide range of dialects including BigQuery, PostgreSQL, and Snowflake, this skill provides commented code, performance-tuning suggestions, and plain-English explanations to help product managers, analysts, and engineers interact with data more efficiently.

主要功能

01Multi-dialect support for BigQuery, PostgreSQL, MySQL, Snowflake, and SQL Server

02Detailed plain-English logic explanations and performance considerations

03Automated query optimization suggestions including indexing and partitioning

04Context-aware generation based on uploaded schema files and documentation

051 GitHub stars

06Generation of validation test scripts and sample data

使用场景

01Optimizing and explaining existing SQL queries to improve performance on large datasets

02Translating complex business questions into efficient analytical queries for data reports

03Generating database migration scripts or complex joins based on provided schema diagrams

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add autostay-kr/autostay-skills sql-queries

For use in Claude.ai and ChatGPT

主要功能

01Multi-dialect support for BigQuery, PostgreSQL, MySQL, Snowflake, and SQL Server

02Detailed plain-English logic explanations and performance considerations

03Automated query optimization suggestions including indexing and partitioning

04Context-aware generation based on uploaded schema files and documentation

051 GitHub stars

06Generation of validation test scripts and sample data

使用场景

01Optimizing and explaining existing SQL queries to improve performance on large datasets

02Translating complex business questions into efficient analytical queries for data reports

03Generating database migration scripts or complex joins based on provided schema diagrams