SQL-queries

Describe the data you need to retrieve or analyze in natural language, including specific filters, aggregations, and sorting requirements
Provide your database structure via a schema file (SQL, documentation) or a text description of your tables, columns, and relationships

Natural language descriptions of data retrieval or analysis needs
Database schema files, SQL dumps, or text descriptions of database structure
SQL dialect specification (e.g., BigQuery, PostgreSQL, MySQL, Snowflake, SQL Server)
Additional requirements such as filters, aggregations, sorting, data volume, and time ranges

SQL queries with comments explaining logic
Plain English explanations of query logic
Performance notes and optimization considerations based on provided schema context
Test scripts or sample data scripts (if requested)

Accuracy and completeness of generated queries depend entirely on the schema context provided by the user
Cannot directly read diagram image files unless provided as text descriptions
Does not execute queries against a live database
Generated scripts must be independently reviewed and validated by the user before execution
True query optimization cannot be verified without actual database statistics or execution plans
Verify the target SQL dialect is explicitly specified before generating a query
Confirm that the provided schema context includes the relevant table names, column definitions, data types, and relationships needed for the request
Ensure the output query includes comments explaining complex logic

AI 搜索