A Serverless, Offline-Capable SQL Live Previewer & Entity-Relationship Diagram (ERD) Generator. No servers, no complex installations, and no internet dependencies. Just download, click, and design.
Prime SQL Visualizer is a client-side database playground designed to make SQL practice, database schema design, and query testing frictionless. Powered by PyScript and SQLite WebAssembly, it executes real SQL commands instantly inside your browser.
With the integrated Interactive ERD Generator, you can visually model databases, create tables with a clean GUI, establish relationships, and automatically export your visual model as ready-to-run DDL SQL statements.
-
100% Serverless Execution: No backends or network constraints. Powered entirely inside your browser sandbox by WebAssembly and PyScript.
-
Fully Offline Capable: Designed to run seamlessly directly from the local file system (
file://protocol) by double-clicking theindex.htmlfile. Handles storage limitations gracefully. -
Monaco Code Editor: Professional query editing with syntax highlighting, automatic theme toggles (Dark/Light mode sync), and bracket matching behavior.
-
Live ERD Canvas: Drag-and-drop layout engine designed with modern aesthetics. Synchronously connects visual relationships to underlying export scripts.
-
Dual Mode Schema Synchronization: Generate visual nodes directly from SQL schemas or translate visual node configurations into standard SQLite syntax scripts.
- Download or output the project files as a ZIP archive.
- Extract the archive contents onto your local device.
- Locate the
index.htmlfile and double-click to immediately open it in any web browser (Chrome, Firefox, Edge, Safari, etc.). - Enjoy zero-config interactive database schema design!
- Layout Engine: Tailwind CSS
- Sandbox: PyScript (incorporating Python 3 WebAssembly builds with robust sqlite3 bindings)
- Editor: Monaco Editor (with custom client-side Worker configurations)
- Icons: Lucide Icons & Boxicons
Need live preview ? - 🔵 https://axxodeveloper.github.io/Prime.SQL/