Documentation

Database connections

Connect to MySQL, MariaDB, or PostgreSQL through an SSH tunnel, with credentials stored in the encrypted vault.

Moorix can tunnel database connections through an SSH profile. Each database connection rides the SSH tunnelof its profile, so you can reach a database that only listens on the server's localhost — no need to expose the port to the internet. Credentials are stored in the encrypted vault, and the SSH half is inherited from the profile.

MySQL, MariaDB, and PostgreSQL engines
Connections ride the profile's SSH tunnel
Database credentials stored in the encrypted vault
Add multiple databases per SSH profile

Add a database connection

1
Open an SSH profile (create a new one, or edit an existing profile) and switch to the DATABASES tab.
2
Click + Add database connection. Until you add one, the tab shows “No database connections yet.”
3
Fill in the connection fields described below.
4
Click Add to save the database to the profile. Repeat to add more, then click Save on the profile to persist everything.

Name	A label for this connection, e.g. `app-prod (root)`.
Engine	MySQL, MariaDB, or PostgreSQL.
Host (from server)	The database host as seen from the server — usually `127.0.0.1`, since the connection rides the SSH tunnel.
Port	The database port — `3306` for MySQL / MariaDB, `5432` for PostgreSQL.
DB user	The database username, e.g. root.
DB password	The database password — stored in the encrypted vault.
Default database (optional)	A database (schema) to select automatically on connect.

Because the connection rides the SSH tunnel, the database only needs to be reachable from the server itself (for example bound to 127.0.0.1). You keep it off the public internet while still connecting from your machine.

New to profiles? Start with Remote access to create the SSH profile first, then come back to add databases to it.