Why PX Adminer

Fixing a stuck article, checking in a locked item or taking a quick backup should not mean opening phpMyAdmin and looking up database passwords. PX Adminer opens your site database right inside Joomla, for the people Joomla already trusts.

Features

Browse

• Every table and row: sort, search and page through any table
• Quick filter for the table list, search all tables at once
• Readable JSON columns

SQL command

• Syntax highlighting and several queries in one go
• Ready-made Joomla queries that use your table prefix: find an article, list Super Users, check in locked items, largest tables
• Explain and export query results

Edit rows

• Edit, add, clone and delete rows in a form
• Format and validity check for JSON fields such as params
• Functions and NULL per field

Backup and restore

• One-click backup: the whole database as a dated .sql.gz file
• Export tables or the whole database as SQL, CSV or TSV, plain or gzip
• Import .sql and .sql.gz files to restore
• Drop and Truncate ask again and offer to export the tables first

Overview

• The ten largest tables with size and row count
• Dark mode follows the Joomla administrator

Structure

• Alter and create tables
• Indexes, foreign keys and triggers
• Database schema diagram

Security

• Super Users only; other admin groups get no access
• One-time key per visit: used once, valid 60 seconds, bound to your browser
• Closes on Joomla logout, after 2 hours at most
• Adminer's own files can't be opened directly
• Sign-ins and rejected keys are logged
• No calls to outside servers: updates come from the Joomla update system

Requirements

• Joomla 5 or 6
• PHP 8.1 or later
• Track Session Metadata on (Global Configuration › System, the Joomla default)
• Updates through the Joomla update system
• License GNU GPL v2 or later

Changelog

1.1.1 (Nov 6, 2026)

• Real extension name in the manifest

1.1.0 (Oct 29, 2026)

• One-click database backup as a dated .sql.gz file
• Export and backup file names carry the date and time
• The database overview shows the ten largest tables
• Dark mode follows the Joomla administrator
• Drop and Truncate ask again and offer to export the tables first

1.0.2 (Oct 28, 2026)

• Security: the bundled Adminer file stops when it is requested directly (servers that ignore .htaccess)
• Security: Track Session Metadata must be on, so the Adminer session ends with the Joomla session

1.0.1 (Oct 26, 2026)

• Adminer moved to its own vendor folder with its licence file
• No version check request to adminer.org
• Updating removes the old media/adminer/adminer.php

1.0.0 (Oct 18, 2026)

• Initial release

Made by thepixel.dev. Includes Adminer by Jakub Vrána (Apache 2.0 or GPL 2, used under GPL 2).