Databases

Four engines, one management UI

MariaDB, MySQL, PostgreSQL, and the in-house Mimir SQL server, each a separate Podman role, co-existing on one host with non-conflicting ports. Create, browse, tune, import, and export, all from the panel.

Mimir SQL MariaDB MySQL PostgreSQL

Bundled admin tools install automatically with the role: Adminer (universal), phpMyAdmin (MariaDB/MySQL), phpPgAdmin (PostgreSQL), and the lightweight Mimir admin.

Day-to-day management

Everything you’d open a SQL client for, in-panel

Create, drop, rename, and browse tables. Manage users and permissions per database with password set/reset. Linked databases enforce a one-DB-per-website invariant, and the delete-website flow can offer to drop the schema.

  • Per-database users & permissions with password reset
  • Live schema size and storage breakdown
  • Process list with kill-process for misbehaving queries
  • Optimize / analyze all tables in one click

Performance & hygiene

Spot problems before they page you

Real-time stats

Queries per second, total connections, and slow-query-log truncation, without leaving the panel.

Anomaly detection

Flags schemas missing primary keys or indexes so you can fix them before they bite.

Size ranking

See which schemas are eating the most disk across the host, sorted at a glance.

Import / export

Move big dumps without timing out

Both import and export show a live, pv-driven progress bar with size hints, so there are no silent hangs on multi-gigabyte dumps.

SQL import

Live pv progress with size hints from INFORMATION_SCHEMA / pg_database_size. No timeouts on huge dumps.

SQL export

Same progress UI, piped through pigz compression with a gzip fallback.

Fails loudly, not silently

A dump that goes wrong half way through reports the error rather than leaving you with a truncated file that looks fine.

Run all four engines side by side.

Mimir, MariaDB, MySQL, and PostgreSQL: per-database users, live stats, and progress-tracked import/export.