/ Plugin Category

/ Site Administration & Utilities

/ Database Management & Cleanup

/ Database Manager – WP Adminer

Database Manager – WP Adminer

By Pexle Chris

Site Administration & Utilities / Database Management & Cleanup

Database Manager – WP Adminer Review - In-Depth Analysis

Manage your WordPress database directly from the dashboard using Adminer. This tool simplifies database management for administrators.

Performance Overview

WPS Score

7/10

User Rating

5/5 (based on 28+ reviews)

Active Installations

20,000+

Update Frequency

Average It is calculated using the weighted average of same category plugins.

Security Score

1 / 10 (Very Low Risk) It is calculated using the weighted average of all versions.

What It Does

This plugin provides the best database management tool for WordPress.

It utilizes Adminer to give database access to administrators directly from the WordPress Dashboard. The integration is straightforward and user-friendly.

While the author of this plugin is not the creator of Adminer, they have successfully integrated it for WordPress users. Adminer was created by Jakub Vrana, and donations can be made to support his work.

The plugin is compatible with WordPress Multisite installations, making it versatile for various setups.

Access WP Adminer easily through the Admin Bar or the Tools Page in the Dashboard.

Comparing to Alternatives

Database Manager – WP Adminer offers a straightforward way to manage your WordPress database directly from the dashboard, standing out among similar plugins.

Top alternatives

Strengths

Integrates Adminer directly into WordPress for easy database management.
Simple and user-friendly interface with quick access to common tables.
Does not require separate database access credentials if you have admin access.
Lightweight and straightforward without unnecessary features.

Weaknesses

Limited to database management functions without additional backup or optimization tools.
No built-in support for managing multiple databases beyond the WordPress database.
Lacks advanced scheduling or automation features found in some alternatives.

User Sentiment Analysis

User feedback highlights the plugin's simplicity and effectiveness for database management within WordPress.

Positive highlights

"WP Adminer works fine! Thanks!" – Pavel Bohovin
"Awesome plugin when you don't have access to DB but need it from WP dashboard" – benjirahmed
"Awesome plugin, simple, and straightforward." – Charalampos Papazoglou
"Great plugin, it opens the WordPress database with Adminer." – fmarzolo
"Very handy! Adminer integration is so much cleaner than phpMyAdmin." – gudi

Common complaints

Limited to WordPress database access unless configured otherwise.
No advanced features like backups or database optimization.
Lack of multi-database management capabilities.

Weaknesses

No pro version means fewer advanced features.
Interface is basic compared to some standalone database tools.

Who Should Use This?

Best for

Users who need quick, direct access to their WordPress database from the admin dashboard without separate database credentials.

Not ideal for

Those looking for comprehensive database management solutions including backups, optimization, or multi-database support.

Pricing & Value

Free version includes

The free version includes full Adminer integration within WordPress, allowing database browsing and management directly from the dashboard.

Final Verdict

Database Manager – WP Adminer is a practical and lightweight plugin that brings the power of Adminer into the WordPress admin area, making database management accessible and straightforward.

While it lacks advanced features and a pro version, it excels at providing essential database access for users who need quick edits or inspections without leaving WordPress.

Other Notable Features

Here are a few other notable features of this free Database Manager – WP Adminer plugin.

Adminer

Database management

WordPress database

Screenshots

FAQ

Yes, because only administrators have access to WP Adminer. If a guest tries to access the WP Adminer URL, a 404 page will be shown up.

You need to use action pexlechris_adminer_head as follows:

  add_action('pexlechris_adminer_head', function(){      // Use the appropriate get_nonce() function based on your WP Adminer version      $nonce = function_exists('Adminer\get_nonce')          ? Adminer\get_nonce() // For WP Adminer v4.0.0 and newer          : get_nonce(); // For WP Adminer versions below 4.0.0      ?>      <script nonce="<?php echo esc_attr( $nonce )?>"> // get_nonce is an adminer function         // Place your JS code here      </script>      <style>         /* Place your CSS code here */      </style>      <?php   });

You can do this using WP filter: pexlechris_adminer_adminbar_dropdown_items.
Filter’s PHPDoc:

 /**   * The dropdown items.   *   * @param array $dropdown_items{   *      @type string $name. The table name.   *      @type string $label. The label of the dropdown item.   *      @type array $args. The array of extra url parameters. Parameters will not be encoded.   *                         Developers could avoid defining args in the array   * }   */  $dropdown_items = apply_filters('pexlechris_adminer_adminbar_dropdown_items', $dropdown_items);

In Adminer’s website there is documentation about Adminer plugins and Adminer extensions.
In order to define function adminer_object() before this plugin define it, you need to define it inside the hook pexlechris_adminer_before_adminer_loads.
More in the phpDoc below:

 /**   * adminer_object can be overridden, in WP action pexlechris_adminer_before_adminer_loads.   * If a developer want to make his/her own changes (adding plugins, extensions or customizations),   * it is strongly recommended to include_once the class Pexlechris_Adminer and extend it and   * make adminer_object function return his/her new class.   *   * It is strongly recommended, because Pexlechris_Adminer class contains WordPress/Adminer integration (auto login with WordPress credentials)   *   * If a developer want to add just JS and/or CSS in head, he/she can just use the action pexlechris_adminer_head.   * See plugin's FAQs, for more.   *   * @since 2.1.0   *   * @link https://www.adminer.org/en/plugins/#use Documentation URL.   * @link https://www.adminer.org/en/plugins/ Adminer' plugins Documentation URL.   * @link https://www.adminer.org/en/extension/ Adminer' extensions Documentation URL.   */