Online SQL Compiler

The Most Powerful Browser-Based SQL Compiler

Unlike typical online SQL tools, our SQL compiler runs full PostgreSQL directly in your browser via WebAssembly. Your data is persisted locally in IndexedDB: close the tab, come back later, your tables are still there. With 18+ PostgreSQL extensions including pgvector for AI, pg_trgm for fuzzy search, and uuid-ossp for UUIDs. No server, no signup, complete privacy.

How to Use This SQL Compiler

1. Choose your engine: PostgreSQL (persistent) or SQLite (in-memory) via Templates
2. Write SQL queries in the Monaco editor with syntax highlighting
3. Press Ctrl+Enter for instant execution
4. Explore tables in Database Explorer with pagination and row counts
5. Export your database as SQL dump, or import existing dumps

Features

SQL Query Examples

-- Select all artists from the database
SELECT * FROM artists LIMIT 10;

-- Join albums with artists
SELECT
    albums.Title AS Album,
    artists.Name AS Artist
FROM albums
JOIN artists ON albums.ArtistId = artists.ArtistId
LIMIT 10;

-- Count tracks per genre
SELECT
    genres.Name AS Genre,
    COUNT(*) AS TrackCount
FROM tracks
JOIN genres ON tracks.GenreId = genres.GenreId
GROUP BY genres.Name
ORDER BY TrackCount DESC;

Sample Databases Included

Why This SQL Compiler Is Different

Most online SQL tools are basic. Ours runs real PostgreSQL:

• Persistent database: Your tables survive page refresh (IndexedDB)
• Real PostgreSQL syntax: JSON operators, window functions, CTEs, arrays
• pgvector for AI: Vector similarity search for embeddings
• Full-text search: pg_trgm, unaccent, fuzzystrmatch
• Export/Import: pg_dump your database, import SQL dumps
• No rate limits: Run unlimited queries, it's all local