Create and query a MySQL table
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL
);
INSERT INTO users (name) VALUES ('Ada'), ('Linus');
SELECT * FROM users ORDER BY id;MySQL is a widely used relational database with a client-server architecture. Its default InnoDB engine supports ACID transactions, foreign keys, and row-level locking.
Use this playground to practise MySQL syntax, AUTO_INCREMENT keys, joins, CTEs, window functions, JSON expressions, and schema design without installing a server.
This page sends your script to a hosted, network-isolated MySQL 8.4.10 runtime. Every Run executes the whole editor contents against a fresh database, then discards its database state and files. It does not run the database in your browser and it never connects to your own database.
Available output: HTML result tables and mysql-client text. The schema panel shows a bounded catalogue captured after successful execution. Large output may be truncated, and package installation, remote network access, persistent storage, and external database connections are not supported.
Build a MySQL script in the editor with syntax highlighting and editor assistance.
Run the complete script against a fresh isolated database sandbox.
Review rows, messages, errors, and execution time in the results panel.
Your draft stays in this browser, and Share creates a separate snapshot link.
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL
);
INSERT INTO users (name) VALUES ('Ada'), ('Linus');
SELECT * FROM users ORDER BY id;The editor uses Monaco, the engine behind VS Code, with language-aware editing tools and familiar keyboard controls.
Write your query in the editor, then click Run (or press Ctrl/Cmd + Enter) to execute it.
Results appear instantly in the output panel below, along with any errors and how long the query took.
Nothing to install and no account to create — queries run in a hosted, isolated database sandbox.
Smart autocomplete and syntax highlighting for your query language
Real-time error underlines, bracket matching, and code folding
Multi-cursor editing plus find & replace (Ctrl/Cmd + F)
One-click formatting to tidy up long queries
Copy to clipboard and download your script
Built on Monaco — the same editor that powers VS Code
Run the whole editor script and see its native results
Output shows returned rows, messages, errors, and execution time
Start from a clean database every run, so experiments never clash
Switch between light and dark themes
Adjust font size and other editor settings
Toggle side-by-side or top/bottom layouts
Enter distraction-free fullscreen mode
Generate a shareable link to your exact query in one click — no login needed
Your work autosaves to your browser, so you can pick up where you left off
Copy your query to the clipboard or download it as a file
Run query: Ctrl/Cmd + Enter
Find & replace: Ctrl/Cmd + F
Open the full shortcut list from the keyboard icon in the toolbar