BIRD-SQL Incorrect Generator
Home
BIRD Datasets
New Databases
Gas Station Database
Student Club Database
Database Setup
Generate
Results
Analysis
Generate Incorrect SQL Queries
Create Query
Database
Select a database
california_schools
superhero
toxicology
student_club
debit_card_specializing
These are your uploaded SQLite databases.
Query Selection
-- Custom Query --
List all molecules and their toxicity levels
Find molecules containing oxygen atoms
Count molecules by structural classification
Select from existing queries or create your own.
Natural Language Query
Correct SQL Query
Error Strategies
Join Errors
Filtering Errors
Aggregation Errors
Selection Errors
Subquery Errors
Set Operation Errors
Sorting Errors
Syntax Logic Errors
Limit Offset Errors
Select which types of errors to generate.
Min Errors
Max Errors
Note:
Generation can take 10-30 seconds depending on the complexity of the query. The process will:
Get database schema and sample data
Generate incorrect SQL variants using GPT-4o
Validate each incorrect query by executing it against the database
Save results for viewing
Generate Incorrect Queries
Database Schema
atom
atom_id
(TEXT)
PK
molecule_id
(TEXT)
element
(TEXT)
bond
bond_id
(TEXT)
PK
molecule_id
(TEXT)
bond_type
(TEXT)
connected
atom_id
(TEXT)
PK
atom_id2
(TEXT)
PK
bond_id
(TEXT)
molecule
molecule_id
(TEXT)
PK
label
(TEXT)