Adminer
Adminer is a lightweight, full-featured database management tool written in PHP that runs as a single deployable file for homelab administrators and…
Platform availability
Available on 4 of 10 platforms
- Unraid
- TrueNAS (not listed)
- Umbrel (not listed)
- ZimaOS
- Proxmox (not listed)
- Helm
- Mac (not listed)
- Windows (not listed)
- Linux (not listed)
- Any server
Health score?A 0-100 score computed nightly from four factors: maintained (40%: recent commits and steady activity), popular (25%: GitHub stars, log scale), easy to install (20%: platforms, install notes, setup guides, Docker image) and light to run (15%: minimum RAM, ARM support). When the source code has been checked, a fifth factor, security check (20%: automated scan for committed secrets, unsafe desktop-app settings, known-vulnerable dependencies and project hygiene; any serious finding caps it at 20), is added. Factors without data are left out and the rest are rescaled.
82/100 Excellent
- Maintained
- 98last commit 53 days ago
- Popular
- 787,912 GitHub stars
- Easy to install
- 554 install platforms, install notes
- Light to run
- 85307 MB minimum RAM
Availability: platform listings confirmed today, links checked 11 days ago
- GitHub stars
- 7,912
- Open issues
- 1
- Last commit
- 2026-09-29
- Latest release
- v6.1.1
- Activity
- declining
Checked 54 days ago - source: GitHub (vrana/adminer)
Resources & Compatibility
Minimum requirements: 307 MB RAM, 1 CPU core(s), 5 GB disk.
Checked 46 days ago - source: Docker Hub image tags and published docs
First-install notes
- Create a database user Adminer can use Create a database account in your MySQL/MariaDB server with permissions for the actions you expect to do, such as SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, and LOCK TABLES. Without enough permissions, Adminer can open but may fail when saving data or changing table structure. source
- Turn off old server-list login if needed If you plan to use a different Adminer login method, turn off the AdminerLoginServers block in index.php by adding // before each line. Leaving it active can override or conflict with the new login behavior. source
- Add a read-only mode to avoid edits If you need read-only access, modify Adminer's PHP file so form fields are disabled when you add ?viewonly to the page address. This prevents accidental saves or deletes when you only mean to view data. source
Fetched 53 days ago - each note links to its source
Variants
Alternatives (9)
- DBeaver - A versatile, open-source database tool for developers and administrators supporting multiple databases via JDBC drivers with extensive plug…
- DataGrip - DataGrip is a database IDE from JetBrains that is tailored to suit specific needs of professional SQL developers.
- HeidiSQL - Supports MySQL, MariaDB, Microsoft SQL, and PostgreSQL for data viewing, editing, and exporting with no tracking and offline capabilities.
- LibreDB Studio - LibreDB Studio is an open source (MIT), self-hosted SQL IDE.
- MySQL Workbench - MySQL Workbench is a unified visual tool for database architects, developers, and database administrators to design, develop, and manage My…
- Sequel Ace - Sequel Ace is the "sequel" to longtime macOS tool Sequel Pro.
- Sequel Pro - Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL databases.
- pgweb - Pgweb is a lightweight, cross-platform desktop PostgreSQL client that gives developers and administrators a local web interface for browsin…
- phpMyAdmin - phpMyAdmin is a free, open-source web interface for administering MySQL and MariaDB databases over the web.
Checked 54 days ago - source: AlternativeTo
Common questions
What MySQL/MariaDB permissions should Adminer's database account have?
Create a database account with permissions for SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, and LOCK TABLES. Without enough permissions, Adminer can open but may fail when saving data or changing table structure.
What do I need to change if I use a custom Adminer login method?
Turn off the old server-list login by commenting out the AdminerLoginServers block in index.php, adding // before each line. Leaving it active can override or conflict with the new login behavior.
How can I create a read-only Adminer view?
Modify Adminer's PHP file so form fields are disabled when ?viewonly is added to the page address. This prevents accidental saves or deletes when you only mean to view data.
How do I create a single-file Adminer from a Git checkout?
Run git submodule update --init or composer install after downloading from Git. Then use compile.php to create a single file version.
Answers sourced from github.com, github.com, github.com, github.com
Community
- Database Control Panel : r/selfhosted - Reddit (reddit)
- Containerised DB Management System : r/selfhosted - Reddit (reddit)
- Built an alternative to PhpMyAdmin/Adminer : r/webdev - Reddit (reddit)
- r/selfhosted on Reddit: Deploy Adminer - Open Source Database ... (reddit)
Collected 31 days ago - public community threads