explaingit

vrana/adminer

★ 7,386PHPAudience · developerComplexity · 2/5Setup · easy

TLDR

A single PHP file you drop on any web server to get a full browser-based database manager supporting MySQL, PostgreSQL, SQLite, SQL Server, and more, no installation needed beyond PHP.

Mindmap

mindmap
  root((Adminer))
    What it does
      Browse and edit tables
      Run SQL queries
      Import and export data
      Manage users
    Databases
      MySQL and MariaDB
      PostgreSQL
      SQLite
      SQL Server
    Setup
      Single PHP file
      No installation
      PHP 5.3 or newer
    Extensions
      Plugin system
      Adminer Editor
      Community plugins
Click or tap to explore — scroll the page freely

Code map

Detail Auto

An interactive map of this repo's files and how they connect — its source is parsed live in your browser. Click Visualize to build it.

filefunction / class

Things people build with this

USE CASE 1

Add browser-based database access to a project by uploading one PHP file to your server

USE CASE 2

Run SQL queries and edit table data without installing a desktop database tool

USE CASE 3

Import and export database content in formats like SQL and CSV directly from the browser

USE CASE 4

Manage database users and permissions on MySQL or PostgreSQL from a web interface

Tech stack

PHP

Getting it running

Difficulty · easy Time to first run · 5min

In plain English

Adminer is a database management tool written in PHP that ships as a single file. You copy the file onto a web server, open it in a browser, and get a full-featured interface for working with database content: viewing and editing tables, running queries, importing and exporting data, and managing users and permissions. Because the entire tool is a single file, there is nothing to install or configure beyond PHP being available on the server. This makes it straightforward to add database access to a project quickly, without setting up a heavier tool. Adminer supports several database systems out of the box, including MySQL, MariaDB, PostgreSQL, CockroachDB, SQLite, Microsoft SQL Server, and Oracle. Additional database systems are supported through plugins, including Elasticsearch, MongoDB, ClickHouse, and Firebird. A plugins page on the official website lists both included and user-contributed extensions. The project also includes a companion called Adminer Editor, a simpler interface intended for end users who need to view and edit data in tables but should not have access to the full administrative controls. The compiled single-file version requires PHP 5.3 or newer. Working from the source code (the version in this repository) requires PHP 7.4 or newer, and cloning the repository requires running a git submodule command to pull in dependencies. A compile script generates the single-file distribution from the source.

Copy-paste prompts

Prompt 1
How do I connect Adminer to a remote PostgreSQL database that requires SSL and a non-standard port?
Prompt 2
Write a PHP Adminer plugin that adds a custom action button to every table's row view
Prompt 3
How do I lock Adminer down so it only accepts connections from my office IP address?
Prompt 4
Show me how to compile Adminer from the source repository and add a custom CSS theme
Prompt 5
How do I use Adminer with SQLite, what path do I give it to open a local database file?
Open on GitHub → Explain another repo

← vrana on gitmyhub — every repo by this author, as a profile.

Verify against the repo before relying on details.