SQL Playground
Query CTF data using SQL (powered by DuckDB WASM)
Schema
challenges
| id | TEXT |
| name | TEXT |
| category | TEXT |
| difficulty | TEXT |
| visible | INTEGER |
questions
| id | TEXT |
| challenge_id | TEXT |
| name | TEXT |
| description | TEXT |
| flag_mask | TEXT |
| points | INTEGER |
| created_at | TEXT |
submissions (correct only)
| id | TEXT |
| question_id | TEXT |
| user_id | TEXT |
| team_id | TEXT |
| user_name | TEXT |
| is_correct | INTEGER |
| created_at | TEXT |
users
| id | TEXT |
| name | TEXT |
| team_id | TEXT |
| created_at | TEXT |
teams
| id | TEXT |
| name | TEXT |
| description | TEXT |
| owner_id | TEXT |
| created_at | TEXT |
hints (content excluded)
| id | TEXT |
| question_id | TEXT |
| order | INTEGER |
| cost | INTEGER |
| created_at | TEXT |
hint_unlocks
| id | TEXT |
| hint_id | TEXT |
| user_id | TEXT |
| team_id | TEXT |
| created_at | TEXT |
competitions
| id | INTEGER |
| name | TEXT |
| description | TEXT |
| status | TEXT |
| start_at | TEXT |
| end_at | TEXT |
| registration_start | TEXT |
| registration_end | TEXT |
| scoreboard_frozen | INTEGER |
| scoreboard_blackout | INTEGER |
| created_at | TEXT |
competition_challenges
| competition_id | INTEGER |
| challenge_id | TEXT |
competition_teams
| competition_id | INTEGER |
| team_id | TEXT |
| joined_at | TEXT |
score_history
| id | TEXT |
| user_id | TEXT |
| team_id | TEXT |
| score | INTEGER |
| solve_count | INTEGER |
| recorded_at | TEXT |
Examples
âšī¸
Challenge Data Available: This challenge provides data in a table named
dataset.
Use SELECT * FROM dataset to explore.
Ctrl+Enter Run all
âĸ
Ctrl+Shift+Enter Run current statement
âĸ
Ctrl+Shift+F Format
Results will appear here...