Adminer is a web-based database management tool distributed as a single PHP file. It offers an alternative to larger administration applications while retaining extensive facilities for working with relational databases.
The application supports MySQL, MariaDB, PostgreSQL, SQLite, Microsoft SQL Server and Oracle Database, with additional database engines accessible through plugins. Users can browse database structures, manage tables and relationships, edit records and execute SQL statements.
Adminer provides facilities for importing and exporting data, managing users and privileges, configuring database objects and inspecting server processes. It supports generated columns, check constraints, routines and database-specific functionality. Its plugin system allows administrators to extend the interface and customise authentication, while CSS skins provide alternative appearances.
Security is a major focus. Adminer requires password-protected database connections and includes protections against brute-force login attempts. The application is straightforward to deploy, although access should still be restricted appropriately when installed on a publicly accessible server.
This is free and open source software.
Key Features
- Distributed as a single PHP file for straightforward deployment.
- Manage MySQL, MariaDB, PostgreSQL, SQLite, SQL Server and Oracle databases.
- Additional database engines supported through plugins.
- Create, modify and delete databases, tables, views and other objects.
- Manage indexes, foreign keys, triggers, procedures and functions.
- Browse, filter, insert, update and delete database records.
- Execute SQL statements with syntax highlighting.
- Import and export database structures and data.
- Manage database users, privileges and server processes.
- Support generated columns, check constraints and database-specific data types.
- Extend functionality through plugins and customise the interface with CSS skins.
- Available in numerous languages.
- Security features include password requirements and login rate limiting.
Website: www.adminer.org
Support:
Developer: Jakub Vrána
License: Apache License 2.0 or GNU General Public License v2.0
Adminer is written in PHP. Learn PHP with our recommended free books and free tutorials.
Related Software
| MySQL Tools | |
|---|---|
| DBeaver | Universal database tool |
| phpMyAdmin | MySQL web administration tool |
| NocoDB | Build databases as spreadsheets |
| MySQL Workbench | Complete visual database design tool |
| mycli | Command line interface for MySQL, MariaDB, and Percona |
| gh-ost | GitHub's Online Schema Migrations for MySQL |
| Beekeeper Studio | Cross-platform SQL editor and database manager |
| usql | Command-line database client |
| sqlit | lazygit of SQL databases |
| Harlequin | Easy, fast, and beautiful database client for the terminal |
| DbGate | Database manager for MySQL, PostgreSQL, MongoDB |
| Percona Toolkit | Essential command-line utilities for MySQL |
| SQuirreL SQL Client | Graphical SQL client written in Java |
| Adminer | Full-featured tool for managing content in MySQL database |
| dblab | Interactive client for PostgreSQL, MySQL, SQLite3, and more |
| Antares | SQL client based on Electron.js and Vue.js |
| XtraBackup | Backup utility for MySQL |
| innotop | Real-time, advanced investigation tool |
| SQLCheck | Detects common SQL anti-patterns |
| Skeema | Manage MySQL and MariaDB schema changes |
| Sequeler | Native Linux SQL client built in Vala and Gtk |
| orchestrator | High availability and replication management tool |
| OmniDB | Collaborative environment For database management |
Read our verdict in the software roundup.
 LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of recommended applications, including alternatives to popular proprietary software.We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our Linux resources to discover more. Know a useful free and open source Linux application we haven't covered? Suggest a program for inclusion. Has your software been featured on LinuxLinks? Display one of our Featured on LinuxLinks badges on your website or GitHub README. |
Please read our Comment Policy before commenting.