Manage databases

MZPanel manages databases on each server straight from the dashboard. Open a server, go to Databases, and pick an engine — the agent runs every operation natively on the VPS and streams the result back.

Engines supported

Engine	Tier	What you get
MariaDB / MySQL	Free	Create databases & users, dumps, import/export
PostgreSQL	Pro	Status, tuning, expose/unexpose, pgvector
MongoDB	Pro	Database CRUD, export/import, mongo-express admin

The Databases page is adaptive: it detects which engines are installed and shows a per-engine drawer with the controls that apply to that engine. Each engine also has its own Settings drawer (the gear icon) for status and configuration.

Create and manage databases & users

From the Databases drawer you can:

• Create a database and a database user, then grant access.
• Manage users — list existing users, create new ones, and set passwords.
• Import / export a database. Exports run a native dump (mysqldump for MariaDB/MySQL) on the box; imports load the file directly into the target database.

Tip

Large database transfers (hundreds of MB) go directly between your browser and the VPS, not through the control plane — so there is no upload size cap and no PHP form timeout. Use the built-in Import / Export for big data rather than the web admin tools.

Caution

Importing a database overwrites the target database’s contents. Make sure you have a backup first.

Admin tools (phpMyAdmin / pgAdmin / mongo-express)

Each server can serve web admin tools through its access domain — a single per-server hostname (box-<slug>.<suffix>) auto-provisioned with a DNS record and a Let’s Encrypt certificate. Different tools live under different paths on that one host.

• phpMyAdmin — open from a MariaDB/MySQL database. MZPanel mints a single-use, time-limited magic-login link, so you land in phpMyAdmin already authenticated.
• pgAdmin — same flow for PostgreSQL.
• mongo-express — open from MongoDB; it is served through the app proxy.

For tighter privacy, MZPanel can tunnel these tools over the agent’s existing WebSocket so the admin app listens on localhost only and the box’s IP is never exposed in the browser. You stay on an mzpanel.com host the whole time.

Note

phpMyAdmin (and the magic-login flow) is available on Free. pgAdmin and mongo-express follow PostgreSQL and MongoDB, which are Pro.

Vector DBs for AI (Pro)

For RAG and other AI workloads, MZPanel supports two vector databases:

• pgvector — enable the vector extension on an existing PostgreSQL instance. This reuses your Postgres server, so there is no extra service to run.
• Qdrant — deploy Qdrant as a managed app for a dedicated vector store.

Both are Pro features. Choose pgvector when you already run PostgreSQL and want vectors alongside relational data; choose Qdrant when you want a purpose-built vector engine.

Remote access

By default, databases are not reachable from the public internet. To connect an external client to a database, see Remote DB access, which uses a tight IP allowlist.