Database Manager
Database Manager is a desktop app for looking inside databases and changing what is in them. One window works with five kinds of database: SQLite, MySQL / MariaDB, PostgreSQL, MongoDB and LMDB.
Who it is for
- Developers and testers who need to check or fix a few rows without writing a script.
- People who understand tables but not SQL: you can find rows by picking a column, a condition and a value from lists.
- Anyone learning SQL: the app shows the query behind each search and lets you open it for editing.
What it does
- Saves connections. Keep a list of databases you use and open one with a click.
- Browses data. A grid shows 100 rows per page, with the total row count and a list of tables you can filter.
- Finds rows without SQL. Build a search such as "where city is Chennai and age is more than 60, sort by name" from drop-down lists.
- Edits rows. Click a row to change its values, insert new rows, delete rows after a confirmation.
- Runs queries. Write SQL for SQLite, MySQL and PostgreSQL, a JSON command for MongoDB, or a key-prefix scan for LMDB.
- Exports CSV. Save a whole table, a filtered search or a query result as a
.csvfile. - Backs up. One button writes a timestamped copy of the database to a folder you choose.
- Opens encrypted SQLite files. SQLCipher is built in, so password-protected SQLite databases open with their password. You can also add, change or remove that password.
Supported databases
| Database | You connect with | Query tab accepts | Backup is |
|---|---|---|---|
| SQLite | A database file | SQL | A copy of the file (.db) |
| MySQL / MariaDB | Host, port, user, password | SQL | A SQL file (.sql) |
| PostgreSQL | Host, port, user, password | SQL | A SQL file (.sql) |
| MongoDB | Host, port, user, password | A JSON command | A folder of .jsonl files |
| LMDB | A folder | A key prefix | A compacted copy of the folder |
Platforms
Version 1.0.0 is published for Linux on 64-bit Intel/AMD PCs, as a .deb package for Debian and Ubuntu.
Before you edit real data
Database Manager changes data directly and immediately. There is no undo. Read Edit data safely before you connect it to a database that matters, and take a backup first.