TL;DR
- Coolify deploys MySQL, PostgreSQL, MariaDB, MongoDB, and Redis in one click — but provides no built-in GUI for browsing or editing your data.
- The dashboard shows connection credentials and container status, but you cannot run queries, view tables, or export data from within Coolify.
- You can deploy Adminer or phpMyAdmin as a Coolify service, but that means another container to maintain, secure, and keep updated.
- DBEverywhere connects to your Coolify databases from any browser — no extra containers, no desktop clients, no SSH required.
- Free tier: 5 sessions/month, 20-minute timeout. Paid: $5/mo for unlimited sessions, saved connections, and SSH tunnel support.
Table of Contents
- The Coolify database management gap
- What Coolify gives you out of the box
- Method 1: Deploy Adminer as a Coolify service
- Method 2: CLI tools over SSH
- Method 3: Desktop client with SSH tunnel
- Method 4: Browser-based GUI with DBEverywhere
- Comparison: all four approaches
- Step-by-step: Connecting DBEverywhere to a Coolify database
- FAQ
Coolify Database Management: How to Browse Your Data After Deployment
Coolify has grown into one of the most popular open-source, self-hosted PaaS platforms. Since its v4 rewrite, the GitHub repository has crossed 35,000 stars, and Coolify Cloud (the hosted version) serves thousands of developers who want Heroku-like simplicity on their own infrastructure. According to its documentation, Coolify supports one-click deployment of MySQL, PostgreSQL, MariaDB, MongoDB, Redis, DragonFly, KeyDB, and ClickHouse — an impressive list for a self-hosted tool.
But there is a recurring question in the Coolify Discord server, GitHub discussions, and community forums: how do I actually look at the data inside my Coolify database? Coolify makes deployment effortless. What it does not provide is a way to browse tables, run ad hoc queries, edit rows, or export data after that database is running.
This gap is not a bug or oversight. Coolify is a deployment and management platform — it handles provisioning, networking, SSL, and backups. Database administration tools like phpMyAdmin, Adminer, pgAdmin, or DBeaver are a different category of software. But for developers who just deployed a PostgreSQL instance for their SaaS or a MySQL database for their WordPress site, the next immediate question is always about coolify database management: how do I see what is in there?
This article covers four ways to browse and manage data in your Coolify-deployed databases, from self-hosted GUI tools to external browser-based options.
What Coolify gives you out of the box
Before diving into solutions, it helps to understand exactly what Coolify provides for database management.
Coolify's dashboard shows: - Container status (running, stopped, restarting) - Connection credentials (host, port, username, password, database name) - Resource usage metrics (CPU, memory, disk) - Backup configuration (scheduled backups for PostgreSQL and MySQL, stored on S3 or locally) - Logs from the database container
Coolify's dashboard does not include: - A query editor or SQL console - A table browser or row viewer - Data import or export tools - User and permission management for the database engine - Schema visualization or structure editing
Coolify's backup feature is genuinely useful — automated pg_dump or mysqldump on a schedule, with S3 upload support. But backups are a different workflow from the day-to-day tasks of checking data, debugging issues, and verifying that an application wrote the correct records. For those tasks, you need a database GUI.
Coolify's v4 architecture runs databases as Docker containers on your server, connected to a Docker network that Coolify manages. By default, database ports are not exposed to the public internet — they are only accessible from other containers on the same Coolify network or from the host machine itself. This is secure by design, but it means connecting an external tool requires additional configuration.
Method 1: Deploy Adminer as a Coolify service
Coolify lets you deploy any Docker image as a service. Adminer is a single-file PHP database management tool that supports MySQL, PostgreSQL, SQLite, MS SQL, and Oracle — making it a natural fit for Coolify's multi-database environment.
How to set it up:
- In Coolify, click New Resource and select Docker Image.
- Enter
adminer:latestas the image. - Set the internal port to 8080 (Adminer's default).
- Assign a domain (e.g.,
adminer.yourdomain.com) and enable SSL. - Deploy the service.
Once running, Adminer is accessible at your chosen domain. Connect to your Coolify database using the internal Docker hostname — something like your-database-container:3306 for MySQL or your-postgres-container:5432 for PostgreSQL.
What works: - Browser-based — accessible from any device - Supports all database engines Coolify can deploy - Internal Docker network access — no port exposure needed - Lightweight — Adminer uses roughly 30-50 MB of RAM compared to pgAdmin's 256+ MB
What does not work:
You are now maintaining another service. The Adminer container needs updates. Security vulnerabilities in Adminer or its PHP runtime require patching. Coolify makes deploying it easy, but keeping it healthy over months and years is on you.
Authentication is the database credentials themselves. Adminer does not have its own user management layer. Anyone who can reach the URL and knows the database password can connect. You need to add HTTP basic auth, IP restrictions, or a VPN in front of it to prevent unauthorized access. Exposing Adminer without additional authentication is a well-documented security risk with self-hosted database tools.
Resource consumption on your server. Every Coolify service runs on your VPS. If you are on a $6/month Hetzner CAX11 (the most popular Coolify server spec based on community discussions), adding Adminer consumes RAM and CPU that your applications and databases are also competing for.
Each database engine needs separate configuration. If you run both MySQL and PostgreSQL on the same Coolify server, you need to connect to each one separately through Adminer's login screen. There is no unified dashboard.
Method 2: CLI tools over SSH
Since Coolify runs on a VPS you control, you can SSH into the server and use command-line database clients directly.
# SSH into your Coolify server
ssh root@your-server-ip
# Connect to MySQL container
docker exec -it coolify-mysql mysql -u root -p
# Connect to PostgreSQL container
docker exec -it coolify-postgres psql -U postgres
What works: - No additional software to deploy - Direct access with full database privileges - Works with any database engine
What does not work:
The command line is powerful but hostile for browsing data. Running SELECT * FROM users LIMIT 50; in a terminal produces output that wraps, truncates, and is nearly impossible to scan visually when tables have more than 5-6 columns. There is no click-to-edit, no visual query builder, no one-click export to CSV. For quick lookups, the CLI works. For actual data management, it is painfully slow.
You also need SSH access to the server, which may not be appropriate for every team member who needs to see database contents.
Method 3: Desktop client with SSH tunnel
If you have a desktop database client (DBeaver, TablePlus, MySQL Workbench, pgAdmin), you can connect to your Coolify database through an SSH tunnel.
SSH Host: your-server-ip
SSH User: root (or your SSH user)
SSH Key: your private key
Database Host: localhost (or the Docker container name)
Database Port: 3306 (MySQL) / 5432 (PostgreSQL)
Database User: your database user
Database Password: your database password
Most desktop clients support SSH tunnels natively. The SSH tunnel encrypts the connection and avoids exposing database ports publicly.
What works: - Rich GUI with all the features of your chosen desktop client - Encrypted connection through SSH - No changes to Coolify or your server configuration
What does not work:
Every team member needs the desktop client installed. DBeaver is free but requires Java. TablePlus has a free trial but costs $89 for a license. pgAdmin is free but only supports PostgreSQL. Each person on the team needs to install software, configure the SSH tunnel, and enter credentials.
No access from restricted devices. Corporate laptops, tablets, Chromebooks, borrowed machines — if you cannot install a desktop client or do not have the SSH key, you have no access. This is the same limitation we see with other hosting platforms that lack browser-based database tools.
SSH keys need distribution. Every person who needs database access needs an SSH key authorized on the Coolify server. Managing SSH keys across a team — adding, revoking, rotating — is its own operational burden.
Method 4: Browser-based GUI with DBEverywhere
DBEverywhere provides hosted phpMyAdmin and Adminer as a service. For MySQL and MariaDB databases, you get the full phpMyAdmin interface. For PostgreSQL, MongoDB, and other engines, you get Adminer. The tool connects to your database from a known static IP — no containers to deploy, no desktop software to install.
For Coolify databases, you have two connection options:
Option A: Expose the database port to DBEverywhere's static IP.
In Coolify, you can configure a database service to expose its port publicly. Go to your database resource, enable "Publicly Accessible" in the network settings, and Coolify will map the container port to the host. Then configure your server's firewall (UFW, iptables, or your hosting provider's firewall) to only allow connections to that port from DBEverywhere's static IP.
# Allow only DBEverywhere's IP on MySQL port
ufw allow from <DBEverywhere-IP> to any port 3306
# Or for PostgreSQL
ufw allow from <DBEverywhere-IP> to any port 5432
This approach keeps the database port closed to everyone except the one IP that needs it. Combined with strong database credentials and SSL, this is a practical security trade-off used by thousands of production databases.
Option B: Use DBEverywhere's SSH tunnel (paid tier).
DBEverywhere's paid tier ($5/month) supports SSH tunnel connections. You provide your Coolify server's SSH credentials, and DBEverywhere tunnels through it to reach the database on the internal Docker network. The database port stays completely private — no firewall changes needed. This is the most secure option and works identically to how a desktop client with an SSH tunnel connects.
Comparison: all four approaches
| Factor | Adminer on Coolify | CLI over SSH | Desktop client + SSH | DBEverywhere |
|---|---|---|---|---|
| Setup time | 10-15 min | 2 min | 15-30 min per person | 5 min (one-time) |
| Monthly cost | Free (uses server resources) | Free | Free-$89 (client license) | Free / $5/mo |
| Browser-based | Yes | No | No | Yes |
| Works on any device | Yes | No (needs SSH) | No (needs desktop app) | Yes |
| Maintenance | Update container, manage auth | None | Manage SSH keys | None |
| Multi-database support | Yes (Adminer) | Per-engine CLI | Depends on client | Yes (phpMyAdmin + Adminer) |
| Database stays private | Yes (internal network) | Yes | Yes (SSH tunnel) | Option A: restricted. Option B: yes |
| Team access | Shared URL (security concern) | SSH key per person | SSH key + client per person | Each user has own account |
For solo developers comfortable with the command line, Method 2 costs nothing and requires nothing extra. For developers who want a GUI and are already managing their Coolify server closely, deploying Adminer (Method 1) is straightforward. For teams that need access from multiple devices without managing additional infrastructure, DBEverywhere (Method 4) eliminates the operational overhead.
Step-by-step: Connecting DBEverywhere to a Coolify database
Here is the process for connecting to a Coolify MySQL database using Option A (exposed port with IP restriction):
Step 1: Find your database credentials in Coolify.
Go to your Coolify dashboard, select your database resource, and note the connection details: host, port, username, password, and database name. Coolify displays these on the database resource page.
Step 2: Enable public access for the database.
In the database resource settings, toggle "Publicly Accessible" to on. Coolify will map the internal container port (e.g., 3306) to the same port on your host machine. Redeploy if prompted.
Step 3: Restrict the exposed port with a firewall rule.
SSH into your Coolify server and add a firewall rule:
# Allow only DBEverywhere's static IP
ufw allow from <DBEverywhere-IP> to any port 3306
ufw deny 3306
Verify the rule is active with ufw status. The database port is now reachable from exactly one external IP.
Step 4: Connect through DBEverywhere.
- Go to dbeverywhere.com and sign up.
- Click Connect and select MySQL/MariaDB.
- Enter your Coolify database details:
- Host: your Coolify server's public IP
- Port:
3306 - Username: from Coolify dashboard
- Password: from Coolify dashboard
- Database: your database name
- Enable SSL/TLS if your MySQL instance supports it.
- Click Connect.
You now have a full phpMyAdmin interface — browse tables, edit rows, run queries, import and export data, manage users — all from your browser.
For PostgreSQL, the process is identical but you select PostgreSQL as the engine and use port 5432. DBEverywhere connects through Adminer for PostgreSQL, which provides the same core functionality: table browsing, query execution, data export, and schema management.
FAQ
Does Coolify have a built-in database GUI on its roadmap?
As of early 2026, Coolify's GitHub roadmap and discussion threads do not indicate a built-in SQL editor or data browser. Coolify's focus is on deployment, scaling, and server management — adding a full database GUI would be a significant scope expansion. The community generally recommends deploying Adminer or phpMyAdmin as a separate Coolify service for GUI access.
Can I use DBEverywhere's free tier for Coolify databases?
Yes. The free tier provides 5 sessions per month with a 20-minute timeout per session. For checking deployment results, debugging a query, or exporting a quick CSV, five sessions covers most occasional use. Each session is independent — you can connect to different databases or the same one. The paid tier at $5/month adds unlimited sessions, 8-hour timeouts, and saved connections so you skip re-entering credentials.
Is it safe to expose my Coolify database port with a firewall rule?
Restricting a database port to a single IP address through UFW or iptables is a widely used pattern. Your database is not "open to the internet" — it is open to one known IP. Combined with strong credentials and SSL/TLS, this is the same security model used by AWS Security Groups and DigitalOcean trusted sources. If you want zero port exposure, use DBEverywhere's SSH tunnel on the paid tier — the database port stays completely private.
Does DBEverywhere work with all database engines Coolify supports?
DBEverywhere connects through phpMyAdmin for MySQL and MariaDB, and through Adminer for PostgreSQL, SQLite, and MS SQL. MongoDB and Redis are not currently supported through DBEverywhere's interface. For Coolify's most common database deployments — MySQL, MariaDB, and PostgreSQL — full coverage is available.
Can I deploy DBEverywhere itself on my Coolify server instead of using the hosted version?
No. DBEverywhere is a hosted service, not a self-hosted application. The value proposition is specifically that you do not manage any infrastructure for the database GUI — no containers, no updates, no security patches. If you prefer self-hosting your database management tool, deploying Adminer as a Coolify service (Method 1 above) is the right approach. The trade-off is that you take on the maintenance and security responsibility yourself.
Conclusion
Coolify has earned its reputation as the best open-source alternative to Heroku and Vercel for self-hosted deployments. Its one-click database provisioning, automated backups, and clean dashboard make spinning up infrastructure genuinely easy. But coolify database management stops at the infrastructure level — once your MySQL or PostgreSQL instance is running, browsing the actual data inside it requires additional tooling.
Deploying Adminer as a Coolify service works but adds a container to maintain and secure. CLI access works but is hostile for anything beyond simple lookups. Desktop clients with SSH tunnels work but require software and key distribution across your team.
DBEverywhere connects to your Coolify databases from any browser without deploying anything on your server. Expose the database port to a single static IP or use an SSH tunnel on the paid tier, and you get a full phpMyAdmin or Adminer interface — table browsing, query execution, data export, user management — from any device.
Coolify handles the deployment. DBEverywhere handles the day-to-day data access. Together, they give you a complete self-hosted stack without the operational overhead of managing yet another service.
Try DBEverywhere free — connect to your Coolify database in 60 seconds
Try DBEverywhere Free
Access your database from any browser. No installation, no Docker, no SSH tunnels.
Get Started