Adminer

Adminer

Adminer is an open source database management tool for managing MySQL, PostgreSQL, SQLite, MS SQL, and Oracle databases. It provides a simple GUI for database administration tasks.
Adminer image
database administration mysql postgresql sqlite mssql oracle

Adminer: Open Source Database Management Tool

Adminer is an open source database management tool for managing MySQL, PostgreSQL, SQLite, MS SQL, and Oracle databases. It provides a simple GUI for database administration tasks.

What is Adminer?

Adminer is an open source database management tool for managing MySQL, PostgreSQL, SQLite, MS SQL, and Oracle databases. It provides a simple graphical user interface for carrying out database administration tasks that would otherwise require knowledge of SQL commands.

Some key features of Adminer include:

  • Support for multiple database engines like MySQL, MariaDB, PostgreSQL, SQLite, MS SQL Server, and Oracle
  • Ability to manage databases, tables, views, triggers, procedures, etc.
  • Editing support for records, structures, indexes, foreign keys, etc.
  • SQL command interface for advanced operations
  • User management capabilities
  • Lightweight and fast interface requiring no database configuration
  • MIT license making it free to use

Overall, Adminer makes database management easier for developers and admins by providing an intuitive way to handle common tasks through an easy-to-use web interface. With support for many databases and platforms, it's a useful addition to any development toolkit.

Adminer Features

Features

  1. Web-based MySQL database management
  2. Supports MySQL, PostgreSQL, SQLite, MS SQL, Oracle databases
  3. Database browsing, table creation, editing
  4. User management
  5. Export data to CSV, JSON, XML, etc
  6. Plugin system for extending functionality

Pricing

  • Open Source

Pros

Lightweight and fast

Easy to use interface

Cross-platform and database engine agnostic

Open source with active development

Requires only PHP and web server

Cons

Not as full-featured as phpMyAdmin

Limited user management capabilities

No graphical database design features

Potential security issues if not configured properly


The Best Adminer Alternatives

Top Development and Database Management and other similar apps like Adminer


DBeaver icon

DBeaver

DBeaver is a free, open source universal database tool for developers, database administrators, analysts, and all people who need to work with databases. It supports all major databases including MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Derby, etc.Some key features of DBeaver include:Powerful SQL...
DBeaver image
Sequel Pro icon

Sequel Pro

Sequel Pro is a feature-rich database management application for macOS exclusively designed for working with MySQL databases. It provides a graphical user interface that allows users to easily connect to local & remote MySQL databases, view & modify database structure and data, import & export data, run SQL queries, and...
Sequel Pro image
MySQL Workbench icon

MySQL Workbench

MySQL Workbench is a visual database design tool developed by Oracle that integrates SQL development, administration, database design, creation and maintenance into a single integrated development environment for the MySQL database system.Key features include:Visual database design and modeling with integrated SQL development for MySQL databasesSupport for reverse and forward engineering...
MySQL Workbench image
HeidiSQL icon

HeidiSQL

HeidiSQL is a popular free and open source database management tool for Windows that allows you to manage MySQL, MariaDB, Microsoft SQL Server and PostgreSQL databases. It provides a simple and intuitive graphical user interface for database administration tasks.Some key features of HeidiSQL include:Intuitive browser-style interface for browsing database objects...
HeidiSQL image
PhpMyAdmin icon

PhpMyAdmin

phpMyAdmin is a free and open source administration tool written in PHP that allows users to manage MySQL and MariaDB databases through a web interface. Some key features include:Intuitive web interface to perform database operations like creating and editing databases, tables, fields, relations, indexes, users, permissions etc.Import and export functionality...
PhpMyAdmin image
DataGrip icon

DataGrip

