Skip to content

Adminer

Relational Databases

A single‑file PHP database management tool supporting multiple SQL and NoSQL databases

PHP Latest v5.4.2 · 3mo ago Security brief →

Features

  • Supports MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle and more via plugins
  • Provides a full‑featured web UI for data manipulation
  • Adminer Editor adds end‑user data editing capabilities

Recent releases

View all 3 releases →
v5.4.2 Security relevant
Security fixes
  • GHSA-q4f2-39gr-45jh — Avoid denial-of-service via version check (regression from 4.6.2)
Notable features
  • Pretty print JSON in edit
  • Support multiline generated values in alter table
  • Link //domain.tld values
Full changelog
  • Avoid denial-of-service via version check (https://github.com/vrana/adminer/security/advisories/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 Bug fix

Fixed MySQL routine definition display regression and prolonged query URLs in imports.

Full changelog
  • 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 Bug fix
Notable features
  • Allow specifying operator in search anywhere
  • Add section links in database overview
  • Warn about exceeded max_file_uploads in import
Full changelog
  • 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

Weekly OSS security release digest.

The CVE patches and breaking changes that affected production tools this week. One email, every Sunday.

No spam, unsubscribe anytime.

About

Stars
7,401
Forks
1,177
Languages
PHP CSS HTML

Beta — feedback welcome: [email protected]