database

database v0.1

A fully serverless SQLite database editor built with vanilla HTML, CSS, and JavaScript. No dependencies, no build step — create and manage databases directly in the browser.

Features

Schema Designer Create tables, add columns with types (INTEGER, TEXT, REAL, BLOB, etc.), set primary keys, NOT NULL constraints, and defaults.
Relationships Define foreign keys between tables with a visual editor. Enforce referential integrity.
Data Editor View and edit data in an inline editable grid. Add and delete rows with one click.
SQL Console Run arbitrary SQL queries with full results displayed in a table. Multi-statement support.
Standalone SQL Console A dedicated SQL Console page for running queries directly — no schema designer, just SQL.
Import / Export Open existing .sqlite files via file picker or drag-and-drop. Export as .sqlite or SQL dump.
Auto-Save Work is automatically saved to localStorage and restored on page reload.
Serverless Everything runs in your browser via sql.js (SQLite compiled to WebAssembly). Nothing is sent to any server.

Quick Start

Creating a Database

Click New in the toolbar to create an empty database, or Import to open an existing .sqlite file.

Adding Tables

Click Table in the toolbar, enter a name, and click Create. Then use the Schema tab to add columns and configure types, primary keys, and foreign keys.

Editing Data

Switch to the Data tab to view table contents. Click any cell to edit its value inline. Use the + Add Row button to insert new rows.

Running SQL

Switch to the SQL tab, type your query, and click Run or press Ctrl+Enter. SELECT queries display results; DDL/DML statements modify the database.

Exporting

Click the export button (blue, right side of toolbar) and choose Export .sqlite for a standard SQLite database file, or Export SQL dump for a portable SQL text file.

Tip: The exported .sqlite file is a standard SQLite database. Open it with DB Browser, the SQLite CLI, Python's sqlite3 module, or any SQLite-compatible tool.

Keyboard Shortcuts

Ctrl+Enter Run SQL

Enter Confirm modal

Escape Close modal / dropdown

Technical Details

Engine: sql.js v1.11 (SQLite via WebAssembly)
Framework: Vanilla JavaScript (ES5-compatible), no dependencies
Theme: Free Open Tools ecosystem dark/light scheme with toggle
Storage: In-memory database with localStorage auto-save
Import: .sqlite, .db, .sqlite3 files (drag-and-drop supported)
Export: .sqlite (binary) or .sql (SQL dump)

Version History

0.1current

Initial release — schema designer, data editor, SQL console
Foreign key relationships with visual editor
Inline cell editing with SQL persistence
Import/export .sqlite files
SQL dump export
Auto-save to localStorage
Free Open Tools ecosystem theme