Adminer

Adminer is a lightweight, full-featured database management tool written in PHP that runs as a single deployable file for homelab administrators and…

  • Other
  • Tools & Utilities
Adminer is a lightweight, full-featured database management tool written in PHP that runs as a single deployable file for homelab administrators and developers to inspect schemas, edit data, and run queries across MySQL, MariaDB, PostgreSQL, SQLite, Microsoft SQL Server, Oracle, and plugin-supported databases as a compact phpMyAdmin alternative.

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

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

Collected 31 days ago - public community threads