Create and query a Cassandra table
CREATE TABLE users (
id int PRIMARY KEY,
name text,
tags set<text>
);
INSERT INTO users (id, name, tags)
VALUES (1, 'Ada', {'math', 'sql'});
SELECT * FROM users WHERE id = 1;Apache Cassandra is a distributed wide-column database designed for high availability and scalable writes. Its CQL language uses tables and familiar query syntax with partition-key-driven data access.
Use this playground to practise CQL table design, primary keys, inserts, collections, and bounded queries without installing Cassandra or cqlsh.
This page sends your script to a hosted, network-isolated Cassandra 5.0.8 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: Native cqlsh text transcript. 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 Cassandra 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 PRIMARY KEY,
name text,
tags set<text>
);
INSERT INTO users (id, name, tags)
VALUES (1, 'Ada', {'math', 'sql'});
SELECT * FROM users WHERE id = 1;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