DDEV Adminer

Overview

Adminer is a full-featured database management tool written in PHP.

This add-on integrates Adminer into your DDEV project.

Adminer works with MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, and MongoDB.

Installation

ddev add-on get ddev/ddev-adminer
ddev restart

After installation, make sure to commit the .ddev directory to version control.

Usage

Command	Description
ddev adminer	Open Adminer in your browser (https://<project>.ddev.site:9101)
ddev describe	View service status and used ports for Adminer
ddev logs -s adminer	Check Adminer logs

SQLite

When connecting to an SQLite database, the project files are available under the /mnt/ddev_app mount, in the example below, test.sqlite is located in the project root:

ddev dotenv set .ddev/.env.adminer \
    --adminer-default-driver=sqlite \
    --adminer-default-username="" \
    --adminer-default-password="" \
    --adminer-default-server="" \
    --adminer-default-db=/mnt/ddev_app/test.sqlite

Make sure the owner of the SQLite database file is the same as the user which adminer is running as.

Advanced Customization

To change the design:

# design: https://www.adminer.org/en/#extras
ddev dotenv set .ddev/.env.adminer --adminer-design=dracula
ddev add-on get ddev/ddev-adminer
ddev restart

Make sure to commit the .ddev/.env.adminer file to version control.

To add more plugins:

# plugins: https://www.adminer.org/en/plugins/
ddev dotenv set .ddev/.env.adminer --adminer-plugins="ddev-passwordless-login tables-filter edit-calendar"
ddev add-on get ddev/ddev-adminer
ddev restart

If a plugin requires parameters, refer to the official documentation for more details.

For user-contributed plugins, see example.

Make sure to commit the .ddev/.env.adminer file to version control.

All customization options (use with caution):

Variable	Flag	Default
ADMINER_DEFAULT_DB	--adminer-default-db	db
ADMINER_DEFAULT_DRIVER	--adminer-default-driver	server
ADMINER_DEFAULT_PASSWORD	--adminer-default-password	db
ADMINER_DEFAULT_USERNAME	--adminer-default-username	db
ADMINER_DESIGN	--adminer-design	``
ADMINER_DOCKER_IMAGE	--adminer-docker-image	adminer:standalone
ADMINER_PLUGINS	--adminer-plugins	ddev-passwordless-login tables-filter

Credits

Contributed by @bserem

Maintained by the DDEV team