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 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
Web-based MySQL database management
Supports MySQL, PostgreSQL, SQLite, MS SQL, Oracle databases
Database browsing, table creation, editing
User management
Export data to CSV, JSON, XML, etc
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
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...
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...
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...
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...
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...
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,...
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...
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...
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,...
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...
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...
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(),...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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 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...
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...
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...
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...
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...
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...
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...
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,...
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...
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...
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,...
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...
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...