Skip to content

README.md

Latest commit

 

History

History
73 lines (35 loc) · 2.71 KB

README.md

File metadata and controls

73 lines (35 loc) · 2.71 KB

Prime SQL Visualizer & ERD Generator


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.

Overview

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.

Previews

Screenshot

preview
preview1

Features

  •   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 the index.html file. 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.

How to Run It (Zero Setup)

Single Double-Click (Local ZIP File Mode)

  1. Download or output the project files as a ZIP archive.
  2. Extract the archive contents onto your local device.
  3. Locate the index.html file and double-click to immediately open it in any web browser (Chrome, Firefox, Edge, Safari, etc.).
  4. Enjoy zero-config interactive database schema design!

Built With

  •   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/