Free, ready-to-query SQLite databases for learning and practicing SQL. Each is a single .db file — open it in PounceSQL (one click in Settings → Learn SQL), or in any SQLite tool (sqlite3, DB Browser, DBeaverLite, etc.).
Made to help people learn SQL. Free to use, share, and remix. Contributions welcome — see Contributing.
| File | Rows | Great for | Try |
|---|---|---|---|
starwars.db |
61 planets · 87 characters | JOINs, foreign keys | SELECT p.name FROM people p JOIN planet pl ON p.planet_id=pl.id WHERE pl.name='Tatooine'; |
pokemon.db |
800 Pokémon | SELECT · WHERE · aggregates |
SELECT name, attack FROM pokemon WHERE type1='Fire' ORDER BY attack DESC LIMIT 10; |
chinook.db |
11 tables · 3,500 tracks | complex joins, subqueries | SELECT BillingCountry, SUM(Total) FROM Invoice GROUP BY 1 ORDER BY 2 DESC; |
countries.db |
250 countries | GROUP BY, aggregates |
SELECT region, SUM(population) FROM countries GROUP BY region ORDER BY 2 DESC; |
olympics.db |
11,084 medal tallies | joins, aggregates, trend charts | SELECT year, SUM(medals) FROM medal_counts WHERE noc='USA' AND medal='Gold' GROUP BY year; |
comics.db |
23,272 characters | filters, Marvel vs DC | SELECT publisher, COUNT(*) FROM characters WHERE align='Bad' GROUP BY publisher; |
olympics-detailed.db |
39,783 individual medals | every medal with athlete, event & age (larger — 4.7 MB) | SELECT athlete, COUNT(*) c FROM medals WHERE medal='Gold' GROUP BY athlete ORDER BY c DESC LIMIT 10; |
Every dataset keeps the license of its original source. Please credit the sources if you reuse the data.
- Star Wars — from alexisrolland/star-wars-data (built on SWAPI). Inspired by Cockroach Labs and the
starwarsdbR package. - Pokémon — the classic Kaggle Pokémon dataset. Learning ideas from TempeHS, Yi Zheng, and lucvalsal.
- Chinook (music store) — the Chinook sample database. MIT licensed.
- World countries — country facts from mledoze/countries (MIT); population & GDP from the World Bank (CC BY 4.0).
- Olympic medals / athletes — the "120 years of Olympic history" dataset, originally compiled from Sports Reference.
- Marvel & DC characters — FiveThirtyEight's comic-characters data (CC BY 4.0), sourced from the Marvel and DC wikis.
PounceApps is not affiliated with or endorsed by any of these franchises or organizations. These databases are provided for educational use.
The bundled databases (Star Wars, Pokémon, Music store, World countries) install offline with one click. The rest download from this repo on first load. Everything lives in ~/Documents/pouncesql/learn and can be removed or reloaded any time.
Don't have PounceSQL? It's a free, native macOS SQL client — pouncesql.com.
Have an idea, a question about learning SQL, or a dataset to suggest? Start a thread in Discussions — it's the home for sample data & learning.
Got a fun, cleanly-licensed dataset that teaches something? Pull requests welcome.
- Add a small SQLite
.db(aim for < 5 MB; keep tables tidy and column names clear). - Add a row to the table above with a sample query, and a credit line with the source + license.
- Open a PR. All PRs are reviewed before merging.
Please only submit data you have the right to redistribute, and always credit the source.
The packaging and documentation in this repo are released under CC0 (public domain). Individual datasets retain their original licenses — see Credits above.