Reference
Tables of what each database type supports, every connection field, the buttons in the workspace, limits and file locations.
What each database supports
| SQLite | MySQL / MariaDB | PostgreSQL | MongoDB | LMDB | |
|---|---|---|---|---|---|
| Connect with | File | Server | Server | Server | Folder |
| Left-hand list shows | Tables and views | Tables | Tables in public | Collections | Sub-databases |
| Query tab accepts | SQL | SQL | SQL | JSON command | Key prefix |
| A row is identified by | Row ID | Primary key | Row location | _id | Key |
| Find-rows panel | Yes | Yes | Yes | Yes | Yes |
| Encryption button | Yes | No | No | No | No |
Connection fields
| Field | Used by | Default |
|---|---|---|
| Connection name | All | The file name, or the type and host |
| SQLite file | SQLite | Empty |
| Password (only for encrypted / SQLCipher databases) | SQLite | Empty |
| LMDB directory (or data.mdb) | LMDB | Empty |
| Host | MySQL / MariaDB, PostgreSQL, MongoDB | localhost |
| Port | MySQL / MariaDB, PostgreSQL, MongoDB | 3306, 5432, 27017 |
| Database | MySQL / MariaDB, PostgreSQL, MongoDB | Empty. MongoDB then uses test |
| Username | MySQL / MariaDB, PostgreSQL, MongoDB | Empty |
| Password | MySQL / MariaDB, PostgreSQL, MongoDB | Empty |
| Use SSL / TLS | MySQL / MariaDB, PostgreSQL, MongoDB | Off |
| Ask for the password every time | All except LMDB | Off |
Start screen
| Control | What it does |
|---|---|
| New connection | Opens the connection dialog. |
| A connection in the list | Connects and opens the workspace. |
| Menu button on a connection | Edit, Duplicate, Delete. Delete does not ask for confirmation. |
Workspace: title bar
| Control | What it does |
|---|---|
| Back arrow | Closes the database and returns to the start screen. |
| Refresh button | Reloads the list of tables, collections or sub-databases. |
| Padlock button (SQLite) | Encrypt with a password, or Change or remove password. |
| Backup | Writes a timestamped backup into a folder you choose. |
| Data tab | Browse, find and edit rows. |
| Query tab | Run SQL, a MongoDB command or an LMDB prefix scan. |
Workspace: Data tab
| Control | What it does |
|---|---|
| Funnel button | Opens or closes the find-rows panel. A badge shows the number of active conditions. |
| Previous page, Next page | Move through the rows, 100 at a time. |
| Insert | Opens the Insert into dialog. |
| Export CSV | Saves every row that matches the current search. |
| Refresh button | Reloads the page and the row count. |
| Click on a cell, or the pencil button | Opens the Edit row dialog. |
| Bin button | Deletes the row after a confirmation. |
Workspace: find-rows panel
| Control | What it does |
|---|---|
| Add a condition / Add another condition | Adds a row with a column, a comparison and a value. |
| Cross at the end of a condition | Remove condition. |
| Sort by | The column to sort on. — means no sorting. |
| Arrow next to Sort by | Switches between Smallest first and Largest first. |
| Clear | Removes every condition and the sorting, and reloads the table. |
| Find rows | Runs the search. |
| Show the query this runs | Shows the generated query, with Copy query and Open in Query tab to customize. |
Comparisons: is, is not, contains, starts with, is more than, is less than, is at least, is at most, is empty, is not empty.
Workspace: Query tab
| Control | What it does |
|---|---|
| Query box | Holds the statement, command or prefix. |
| Run (Ctrl+Enter) | Runs it. Reads Running… while it works. |
| Export CSV | Appears when the result has rows. Saves them as CSV. |
Keyboard shortcuts
| Shortcut | Where | What it does |
|---|---|---|
| Ctrl + Enter | Query box | Runs the query |
| Enter | A value box in the find-rows panel | Runs the search |
| Enter | Password prompt | Unlocks |
Limits
| Limit | Value |
|---|---|
| Rows per page on the Data tab | 100 |
| Characters of a value shown in the grid | 200, then … |
| Entries returned by an LMDB prefix scan | 1000 |
| PostgreSQL connection timeout | 10 seconds |
| Bytes of a binary value shown in the grid | 24, then the total size |
How values are shown
| Value | In the grid | In CSV |
|---|---|---|
| No value | NULL, grey italics | Empty |
| Line break inside text | ⏎ | Kept, inside double quotes |
| Binary data | 0x and hexadecimal digits | 0x and hexadecimal digits |
| MongoDB object or list | JSON text | JSON text |
| LMDB key or value | Text when it is readable text, otherwise 0x… | The same |
Backup formats
| Database | Format | Name |
|---|---|---|
| SQLite | Database file | <file>_backup_<date>_<time>.db |
| MySQL / MariaDB | SQL file | <database>_backup_<date>_<time>.sql |
| PostgreSQL | SQL file | <database>_backup_<date>_<time>.sql |
| MongoDB | Folder of <collection>.jsonl files | <database>_backup_<date>_<time> |
| LMDB | Folder | <name>_backup_<date>_<time> |
The date and time are written as YYYYMMDD_HHMMSS.
File locations
| What | Where (Linux) |
|---|---|
| Saved connections | ~/.local/share/com.dhivalabs.database_manager/connections.json |
The connections file is plain JSON and includes any saved passwords as plain text. Protect it as you would a password file. Deleting it removes every saved connection and nothing else.
The app follows your system's light or dark theme. It has no settings screen.