AtheraStudio Db Local SQLite · MySQL · PostgreSQL

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.

Runs in any current browser on Windows, macOS and Linux · Download: ZIP, 7.3 MB

AtheraStudio Db Local showing the orders table of a sample shop database: table list on the left, rows with sorting, filters and pagination on the right

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, .db

Open the database and edit it. In Chrome and Edge, save changes back to the same file with Ctrl+S.

.sql, .sql.gz

Import dumps from phpMyAdmin, mysqldump, SQLite or pg_dump.

.csv

Import data into a new or existing table.

.atbde

Open 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.
SQL editor in AtheraStudio Db Local with a JOIN and GROUP BY query and its results: orders and revenue per city

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.

FormatA-TBDE (.atbde)
EncryptionAES-256-GCM
Key from passwordPBKDF2-SHA256
Also opensbackups from AtheraStudio Database

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

  1. Unzip the file anywhere on your computer.
  2. Open index.html in your browser.
  3. Optionally upload the folder to your own web server (HTTPS) to install it as an app and use it offline.

SHA-256: 1efcb344382ca7be77871df1cac27930afcbcbc2668215ed31196270031100cf