sql-queries

sql-queries transforms natural language descriptions into optimized SQL queries across multiple database platforms. It helps product managers, analysts, and engineers translate business questions into accurate queries without manual syntax work, and it supports BigQuery, PostgreSQL, MySQL, Snowflake, and SQL Server dialects. It can read database schemas from uploaded SQL files, documentation, or diagram descriptions to ground the queries it generates.

The skill follows a four-step process. First it understands your database schema: if you provide a schema file or diagram description, it reads and analyzes it, extracting table names, column definitions, data types, relationships, primary keys, foreign keys, and indexing strategies. Second it processes your request, clarifying the exact data needed, confirming the SQL dialect, and asking about filters, aggregations, and sorting. Third it generates an optimized query with comments explaining complex logic, performance considerations for large datasets, and alternative approaches where applicable. Fourth it explains the query in plain English, suggests how to test or validate results, offers optimization tips, and can generate a test script or sample data. Its output format delivers a production-ready SQL query, an explanation, performance notes, and an optional test script.

Target users are product managers, analysts, and engineers who need SQL without hand-writing syntax. Key capabilities include multi-dialect support, reading schema files and SQL dumps, query optimization suggestions (indexes, partitioning), explanations for learning and documentation, and creating executable SQL scripts. For best results the skill advises providing schema context, being specific about the data and filters needed, mentioning the SQL dialect, including constraints such as data volume and time ranges, and requesting a particular result format when needed.