sql-queries

# SQL Query Generator ## Purpose Transform natural language requirements into optimized SQL queries across multiple database platforms. This skill helps product managers, analysts, and engineers generate accurate queries without manual syntax work. ## How It Works ### Step 1: Understand Your Database Schema - If you provide a schema file (SQL, documentation, or diagram description), I will read and analyze it - Extract table names, column definitions, data types, and relationships - Identify primary keys, foreign keys, and indexing strategies ### Step 2: Process Your Request - Clarify the exact data you need to retrieve or analyze - Confirm the SQL dialect (BigQuery, PostgreSQL, MySQL, Snowflake, etc.) - Ask for any additional requirements (filters, aggregations, sorting) ### Step 3: Generate Optimized Query - Write efficient SQL that leverages your database structure - Include comments explaining complex logic - Add performance considerations for large datasets - Provide alternative approaches if applicable ### Step 4: Explain and Test - Explain the query logic in plain English - Suggest how to test or validate results - Offer tips for performance optimization - If you want, generate a test script or sample data ## Usage Examples **Example 1: Query from Schema File** ``` Upload your database_schema.sql file and say: "Generate a query to find users who signed up in the last 30 days and had at least 5 active sessions" ``` **Example 2: Query from Diagram Description** ...