A lightweight phpMyAdmin and Adminer alternative, in Docker
phpMyAdmin, Adminer and pgAdmin are the usual web tools for looking inside a database. onezDBViewer does the everyday part of that job — browsing tables, running SQL and exporting results — for MySQL, MariaDB and PostgreSQL, from one Docker container, with nothing sent anywhere.
How they compare
| onezDBViewer | phpMyAdmin | Adminer | pgAdmin | |
|---|---|---|---|---|
| Databases | MySQL, MariaDB, PostgreSQL | MySQL, MariaDB | MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle and more | PostgreSQL |
| Built with | Go and React | PHP | PHP, in a single file | Python and JavaScript |
| Price | Free | Free, open source (GPL) | Free, open source (Apache 2.0 or GPL 2) | Free, open source (PostgreSQL Licence) |
| Runs as | One Docker container | A PHP web app; official Docker image | A PHP file; official Docker image | A desktop app or a web server; Docker image |
What onezDBViewer does
- One tool for MySQL, MariaDB and PostgreSQL, with several saved connections. Their passwords are stored encrypted.
- SQL editor in tabs. Run queries, then filter and sort the results. Save the queries you use often.
- Schema browser. Tables, views, procedures, functions, triggers and indexes in one tree, loaded as you open each database.
- Export. Query results to CSV, streamed so large tables don't fill memory, or whole databases as a SQL dump.
- Readonly mode, so a quick look can't change anything by accident.
- Tabs that come back. Your open tabs and the SQL in them are saved as you work.
- No data collection. No telemetry, no analytics, no account.
When another tool is the better choice
- You need SQLite, SQL Server or Oracle: Adminer covers them.
- You run PostgreSQL servers and want server administration in the same tool: pgAdmin is built for that.
- You manage MySQL users, privileges and server settings from the browser: phpMyAdmin has screens for those.
onezDBViewer is in beta and focuses on browsing, querying and exporting data.
Try it in one command
Docker Run
docker run -d -p 9977:9977 \
-v onezdbviewer-data:/root/.onezdbviewer \
--name onezdbviewer \
onezloop/onezdbviewer:latest
Then open localhost:9977 in your browser and add a connection.