birdsql/Effi-SQL

Effi-SQL

Update 2026-06-12

We release Effi-SQL, a dataset suite for SQL efficiency optimization.

This collection includes:

• —Effi-SQL Benchmark: a benchmark for evaluating SQL efficiency optimization methods.
• —Diff-SQL Training Dataset: training data used by Diff-SQL, including data for the Patch Generator and Constraint Aligner.

Dataset Fields

Effi-SQL Benchmark

• —id: A unique identifier for each benchmark instance.
• —db: The database name.
• —base_sql: The original slow SQL query.
• —optimized_sql: The human-verified optimized SQL query.
• —base_time: Execution time of the original SQL query.
• —fast_time: Execution time of the optimized SQL query.
• —base_explain_analyze: Query execution plan (QEP) output for the original SQL query.
• —optimized_explain_analyze: Query execution plan (QEP) output for the optimized SQL query.
• —difficulty: The difficulty label of the benchmark instance.

Diff-SQL Training Dataset

• —instance_id: A unique identifier for each training instance.
• —prompt: The model input prompt, including the slow SQL query, relevant database information, and the query execution plan of the slow SQL query.
• —response: The target response, including optimization or refinement reasoning and the target patch.
• —db: The database name of the slow SQL query.
• —base_sql: The original slow SQL query.
• —optimized_sql: The optimized SQL query used as the reference target.

Related Resources

• —Code: L-nshpp/Diff-SQL