sql-queries

原文涵盖的主题

• SQL Query Generator
• Purpose
• How It Works
• Step 1: Understand Your Database Schema
• Step 2: Process Your Request
• Step 3: Generate Optimized Query
• Step 4: Explain and Test
• Usage Examples

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. 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 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) Write efficient SQL that leverages your database structure Include comments explaining complex logic Add performance considerations for large datasets Provide alternative approaches if applicable 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 Example 1: Query from Schema File Example 2: Query from Diagram Description Example 3: Complex Analysis Query Multi-Dialect Support: Works with BigQuery, PostgreSQL, MySQL, Snowflake, SQL

这里只展示节选，请以完整原文和当前要求为准。