How to use Schema School

Schema School runs entirely in your browser. There is nothing to install — no Docker, no local Postgres, no client. Create a free account and you are writing real SQL against a live database in under a minute.

1. 1Create a free account on the register page (or sign in with Google). No credit card is required to start.
2. 2Head to /learn and open the first lesson — or jump straight into the Playground to run any query you like against the sandbox.
3. 3Use the section navigation on the left of this page to dig into any feature: lessons, the sandbox, diagrams, the DBA tool, the AI tutor, and more.

Stuck at any point? The floating SQL Tutor button (bottom-right of every page) answers SQL questions even when you are signed out — see the AI Tutor section.

The /learn page is your roadmap. Seven chapters take you from your first SELECT all the way through window functions, CTEs, indexes, and query plans — 37 lessons and 70+ graded exercises in total.

1. 1Go to /learn to see all chapters laid out in order. Each chapter card shows your mastery progress and a difficulty badge (Beginner → Expert).
2. 2Click any unlocked lesson card to open the lesson. You will see four structured sections: Theory (the concept explained plainly), When to use it, When not to use it, and a Real-world example.
3. 3After reading the theory, work through the graded exercises below it. Each exercise shows a prompt and a code editor pre-filled with starter SQL. Write your query, then hit Submit to check it — you get instant feedback and a diff if your result is close but not quite right.
4. 4Solve all exercises in a lesson to unlock the next one. Concept-only lessons (no exercises) have a button at the bottom instead.

Every query you run in lessons and the playground hits a real, live PostgreSQL database — the Sandbox. It’s a shared, read-only database that you can SELECT from freely; writes are blocked so nothing you do can break it for other learners.

The sandbox ships with five realistic datasets across separate PostgreSQL schemas:

• publicE-commerce — Products, customers, orders, order items, and categories.
• financeFinance — Customers, accounts, ~200k transactions, securities, holdings, and trades.
• chatbotChatbot — Users, conversations, ~200k messages, intents, and feedback ratings.
• mapsMaps — Cities, 50k places of interest, 200k reviews, and users.
• healthHealth — Hospitals, providers, patients, 100k visits, 60k prescriptions, and 80k lab results (all synthetic).

The /playground is a free-form SQL editor. No prompts, no grading — just you and the database. Autocomplete suggests table and column names from whichever dataset you’re querying.

1. 1Open the Playground. By default it targets the sandbox (E-commerce schema). A tip bar at the top lists all five available datasets and their schemas.
2. 2Type (or paste) any SELECT statement and press Run (or Ctrl+Enter / ⌘+Enter). Results appear in a table below the editor showing column names, row count, and query duration.
3. 3To query your own Postgres database instead, paste a connection string into the connection field. The string is sent over HTTPS for that request only — it is not saved on this page.
4. 4Stuck on a query? Press next to the Run button. Describe what you want in plain English and the AI tutor will suggest SQL you can paste into the editor.

The /diagrams section contains 48 animated explainers — one concept per diagram, from basic SELECTthrough indexes and query plans. Each diagram shows you what’s happening inside the database using step-by-step animation, with no SQL syntax required to follow along.

1. 1Open the Diagrams page. The left sidebar lists all diagrams grouped by chapter. Use the sidebar to jump to any topic — or just hit Next in the viewer to walk through the full story in order.
2. 2On mobile, tap the menu icon (top-left of the viewer) to open the diagram navigator drawer. Tap any entry to jump to that diagram.
3. 3Each diagram shows an animated stage. When the animation finishes, press Replay to watch it again from the start — useful if you missed a step.
4. 4Press Maximize to expand the diagram into a large fullscreen overlay for a cleaner view on desktop. Press Esc or the close button to exit.

The /dba page is a schema browser and natural-language query tool. Use it to explore the sandbox, or connect your own PostgreSQL or MySQL database (BYO).

1. 1On the left you will see a Connections panel. The Sandbox connection is always available. To add your own database, click + Add connection, give it a label, choose Postgres or MySQL, and paste your connection string. Connections can be saved locally for the session.
2. 2After selecting a connection, the schema tree below the connections panel loads automatically. Expand any schema to reveal its tables and views, then click a table name to view its columns, data types, and a live preview of the first rows.
3. 3To run ad-hoc SQL queries, head to the Playground and paste your connection string there.
4. 4Press the Ask AIbutton (bottom-right) to open the DBA AI panel. Type a question in plain English — for example, “Which customers placed more than 5 orders last month?” — and the AI will generate SQL, run it against your selected connection, and return the results with an explanation.
5. 5

Schema School has AI assistance in three places. All three use the same underlying model and stay focused on SQL — off-topic questions are politely declined.

The /community page is a simple forum where learners ask questions, share tips, and discuss SQL.

1. 1Sign in, then type a title and body for your post in the New post form at the top of the page. Posts are text-only.
2. 2Submit the form. Your post enters a review queue and will appear publicly once an admin approves it. You will see it in My posts while it is pending.
3. 3Click any approved post to open the thread and read replies. To reply, type in the reply box at the bottom — replies go through the same review process before appearing.

All content is reviewed by an admin before it appears publicly. This keeps the forum spam-free. Most posts are approved within a few hours.

Creating an account is free and takes under a minute. No credit card is required to sign up.