SQL Online Editor & Playground

Your private SQL sandbox. Your queries stay in your browser and never leave your device. Learn, test, prototype!

SQL Editor

-- Create a sample table
CREATE TABLE IF NOT EXISTS products (
    id INTEGER PRIMARY KEY,
    name TEXT NOT NULL,
    price REAL,
    quantity INTEGER
);

-- Insert some data
INSERT INTO products (name, price, quantity) VALUES
    ('Laptop', 999.99, 10),
    ('Mouse', 29.99, 50),
    ('Keyboard', 79.99, 30),
    ('Monitor', 299.99, 15),
    ('Headphones', 149.99, 25);

-- Query the data
SELECT * FROM products;

-- Aggregate query
SELECT
    COUNT(*) as total_products,
    SUM(price * quantity) as inventory_value,
    AVG(price) as average_price
FROM products;

Output:

Output will appear here...

Share securely - Share code using time-sensitive links and optional password protection
AI explanations - An AI assistant that explains how the code works, making it easier to learn and understand
AI code review - An AI code review assistant that reviews your code for bugs, readability, and potential improvements

About SQL

SQL (Structured Query Language) is the standard language for managing and manipulating relational databases. This editor uses SQLite, a lightweight, serverless database engine that runs entirely in your browser.

Why SQL?

Universal - Works with all relational databases
Declarative - Describe what you want, not how to get it
Powerful - Complex queries in simple statements
Essential - Required skill for developers and data analysts

Common Use Cases

Data Analysis and Reporting
Database Design and Modeling
Backend Development
Data Migration
Business Intelligence

Quick Start Example

Here’s a simple SQL session to get you started:

-- Create a table
CREATE TABLE users (
    id INTEGER PRIMARY KEY,
    name TEXT NOT NULL,
    email TEXT UNIQUE,
    age INTEGER
);

-- Insert data
INSERT INTO users (name, email, age) VALUES
    ('Alice', '[email protected]', 30),
    ('Bob', '[email protected]', 25),
    ('Charlie', '[email protected]', 35);

-- Query data
SELECT * FROM users WHERE age > 25;

SQL Features

SELECT - Retrieve data from tables
INSERT - Add new records
UPDATE - Modify existing records
DELETE - Remove records
JOIN - Combine data from multiple tables
GROUP BY - Aggregate data
ORDER BY - Sort results

SQLite Specifics

This editor uses SQLite which supports:

Standard SQL syntax
Common data types (INTEGER, TEXT, REAL, BLOB)
Indexes and constraints
Transactions
Views and triggers

Learning Resources

SQL Language Reference (SQLite)