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 customers and their card details
Find the total transaction amount by customer
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
customers
CustomerID
(INTEGER)
PK
Segment
(TEXT)
Currency
(TEXT)
gasstations
GasStationID
(INTEGER)
PK
ChainID
(INTEGER)
Country
(TEXT)
Segment
(TEXT)
products
ProductID
(INTEGER)
PK
Description
(TEXT)
transactions_1k
TransactionID
(INTEGER)
PK
Date
(DATE)
Time
(TEXT)
CustomerID
(INTEGER)
CardID
(INTEGER)
GasStationID
(INTEGER)
ProductID
(INTEGER)
Amount
(INTEGER)
Price
(REAL)
yearmonth
CustomerID
(INTEGER)
PK
Date
(TEXT)
PK
Consumption
(REAL)