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 --
Find all Marvel superheroes
List all superheroes with flight powers
Count superheroes by alignment (good, bad, neutral)
Find superheroes with both super strength and super speed
Find the publisher with the most superheroes
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
alignment
id
(INTEGER)
PK
alignment
(TEXT)
attribute
id
(INTEGER)
PK
attribute_name
(TEXT)
colour
id
(INTEGER)
PK
colour
(TEXT)
gender
id
(INTEGER)
PK
gender
(TEXT)
publisher
id
(INTEGER)
PK
publisher_name
(TEXT)
race
id
(INTEGER)
PK
race
(TEXT)
superhero
id
(INTEGER)
PK
superhero_name
(TEXT)
full_name
(TEXT)
gender_id
(INTEGER)
eye_colour_id
(INTEGER)
hair_colour_id
(INTEGER)
skin_colour_id
(INTEGER)
race_id
(INTEGER)
publisher_id
(INTEGER)
alignment_id
(INTEGER)
height_cm
(INTEGER)
weight_kg
(INTEGER)
hero_attribute
hero_id
(INTEGER)
attribute_id
(INTEGER)
attribute_value
(INTEGER)
superpower
id
(INTEGER)
PK
power_name
(TEXT)
hero_power
hero_id
(INTEGER)
power_id
(INTEGER)