» »»Adminer for PrestaShop, Database Manager
Adminer for PrestaShop, Database Manager View larger

Adminer for PrestaShop, Database Manager

medadminer

Launch Adminer directly from your PrestaShop back-office — without ever exposing the database password, behind a SuperAdmin-only multi-layered security model.

Be careful, this module can have serious consequences on your store. The author of the module can not be held responsible.

More details

Data sheet

Version 1.3.0
Core modifications (override) No
Third party subscription: No
Translation : bg-da-de-el-es-et-fi-fr-hu-it-ja-nl-pl-pt-ro-sk-sv-uk
Compatible Prestashop 1.6 Yes
Compatible Prestashop 1.7 Yes
Compatible PrestaShop 8 Yes
Compatible PrestaShop 9 Yes
Compatible thirtybees 1.2 Yes
Compatible thirtybees 1.3 Yes
Compatible thirtybees 1.4 Yes
Compatible thirtybees 1.5 Yes
Compatible thirtybees 1.6 Oui
PhenixSuite compatible Yes
Multi Shop compatible: Yes
Free module download https://link.prestatoolbox.fr/adminerprestashop

Free

Secure payment methods

Compatibility

This modules is compatible with all PrestaShop 1.6.x version This modules is compatible with all PrestaShop 1.7.x version This modules is compatible with all PrestaShop 8.x version This modules is compatible with all PrestaShop 9.x version

thirtybees Compatibility

This modules is compatible with all thirtybees 1.2.x version This modules is compatible with all thirtybees 1.3.x version This modules is compatible with all thirtybees 1.4.x version This modules is compatible with all thirtybees 1.5.x version This modules is compatible with all thirtybees 1.6.x version

PhenixSuite Compatibility

This modules is compatible with all PhenixSuite version

Translate in

bg da de el es et fi fr hu it ja nl pl pt ro sk sv uk

Proposed by

Mediacom87

More info

The problem

You need a precise SQL query to diagnose a bug, fix a bulk import or clean up the database — but the back-office interface won’t let you.

Open phpMyAdmin? Not always available with your host, and it requires managing a separate access. Hand out SSH credentials? Out of the question for a quick audit.

The solution

Adminer for PrestaShop bundles Adminer in the back-office and launches it in one click, injecting credentials server-side via a single-use token. The DB password never appears in the HTML.

Hardened auth: active SuperAdmin profile required on every request. Both Adminer 4 & 5 bundled, auto-selected based on your PHP. Apache + nginx guard blocks direct access.

How it works

1

Adminer tab in the back-office

Open the module configuration page: a Start Adminer button is immediately available. No password to type.

2

Single-use signed token

A click generates a server-side token with a 60s TTL. The front controller revalidates your active SuperAdmin profile on every request before injecting the DB credentials.

3

Full SQL access

Adminer opens in a new tab, already logged into your database. Queries, editing, JSON/XML/ZIP dumps: everything is immediately available.

Feature highlights

Full SQL access

  • Run arbitrary SQL queries
  • Edit rows, tables, indexes
  • Manage users and privileges
  • EXPLAIN execution plans
  • Import/export in SQL, CSV, JSON, XML

Adminer 4 & 5 bundled

  • Adminer 4.8.1 for PHP 5.6 to 7.3
  • Adminer 5.4.2 for PHP 7.4+
  • Auto-selected at runtime via PHP_VERSION_ID
  • No user configuration needed
  • Adminer upgrades shipped in module releases

Multi-layered security

  • Restricted to the SuperAdmin profile (id_profile = 1)
  • Active employee revalidated from DB on every request
  • Single-use launch token with 60s TTL
  • DB password never appears in the back-office HTML
  • No permissive CORS header

Apache + nginx guard

  • .htaccess deny all on the vendor folder (Apache)
  • defined('_PS_VERSION_') guard injected into adminer.php
  • Direct access blocked even on servers ignoring .htaccess
  • HTTPS forced ($ssl = true)
  • Adminer plugins loaded via explicit allow-list

Export plugins included

  • JSON dump
  • XML dump
  • ZIP dump (compressed)
  • Timestamped dump (date in filename)
  • prestashop plugin intercepting Adminer’s own login form

Wide compatibility

  • PrestaShop 1.6 to 9.x
  • thirty bees
  • PHP 5.6 to 8.3+
  • Apache, nginx, LiteSpeed
  • Multi-shop

Mediacom87 BO integration

  • Multi-tab interface (ps-tabs)
  • Built-in Mediacom87 license tab
  • Built-in security policy tab
  • Changelog visible from the BO
  • Ko-fi support call for free modules

Native translations

  • Back-office interface available in 17 languages
  • bg, da, de, el, es, et, fi, fr, hu, it, ja, nl, pl, pt, ro, sk, sv
  • Changelog translated in each language
  • Translation files compliant with PrestaShop MD5 keys

Use cases

Bug diagnostic: run an SQL query to understand why a product doesn’t appear in a category. Import fix: bulk cleanup after a botched CSV import. Audit: verify the integrity of native or third-party module tables. Optimization: EXPLAIN slow queries, add indexes. One-off export: JSON/ZIP dump of a specific table for migration or analysis.

Installation

Download the module and install it from your back-office (Modules > Module Manager).

No configuration required: the module auto-detects your PHP version and selects Adminer 4.8.1 or Adminer 5.4.2.

Connect with an employee account having the SuperAdmin profile (security is intentionally strict).

Activate your Mediacom87 license in the License tab to receive update notifications and priority support.

Click Start Adminer in the module’s main tab: Adminer opens in a new tab, already authenticated against your database.

Changelog

1.3.0 - 05/11/2026

  • Security: database password is no longer transmitted through the back-office HTML form
  • Security: one-time signed token replaces the credentials in the launch form (60s TTL, single use)
  • Security: front controller now revalidates the back-office employee (active + SuperAdmin profile) on every request
  • Security: removed misnamed and unused debug front controller
  • Security: removed permissive CORS header on the Adminer endpoint
  • Security: defense-in-depth guard added on bundled Adminer files — direct HTTP access blocked even on servers that ignore .htaccess (nginx, etc.)
  • Adminer: ships both 4.8.1 (PHP 5.6–7.3) and 5.4.2 (PHP 7.4+), auto-selected at runtime
  • Adminer plugin loader now uses an explicit allow-list, plugins actually load (loginForm redirect, dump-*)
  • UI: full rework of the configuration page (ps-tabs layout, license tab, security policy, support links)
  • UI: removed Mediacom87 RSS feed, replaced by a dedicated tab structure and a Ko-fi support call
  • Mediacom87 license integration (status, request, activate, migrate, refresh)
  • Update notifications gated on active license
  • CSS files renamed with version suffix for cache busting
  • Compatibility: PrestaShop 1.6 → 9.x / PHP 5.6+ across the whole module
  • Code: removed dead helper methods, fixed PHPDoc, PHP 8.2+ compatibility

1.2.0 - 10/15/2025

  • Added compatibility with PrestaShop 9
  • Update of the Adminer script to version 5.4.1
  • Improved module security

1.1.0 - 06/10/2025

  • Adminer version 4.17.1 updated
  • Add security policy

1.0.0 - 12/02/2022

  • Initial version

Interested in product

Tell us your interest in this product and we will contact you for more details.

[0/]
Adminer for PrestaShop, Database Manager
Adminer for PrestaShop, Database Manager


: Fields marked with an asterisk are required.

Reviews