Interactive

API Playground

Build a query with the controls, watch the URL and the real SQL update, then run it against live sample data. New here? Open the Tutorial tab on the right.

Query Builder

Select a table first
Generated API URL
Build your query above

Load a challenge

Response

👈 Build and execute a query to see results

What this query does

A plain-English, line-by-line breakdown of the exact SQL the API ran — SQL is deterministic, so each clause always means the same thing.

Run a query, then come back here to see it explained clause by clause.

cURL

curl "https://learnsql.cpetoday.com/api/mssql/northwind/Customers?limit=10"

JavaScript (Fetch)

fetch('https://learnsql.cpetoday.com/api/mssql/northwind/Customers?limit=10')
  .then(response => response.json())
  .then(data => console.log(data));

Python (Requests)

import requests

response = requests.get('https://learnsql.cpetoday.com/api/mssql/northwind/Customers?limit=10')
data = response.json()

How to use this playground

Getting started

  1. Pick a database engine (SQL Server or MySQL) and a database
  2. Select a table from the dropdown (e.g. “Customers”)
  3. Choose specific fields or leave empty for all fields
  4. Set pagination (page number and limit)
  5. Optionally add sorting
  6. Click “Execute Query” to see results — and the real SQL that ran

Tip: the built-in Beginner/Intermediate/Advanced challenges use the MySQL acme dataset and switch to it automatically.

Learning features

  • SQL visibility: see the actual SQL query being executed
  • Code examples: view how to call the API in different languages
  • Challenges: try the beginner, intermediate, and advanced challenges
  • Metrics: see response times and record counts

Try these

  • Get the first 5 customers
  • Sort products by price (highest first)
  • Select only specific fields like FirstName, LastName, Email
  • Navigate through pages of data