Adminer

Adminer 対応しているデータベース： MySQL, MariaDB, PostgreSQL, CockroachDB, SQLite, MS SQL, Oracle. Others can be added via plugin: Elasticsearch, SimpleDB, MongoDB, Firebird, Clickhouse.

See: Features, Requirements, Skins, References

Download
v 5.3.0, 2025-05-04

Screenshots

Screencast about Adminer features and using plugins (19:31, by Srigi)

Downloads

Adminer 5.3.0 (.php, 493 kB), English only (.php, 0 B)
Adminer 5.3.0 for MySQL (.php, 397 kB), English only (.php, 0 B)
Source codes (.zip, 853 kB), Current development version
Donate: Paypal, GitHub, Patreon
Latest stable version (use e.g. by wget): https://www.adminer.org/latest[-mysql][-ja].php
変更履歴, blog
User contributed packages: Docker, Debian package, Wordpress plugin, Drupal module, Arch Linux package, Dockette, Moodle plugin, CMS Made Simple Module, Laravel, Laravel, Laravel, Electron, Jaxon, Omeka
Older versions

Features

ユーザー名とパスワードでデータベースサーバーに接続
Select an existing database or create a new one
List fields, indexes, foreign keys and triggers of table
テーブルの名前、エンジン、照合順序、auto_increment、コメントの変更
カラムの名前、型、照合順序、コメント、デフォルト値の変更
テーブルやカラムの追加・削除
Create, alter, drop and search by indexes including fulltext
外部キーによるリストの作成・変更・削除・関連付け
Create, alter, drop and select from views
ストアドプロシージャや関数の作成・変更・削除・実行
トリガーの作成・変更・削除
テーブル内のデータを一覧表示し、検索・集計・並べ替え・件数制限が可能
Insert new records, update and delete the existing ones
Supports all data types, blobs through file transfer
Execute any SQL command from a text field or a file
テーブル構造・データ・ビュー・ルーチン・データベースをSQLやCSV形式でエクスポート
Print database schema connected by foreign keys
Show processes and kill them
Display users and rights and change them
Display variables with links to documentation
Support generated columns, check constraints
Manage events and table partitions (MySQL 5.1)
Schemas, sequences, user types (PostgreSQL)
Extensive customization options

Requirements

Works with MySQL, MariaDB, PostgreSQL, CockroachDB, SQLite, MS SQL, Oracle
Plugins: Elasticsearch, SimpleDB, MongoDB, Firebird, ClickHouse, IMAP - Improve your driver
Supports PHP 5.3+, 7 and 8 with enabled sessions
多言語対応 (46) - 翻訳に参加
Free for commercial and non-commercial use (Apacheライセンスまたは GPL 2)

Security is #1 priority in development of Adminer. Adminer does not allow connecting to databases without a password and it rate-limits the connection attempts to protect against brute-force attacks. Still, consider making Adminer inaccessible to public by whitelisting IP addresses allowed to connect to it, password-protecting the access in your web server, enabling security plugins (e.g. to require an OTP) or by customizing the login method. You can also delete Adminer if not needed anymore, it is just one file which is easy to upload in the future. Adminer had some security bugs in the past so update whenever Adminer tells you there is a new version available (ask your administrator if you could not update yourself). More information

Why is Adminer better than phpMyAdmin?

Replace phpMyAdmin with Adminer and you will get a tidier user interface, better support for MySQL features, higher performance and more security.

Adminer の開発では、「セキュリティ」「ユーザー体験」「パフォーマンス」「機能」「サイズ」の順に重視しています。