Deploy Adminer
Single-file database admin UI for Postgres, MySQL, SQLite and more
Just deployed
/data
Deploy and Host Adminer on Railway
Adminer is an open-source database management tool that ships as a single PHP file. From the browser you can browse and edit rows, change tables, indexes and foreign keys, run SQL, and import or export dumps. It supports MySQL, MariaDB, PostgreSQL, SQLite, MS SQL and Oracle, and its bundled plugins add more.
About Hosting Adminer
This template deploys Adminer 6.3.0 from the official Docker image, pinned by version and digest and built from a public GitHub repo. You get one service with a Railway domain, a health check and a volume at /data. The volume holds PHP sessions, Adminer's adminer.key and the failed-login log, so you stay logged in and the lockout still applies after a redeploy. Adminer has no accounts of its own: you sign in with your database's credentials. No database is bundled. Deploy the template into the project that holds your database. Adminer then reaches it over Railway's private network.
Common Use Cases
- Browse, edit and query a Railway Postgres or MySQL database without installing a desktop client
- Import or export SQL dumps when you migrate data into or out of Railway
- Check the schema, indexes and foreign keys of an app's database while you debug it
Dependencies for Adminer Hosting
- A database Adminer can reach: a Railway Postgres, MySQL or MariaDB service in the same project, or any external server
- Nothing else: Adminer stores no data of its own beyond sessions on its volume
Deployment Dependencies
- Adminer: https://www.adminer.org/
- Adminer 6.3.0 release: https://github.com/vrana/adminer/releases/tag/v6.3.0
- Official Docker image: https://hub.docker.com/_/adminer
- Template repo: https://github.com/aalfath/adminer-railway-template
Implementation Details
After deploy: open the service's public URL. Pick the database system, then enter the server, user, password and database. For a Railway database in the same project, use its private host, for example postgres.railway.internal (prefilled) or mysql.railway.internal, and copy the user and password from that database's Variables tab. Adminer refuses logins with an empty password.
What the template adds to the official image:
- Sessions,
adminer.key(it encrypts "permanent login" passwords) and the failed-login log live on the/datavolume. - Adminer's official
login-reverse-proxyplugin is on. Behind Railway's proxy every request seems to come from the same address, so without it 30 failed logins by anyone would lock everyone out for 30 minutes. - Cookies are marked
Securebehind Railway's HTTPS edge, and uploads up to 256 MB are allowed for SQL imports. - Adminer runs as the image's unprivileged
admineruser.
Optional variables you can add to the service: ADMINER_DEFAULT_SERVER (prefilled server, for example mysql.railway.internal), ADMINER_DESIGN (a bundled theme such as dracula), ADMINER_PLUGINS (bundled plugins, space separated, for example tables-filter dump-json).
Updates: the service builds from the template repo. When we merge a new Adminer version to its main branch, Railway shows your project an "update available" notice, and you choose when to apply it. Each version is listed in the repo's CHANGELOG.md, with breaking changes first.
Security: the URL is public, so anyone who knows a database password can use it. Use strong database passwords, or remove the service's public domain when you don't need it.
Why Deploy Adminer on Railway?
Railway is a singular platform to deploy your infrastructure stack. Railway will host your infrastructure so you don't have to deal with configuration, while allowing you to vertically and horizontally scale it.
By deploying Adminer on Railway, you are one step closer to supporting a complete full-stack application with minimal burden. Host your servers, databases, AI agents, and more on Railway.
Template Content