DataGrip is a multi-engine database IDE developed by JetBrains. As the name suggests, it allows working with different types of databases through a unified graphical user interface.Some of the key features of DataGrip include:Supports a wide range of relational (e.g. MySQL, PostgreSQL, Oracle, SQL Server, etc.) and non-relational (e.g. MongoDB,...
DataGrip image
Sequel Ace icon

Sequel Ace

Sequel Ace is a feature-rich graphical database manager application specifically designed for macOS. As an open source tool, Sequel Ace provides users with a powerful interface to connect to MySQL, MariaDB, SQLite, Microsoft SQL Server, PostgreSQL, and other database servers.Some key features of Sequel Ace include:Intuitive user interface for browsing...
Sequel Ace image
PSequel icon

PSequel

PSequel is an open-source database management application that provides a graphical user interface and component library for PostgreSQL. Developed by PSequel Corporation, it is available for Windows, macOS and Linux.Some key features of PSequel include:Visual Query Builder - Build complex SQL queries easily with a drag-and-drop interfaceDatabase Designer - Visually...
PSequel image
Postico icon

Postico

Postico is a powerful and intuitive PostgreSQL client for macOS that makes working with PostgreSQL databases easy and enjoyable. It allows users to connect to multiple PostgreSQL server instances, view and browse database schema and data, run SQL queries with syntax highlighting and auto-completion, export query results in different formats,...
Postico image
Toad Edge icon

Toad Edge

Toad Edge is a cross-platform database management and development software from Quest Software. It is designed to handle various databases including MySQL, Oracle, SQL Server, PostgreSQL, and MariaDB.Some key features of Toad Edge include:Writing, editing, and executing SQL queriesVisual query building with drag-and-drop functionalityDatabase schema compare and synchronizationDatabase administration tools...
Toad Edge image
Phpminiadmin icon

Phpminiadmin

phpMiniAdmin is an open source web application written in PHP that allows administrators to manage MySQL databases through a web interface. It provides an easy-to-use way for web developers and database administrators to execute MySQL queries, manage databases, tables, columns, relations, indexes, users, permissions, and more without needing direct access...
Phpminiadmin image
PDOCrud icon

PDOCrud

PDOCrud is an open source PHP library that simplifies database CRUD operations when using PDO. It abstracts away much of the repetitive code needed when working with databases in PHP.Some key features of PDOCrud include:Easy connect to MySQL, PostgreSQL, SQLite, SQL Server, etc. databases using PDOSimple high-level methods like find(),...
PDOCrud image
Chrome MySQL Admin icon

Chrome MySQL Admin

Chrome MySQL Admin is a Chrome extension that provides a user interface within the Chrome browser to manage MySQL databases. It allows you to connect to local or remote MySQL servers to perform administration tasks without needing additional database management software.Key features include:Execute SQL queries on databasesManage MySQL users and...
Chrome MySQL Admin image
Model Xtractor icon

Model Xtractor

Model Xtractor is an innovative software solution that utilizes cutting-edge computer vision and artificial intelligence to extract usable 3D models from images and video footage. It serves as an accessible alternative to expensive and complex photogrammetry rigs for indie developers, hobbyists, and creators seeking high-quality 3D assets.At its core, Model...
Model Xtractor image
PopSQL icon

PopSQL

PopSQL is a cloud-based SQL editor that enables teams to collaborate on exploring and analyzing data. It provides an intuitive, browser-based interface for writing queries, visualizing results, and sharing data insights.Key features of PopSQL include:Collaborative editing - Multiple users can query the same datasets, share queries and visualizations, comment, and...
PopSQL image
ElectroCRUD icon

ElectroCRUD

ElectroCRUD is an open-source rapid application development tool that auto-generates admin interfaces for relational databases. It integrates deeply with PostgreSQL, MySQL, and SQLite to introspect the schema and generate a feature-rich admin UI including:Lists, create, edit, and view forms for database tablesSorting, filtering, searching, and pagination for listsInput validation and...
ElectroCRUD image
DbNinja icon

DbNinja

DbNinja is an open-source database schema comparison and synchronization tool designed for use with MySQL, MariaDB, PostgreSQL, SQLite, and Microsoft SQL Server databases. It provides a graphical user interface that allows you to easily compare two database schemas, identify differences in tables, columns, indexes, foreign keys, triggers, and more.Some key...
DbNinja image
EMS SQL Manager for PostgreSQL icon

EMS SQL Manager for PostgreSQL

EMS SQL Manager for PostgreSQL is a comprehensive database management tool designed specifically for PostgreSQL databases. It provides a graphical user interface and a wide range of features to make managing and working with PostgreSQL databases easier.Key features of EMS SQL Manager for PostgreSQL include:Intuitive visual database design and data...
EMS SQL Manager for PostgreSQL image
Datazenit icon

Datazenit

Datazenit is a business intelligence and analytics software that provides interactive data visualization and reporting capabilities for businesses. Its key features include:Drag-and-drop interface to build dashboards, charts, pivot tables without codingConnectors to integrate data from SQL, NoSQL databases, cloud apps like Google Analytics, social media APIs among various sourcesAd hoc...
Datazenit image
PHPLiteAdmin icon

PHPLiteAdmin

PHPLiteAdmin is a web application written in PHP that allows you to easily manage SQLite databases. It provides a simple graphical interface to view, browse, search, and edit the data in SQLite database files over the web through a browser. Some key features:Browse and search tablesView, edit, add and delete...
PHPLiteAdmin image
DbDesigner.net icon

DbDesigner.net

DbDesigner.net is a free, open source web-based database modeling and design tool. It enables users to visually model, design, and manage databases without coding. Key features include:Intuitive drag and drop interface for designing database models visuallySupports major database engines like MySQL, PostgreSQL, SQL Server, Oracle, SQLite, and moreAbility to generate...
DbDesigner.net image
PostgreSQL Maestro icon

PostgreSQL Maestro

PostgreSQL Maestro is a comprehensive database administration tool for PostgreSQL that provides a user-friendly graphical interface for managing PostgreSQL databases. Some of the key features include:Server monitoring - tracks vital PostgreSQL server metrics like connections, transactions, queries, locks, streaming replicas, and more.Backup and restore - automates backup jobs to popular...
PostgreSQL Maestro image
XCRUD icon

XCRUD

xCRUD is an open-source rapid application development tool that helps developers build CRUD (create, read, update, delete) web applications for relational databases in minutes without writing any code. It's a low-code framework that generates a full admin interface and REST API for managing database content out of the box.With an...
XCRUD image
MyLittleAdmin icon

MyLittleAdmin

myLittleAdmin is an open-source web-based administration panel and hosting control panel. It provides a graphical interface and automation tools designed to simplify website and server management.With myLittleAdmin you can manage domains, websites, web hosting accounts, FTP accounts, databases, emails and more from one central dashboard. It allows you to monitor...
Pgweb icon

Pgweb

pgweb is an open-source web-based graphical user interface that allows users to easily access and browse PostgreSQL databases. It provides a simple yet powerful way to explore PostgreSQL databases without needing to install additional software or connect from the command line.Some key features of pgweb include:Intuitive browser-based interface for browsing...
Pgweb image
PhpMyBackupPro icon

PhpMyBackupPro

PhpMyBackupPro is an open source backup and recovery software designed specifically for MySQL databases. It provides an intuitive interface to easily configure and schedule automatic backups of your MySQL databases to various storage locations including FTP, SFTP, SSH, WebDAV, Amazon S3, and Dropbox.Some key features include:Secure 128-bit AES encryption of...
PhpMyBackupPro image
DBKiss icon

DBKiss

DBKiss is an open-source database modeling and design tool used for visually mapping out relational databases. It provides an intuitive graphical interface that allows users to diagram database tables, columns, relationships, keys, indexes, and other components of a database schema.Some key features of DBKiss include:Graphical database design - Visually design...
DBKiss image
Phppgadmin icon

Phppgadmin

Phppgadmin is a feature-rich web-based administration tool for PostgreSQL databases. It provides a graphical interface that allows users to easily manage PostgreSQL databases, users, tables, indexes, and other database objects without needing advanced SQL knowledge.Some key features of Phppgadmin include:Intuitive browser-based interface for managing PostgreSQL databasesCreate, edit, drop and rename...
Phppgadmin image
SQL Buddy icon

SQL Buddy

SQL Buddy is an open-source, web-based SQL query and administration tool for MySQL and PostgreSQL databases. It allows users to connect to existing databases, write and execute SQL queries, manage databases and tables, and more through an intuitive graphical user interface.Some key features of SQL Buddy include:Connect to MySQL and...
SQL Buddy image
Sypex Dumper icon

Sypex Dumper

Sypex Dumper is a free, open source database backup and recovery software designed specifically for MySQL databases. It provides an easy way to backup MySQL databases by automating the backup process and allowing the user to setup scheduled backups.Some key features of Sypex Dumper include:Automated backup scheduling - Set specific...
Sypex Dumper image
Panda-Sql icon

Panda-Sql

Panda-Sql is an open-source Python library that helps Python developers work with SQL databases more efficiently. It provides an intuitive and Pythonic interface for building SQL queries and manages all the database connections behind the scenes.Some key features of Panda-Sql include:Build SQL queries in Python using straightforward method calls, without...
Panda-Sql image
SIDU icon

SIDU

SIDU is an open-source, self-hosted knowledge base and documentation software designed for teams to create, organize, and share institutional knowledge across the organization. Here are some of the key capabilities of SIDU:Powerful full-text search allows users to quickly find answers and documentationCustomizable templates for knowledge articles, how-tos, FAQs, release notes,...
SIDU image
MySql Lite Administrator icon

MySql Lite Administrator

MySql Lite Administrator is a free, open source, lightweight graphical user interface tool that allows you to easily manage and administer MySql Lite databases. It provides an intuitive way to connect to MySql Lite databases, browse database structures and data, execute SQL queries, manage database users and their privileges, export...
MySql Lite Administrator image
SQLPro for Postgres icon

SQLPro for Postgres

SQLPro for Postgres is a feature-rich SQL editor and database manager designed specifically for working with PostgresSQL databases. It provides a streamlined, intuitive interface on macOS for writing and executing queries, browsing database objects, importing and exporting data, and more.Key features include:Auto-completion of SQL keywords, Postgres functions, table and column...
SQLPro for Postgres image
Sequeler icon

Sequeler

Sequeler is an open source database administration and development tool designed specifically for PostgreSQL databases. It provides an intuitive graphical user interface for managing PostgreSQL databases and working with database objects.Some of the key features of Sequeler include:Ability to connect to local or remote PostgreSQL database serversBrowse and search databases,...
Sequeler image
MonoQL icon

MonoQL

MonoQL is an open-source SQL query engine that allows developers to execute SQL queries on various data sources. It was created by the team at SingleStore to provide a unified SQL interface across databases, object stores, files, and more.Some key features and benefits of MonoQL include:Unified SQL interface - Write...
MonoQL image
DataBread icon

DataBread

DataBread is a business intelligence and data visualization platform designed for non-technical users. It enables anyone in an organization to connect data from multiple sources like SQL, NoSQL databases, SaaS applications etc. and create interactive dashboards and reports to track KPIs and gain valuable insights.Some key features of DataBread include:Intuitive...
DataBread image