Release notes from adminer

v5.4.2

2026-02-08T15:54:10Z

Avoid denial-of-service via version check (GHSA-q4f2-39gr-45jh, regression from 4.6.2)
Pretty print JSON in edit
Support multiline generated values in alter table
Link //domain.tld values
Improve print of nested tables
Hide sort links on unsortable columns
Display uneditable fields in edit form
Shorten all but numeric and date types in select
Fix escaping spaces in cookie value (bug #1208)
Don't quote comma in TSV export (bug #1238)
MariaDB: Don't display checks with the same name from another table (bug #1135)
PostgreSQL: Offer foreign keys in create table
PostgreSQL: Add missing parentheses to CHECK export
PostgreSQL: Allow creating NOT DEFERRABLE foreign keys
PostgreSQL: Remove duplicate DEFERRABLE in foreign key export
PostgreSQL: Add schema to sequence and view export
PostgreSQL: Fix definition of complex generated columns
PostgreSQL: Mark unique partial indexes as unique (bug #1172)
PostgreSQL: Fix namespace in inheritance links (bug #1221)
non-PostgreSQL: Display NOT NULL checks (bug #1237)
ClickHouse: Fix offset (bug #1188)
ClickHouse: Fix list of tables (bug #1176)
Plugins: Methods showVariables() and showStatus() (bug #1157)
Plugins: Allow to be in any namespace
New plugin: IGDB driver

v5.4.1

2025-09-27T06:58:55Z

SQL command: Unlink NULL primary keys
Do not quote 0 in CSV export
Warn about exceeded upload_max_filesize in imports
Prolong queries saved from SQL command to URL (bug #1154)
MySQL: Fix displaying routine definition (bug #1156, regression from 5.4.0)

https://www.adminer.org/#download

v5.4.0

2025-09-08T09:48:53Z

Allow specifying operator in search anywhere
Do not order descending in GROUP BY select
Allow exporting SQL in SQL command (bug #1092)
Add section links in database overview
Warn about exceeded max_file_uploads in import
Display @ after username without server in existing logins
Display data length and index length for materialized views
Link routines from syntax highlighting
Autofocus added field in alter table
Executed SQL commands: Add button for copy to clipboard
Load more: run syntax highlighter
Allow connecting to IPv6 (bug #1095)
MySQL: Fix saving empty enum (bug #1152)
MySQL 5.0-: Do not load partitioning info in alter table (bug #1099)
MariaDB: Parse COLLATE in routine definition (bug #1104)
PostgreSQL: Show structure of inherited tables
PostgreSQL: Display index expressions
PostgreSQL: Add SQL operator to select
PostgreSQL: Hide only partitions, not all inherited tables from menu
PostgreSQL: Allow comparing json columns (bug #1107)
PostgreSQL: Shorten values in hstore columns
PostgreSQL: Quote edit value with interval operator
PostgreSQL: Fix calling functions with name-less parameters
PostgreSQL: Fix calling functions returing table
PostgreSQL: Don't treat user types containing 'file' as blobs (bug #1118)
PostgreSQL: Export DROP and CREATE DATABASE (bug #1140)
PostgreSQL 11-: Avoid duplicate oid in table status (bug #1089)
Elasticsearch: Support dropping aliases
Plugins: Methods afterConnect(), processList() and killProcess()
New plugin: Display row numbers in select (bug #1106)
New plugin: Specify query timeout

https://www.adminer.org/#download

v5.3.0

2025-05-04T16:31:52Z

Align numeric functions right
Autocomplete: Support table aliases
Fix type error in Create function (bug #1053, regression from 5.1.1)
Add border to column actions (bug #1072)
Align money values right (bug #1071)
MySQL: Avoid warning on selecting tables with fulltext indexes (bug #1036)
MySQL, PostgreSQL: Support index algorithms (bug #1030)
MySQL: Fix connecting to localhost:3306 (bug #1057, regression from 5.1.1)
PostgreSQL, CockroachDB: Creating partitioned tables (bug #1031)
PostgreSQL: Move partitioned tables from table list to parent table
PostgreSQL: Support partial indices (bug #1048)
PostgreSQL: Support calling functions returning table (bug #1040)
PostgreSQL: Add NOT ILIKE operator (bug #1066)
Editor: Fix bit and enum search (bug #1062)
Designs: adminer.css with 'prefers-color-scheme: dark' doesn't disable dark mode
Plugins: Method bodyClass() to add <body class>
Plugins: Allow setting dark mode in css()
Hindi translation

https://www.adminer.org/#download

v5.2.1

2025-04-11T20:28:08Z

Fix search anywhere (bug #1004, regression from 5.1.1)
Fix import without primary key (bug #1017, regression from 5.1.1)
PostgreSQL PDO: Fix bytea without primary key (bug #1021)
non-MySQL: Parse '--' without trailing space as comment in SQL command (bug #1025, regression from 5.2.0)

https://www.adminer.org/#download

v5.2.0

2025-04-08T16:32:06Z

Autocomplete SQL commands
Do not edit NULL values by Modify (bug #967)
Fix foreign key actions (regression from 5.1.1)
MySQL: Display number of found rows in group queries (regression from 5.1.1)
PostgreSQL: Support COPY FROM stdin in SQL query (bug #942)
non-MySQL: Parse '--' without trailing space as comment in SQL command (bug SF-842)
MS SQL: Limit one INSERT in export to 1000 rows (bug #983)
CSS: Add logo
Editor: Move mass sending e-mails to a plugin
Plugins: Support translations by extending Adminer\Plugin
New plugin: Configure options by end-users and store them to a cookie
New plugin: Configure menu table links
New plugin: Set up driver, server and database in Adminer Editor

https://www.adminer.org/#download

v5.1.1

2025-04-03T06:10:22Z

Export: Fix tar (regression from 5.0.3)
Select: Allow ordering by COUNT(*) (bug #966, regression from 5.0.2)
Optimize retrieving columns for schema
Elasticsearch: Make it work with Elasticsearch 8
CSS: Hide menu on mobile
CSS: Invert icons in dark mode
Plugins: Allow changing CSP by more plugins
New plugin: Use Monaco Editor for syntax highlighting
New plugin: Use Prism for syntax highlighting
Internal changes

https://www.adminer.org/#download

v5.1.0

2025-04-03T06:09:12Z

Display collation at table structure if different from table
Ctrl+click in select moves the cursor in modern browsers
URL parameter ?ext=pdo to force using PDO
PDO: Handle PHP warnings for internal queries
PostgreSQL: Display auto_increment of inserted rows
PostgreSQL: Display description of system variables
PostgreSQL: Avoid warning about crdb_version (bug #924, regression from 5.0.5)
PostgreSQL 11: Support PROCEDURE
SQLite PDO: Display results in SQL query
MS SQL: Fix collation issues when retrieving default values
MS SQL PDO: Display last insert ID
CSS: Sticky table headers (bug #918)
CSS: Allow more custom styles with dark mode (bug #925)
CSS: Increase maximum width of string edit (bug #930)
CSS: Increase space after SQL result (bug #937)
Plugins: autoload plugins from adminer-plugins/
Plugins: configure plugins with adminer-plugins.php
Plugins: Display loaded plugins in server overview
New plugin: AI prompt in SQL command generating the queries with Google Gemini
New plugin: Verify new versions from GitHub
New plugin: IMAP driver created for fun
New plugin: Display links to tables referencing current row
New plugin: Allow switching light and dark mode (bug #926)
New plugin: Confirm before unloading page with changed form
Uzbek translation
Internal changes

https://www.adminer.org/#download

v5.0.6

2025-03-17T22:56:21Z

Align numbers right (bug #912)
Display comment in title of field
Remember export setting at SQL command
Shorten queries saved from SQL command to URL (bug #917)
SQL textarea: Open help on Ctrl+click
Security: Disallow writing temporary files to symlinks (bug SF-855)
MariaDB: Display MariaDB instead of MySQL
CSS: Dark mode syntax highlighting
CSS: Dark input fields in dark mode
Designs named adminer-dark.css use dark basic style
Plugins: Add method syntaxHighlighting()

https://www.adminer.org/#download

v5.0.5

2025-03-13T17:35:23Z

MySQL: Display converting function for binary, bit or geometry fields
MySQL: Display default values of binary columns
MySQL: Allow setting default values of json column
MariaDB: Don't display NULL as default value (regression from 5.0.0)
PostgreSQL PDO: Escape bytea values (bug #218)
CockroachDB: Display version
CockroachDB: Recognize unique_rowid() as auto_increment
MS SQL: Fix editing rows with datetime column in primary key
MongoDB: Move to plugin
CSS: Add dark theme

https://www.adminer.org/#download