Learn SQL on data you'll actually enjoy.

1. Open Settings → Learn SQL.
2. Click Load next to any database — it installs (downloading first if needed) and appears in your tree.
3. Expand it to see the tables — or just ask the AI: "what's in this database?"
4. Done exploring? Click Remove to hide it; reload it any time.

Prefer to do it by hand? Download a .db from the Databases tab, then use Add → SQLite → Browse… in the tree. Tip: right-click any table to preview rows, count them, or generate a starter query.

Prefer the big models? A few dollars of OpenAI or Anthropic credits go a long way.

1. 1

   Your first query

   pokemon.db

   SELECT chooses columns, WHERE filters rows, ORDER BY sorts, LIMIT caps the count. Find the ten hardest-hitting Fire types:

   SELECT name, type1, attack
   FROM pokemon
   WHERE type1 = 'Fire'
   ORDER BY attack DESC
   LIMIT 10;

   Try next: change 'Fire' to 'Water', or sort by speed.

2. 2

   Count & group

   pokemon.db

   Aggregate functions summarise many rows. GROUP BY makes one row per group — here, per type — with a count and an average:

   SELECT type1,
          COUNT(*)            AS count,
          ROUND(AVG(total), 0) AS avg_power
   FROM pokemon
   GROUP BY type1
   ORDER BY count DESC;

   Try next: add HAVING COUNT(*) > 40 to keep only the common types.

3. 3

   Join two tables

   starwars.db

   Real data lives in linked tables. A JOIN follows the foreign key — each character's planet_id points at a planet:

   SELECT people.name, planet.name AS homeworld
   FROM people
   JOIN planet ON people.planet_id = planet.id
   WHERE planet.name = 'Tatooine';

   Try next: swap in 'Naboo', or add people.height and sort by it.

4. 4

   Let the AI write it

   any database · AI

   Don't know the syntax yet? Type the question in the AI Assistant and it writes engine-correct SQL you can read, tweak, and run with Use in editor:

   Ask: “Which homeworld has produced the most characters?”

   Read the JOIN + GROUP BY it generates — that's lesson 2 and 3 combined. Then ask it "explain that query."

5. 5

   See it as a chart

   any database · AI

   Numbers are easier to grasp as pictures. Ask for a chart and PounceSQL renders it inline — then export it as PNG:

   Ask: “Chart the average attack by Pokémon type.”

   Also try: "give me the KPIs for this database" for a dashboard of headline numbers.

6. 6

   Map the whole schema

   any database · AI

   New database? Get the lay of the land instantly — the AI draws an entity-relationship diagram of the tables and how they connect:

   Ask: “Diagram the relationships in this database.”

   Now you can see which columns to JOIN on before you write a line of SQL.