Databases in your browser – no server, no installation
Open a SQLite file or a MySQL or PostgreSQL dump and start browsing, editing and exporting. Everything happens on your computer – your data is never uploaded anywhere.
Privacy first
The database engine runs directly in your browser. Your files never reach a server.
Nothing is uploaded
Files are opened and processed locally. There is no account and no sign-in. In the online version, the browser itself blocks connections to any other server.
Runs straight from disk
Unzip the download and open index.html. Nothing to install, no administrator rights needed.
Works offline
Install the online version like a regular app. After the first visit it works without a connection and updates itself.
Open what you need
Just drag a file into the window.
.sqlite, .dbOpen the database and edit it. In Chrome and Edge, save changes back to the same file with Ctrl+S.
.sql, .sql.gzImport dumps from phpMyAdmin, mysqldump, SQLite or pg_dump.
.csvImport data into a new or existing table.
.atbdeOpen an encrypted backup with its password.
Full data editing
Everything you need for everyday work with a database file.
- Large tables. Browse with sorting, search and filters, smoothly even with tens of thousands of rows.
- Editing. Edit cells with a double-click, use the row form, duplicate and delete rows, preview binary data.
- Structure. Add, rename and drop columns; create and drop indexes; view foreign keys and triggers. A safe table-rebuild template covers changes SQLite can't make directly.
- SQL editor. Table and column suggestions, query history and query plans (EXPLAIN QUERY PLAN).
- Three SQL dialects. SQLite, MySQL/MariaDB and PostgreSQL (beta).
- Maintenance. Integrity and foreign-key checks, VACUUM, ANALYZE, PRAGMA optimize and REINDEX.
Export and encryption
Save your database as .sqlite or .sql, export tables to CSV, JSON or INSERT statements, or create an encrypted .atbde copy.
Encryption happens entirely in your browser – your password never leaves it.
Requirements
Browser
A current version of Chrome, Edge, Firefox or Safari (16.4 or newer).
Saving to the same file
Ctrl+S saves straight back to the opened file in Chrome and Edge when you use the online version. Other browsers, and the app opened from disk, save by downloading a new file.
Database size
The database is kept in browser memory, which limits practical size to a few hundred megabytes.
FAQ
Is my data sent to the internet?
No. All operations run locally in your browser.
Do I need to install anything?
No. Open the online version, or download the ZIP and open index.html. The online version can be installed like an app, works offline and picks up new versions automatically.
Can I open a database dump from my hosting?
Yes – .sql dumps from phpMyAdmin and mysqldump, and encrypted .atbde backups from AtheraStudio Database. MySQL dumps are converted to SQLite, so stored procedures and some MySQL-specific features are skipped.
Is PostgreSQL fully supported?
PostgreSQL support is in beta. Tables and data from pg_dump are imported; functions, custom types and PL/pgSQL triggers are skipped.
Download AtheraStudio Db Local
Version 2.0.2 · ZIP · 7.3 MB · or use it online, nothing to download
- Unzip the file anywhere on your computer.
- Open
index.htmlin your browser. - Optionally upload the folder to your own web server (HTTPS) to install it as an app and use it offline.
SHA-256: 1efcb344382ca7be77871df1cac27930afcbcbc2668215ed31196270031100cf