# Adminer

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. It is open source and self-hosted, installable on Unraid, Kubernetes (Helm) and ZimaOS.

Canonical page: https://ourlocalhost.com/app/4023/adminer

## Description

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, ZimaOS, Helm, Any server.

## Health score

82/100 (Excellent), based on 4 of 4 factors.
- Maintained: 98 (last commit 53 days ago)
- Popular: 78 (7,912 GitHub stars)
- Easy to install: 55 (4 install platforms, install notes)
- Light to run: 85 (307 MB minimum RAM)

## Links

- Official website: https://www.adminer.org/
- Unraid: https://ca.unraid.net/apps/adminer-1kxyz1f1pjtibb?q=adminer
- Kubernetes (Helm): https://artifacthub.io/packages/helm/cetic/adminer
- ZimaOS: https://github.com/IceWhaleTech/CasaOS-AppStore/tree/main/Apps/Adminer
- GitHub: https://github.com/vrana/adminer
- Documentation: https://hub.docker.com/_/adminer/

## 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.

## Alternatives

- 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 &quot;sequel&quot; 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.

---
Source: Our Local Host (https://ourlocalhost.com/app/4023/adminer), the self-hosted and open-source app directory.
