Introduction
Introduction
DBNova is a self-hosted MySQL manager: a faster, more trustworthy alternative to phpMyAdmin. It manages one MySQL server running on the same machine or VPS, and it is built for everyday browsing as well as importing and exporting production-sized databases (10 GB and more) without running out of memory.
You sign in with a MySQL account, and that account's grants decide what you can do. DBNova has no user accounts or passwords of its own.
#Why DBNova?
phpMyAdmin has served the PHP world for decades, but it struggles with the things people actually need on a modern VPS:
- Big imports. A 2 GB dump usually means raising
upload_max_filesize, hitting timeouts and starting again. DBNova uploads in resumable chunks, checks the file before anything reaches MySQL, and imports it in a background worker with flat memory. - Big tables. Paging through 10 million rows with
OFFSETgets slower on every page. DBNova uses keyset paging, so the last page is as fast as the first (3–8 ms). - Trust. Every schema change shows the generated SQL first, destructive actions need a typed confirmation, and an audit log records who did what (never the row values).
#Features at a glance
| Area | What you get |
|---|---|
| Databases | List, create, rename and drop, with sizes, table counts and collations |
| Table browser | Keyset paging, a virtualized grid, NULL vs empty string, inline edit / insert / delete |
| Schema | Create and alter tables, columns, indexes and foreign keys, with a SQL preview |
| SQL editor | CodeMirror with schema autocomplete, multi-statement runs, cancel, history, saved queries |
| Imports | .sql, .sql.gz, .zip; chunked, resumable, queued, with honest progress |
| Exports | SQL dumps via mysqldump and CSV (a table or a query result), in background jobs |
| Monitoring | Live process list, server variables and status, dashboard charts, table maintenance |
| Safety | Read-only mode, typed confirmations, rate limits, audit log |
#Measured on a laptop
| Operation | Result |
|---|---|
Import 2 GB .sql (20.1M rows) |
117 s, worker memory flat (+6 MB) |
Export 10M rows / 3.7 GB of SQL to .sql.gz |
26 s, worker memory flat (+4 MB) |
Export a 10M-row table to .csv |
23 s, worker memory flat (+2 MB) |
| Browse a 10M-row table, any page | 3–8 ms per page |
| Scroll a 120-column grid | 60 fps |
Measured on an Apple M2 (8 cores, 16 GB) with MySQL 8.0.39.
#Tech stack
Laravel 13 · Inertia v3 · Vue 3 · TypeScript · Tailwind CSS 4 · shadcn-vue · Pest.
- Managed server: raw PDO for interactive work, and the
mysql/mysqldumpCLI for bulk work. Laravel's DB layer is never pointed at your MySQL server. - DBNova's own data: SQLite holds the app's data, queue and cache.
Ready? Continue with the requirements.