Lightweight open-source web interfaces for managing MySQL and MariaDB databases without relying on phpMyAdmin.
Adminer is a PHP-based database management tool and multi-engine database client. It provides a web-based graphical interface for administering various relational and document database engines. The application is distributed as a single file to simplify installation and deployment on web servers. It supports customization through external stylesheets for visual themes and a plugin architecture to extend core functionality and system behaviors. The tool covers database schema administration, including the creation of views and management of foreign keys. It includes a SQL query editor with automatic completion for table and column names, as well as capabilities for editing table records and exporting database data. The user interface is localized through a dictionary-based system to support multiple languages.
Adminer is a lightweight, single-file web interface for managing MySQL and MariaDB databases that provides essential schema management and query editing, serving as a direct and efficient alternative to traditional management tools.
DbGate is a universal database management tool and SQL client that provides a unified interface for querying and administering multiple SQL and NoSQL databases. It functions as a multi-database administration GUI and SQL IDE, allowing users to write and execute scripts and manage database schemas. The project distinguishes itself by acting as an API client and explorer for REST, GraphQL, and OData services, enabling users to fetch and export data from these endpoints. It also serves as a data integration tool, facilitating the movement of records between diverse databases and file formats such as CSV, JSON, XML, and Excel. The platform covers broad capability areas including data visualization through ER diagrams and geospatial mapping, schema administration with structure comparison and model deployment, and secure connectivity via SSH tunneling and identity provider integration. It also supports automation through the generation of data migration and database operation scripts. The application is designed for multi-platform deployment, running as a native desktop application, a web-based service, or within Docker containers.
DbGate is a versatile, self-hostable database management platform that supports MySQL and MariaDB alongside many other engines, providing a modern interface for schema management, query execution, and data visualization.
Chat2DB is an AI-powered SQL client and multi-database GUI manager designed for managing various relational and NoSQL database systems. It serves as a visual database management tool and a natural language to SQL interface, allowing users to convert plain text descriptions into executable and optimized queries. The platform distinguishes itself through automated business intelligence capabilities, which include the generation of real-time data visualization dashboards and AI-driven data analysis from spreadsheets. To ensure data privacy, it supports secure local AI deployment, enabling large language models to run on-premises so that sensitive metadata is not uploaded to external servers. Broadly, the project covers database administration, visual schema design with entity-relationship diagramming, and data management utilities such as migration assistants and synthetic test data generation. It also provides team collaboration features, including role-based access control and workspace synchronization. The software supports flexible deployment as either a standalone local desktop application or a centralized web-based server.
Chat2DB is a comprehensive database management tool that supports MySQL and MariaDB with a modern interface, schema management, and query execution, though it is primarily designed as a multi-database client rather than a direct phpMyAdmin replacement.
Rainfrog is a terminal-based database client that connects to multiple database engines, combining schema browsing, interactive SQL query execution, and inline data editing into a single terminal interface. It provides a tree navigator for exploring tables, columns, and indexes, and an inline cell editor that automatically constructs and executes the necessary UPDATE statements when a cell value is changed. The application also supports modal Vim-style keyboard shortcuts for cursor movement and editing, making it usable entirely from the keyboard. Query results are fetched in chunks and paginated on demand, allowing smooth scrolling through large datasets without overwhelming the terminal. System metadata is cached at connection time to speed up schema tree navigation, and the user interface is built on a retained-mode widget tree that renders via a framebuffer with mouse and keyboard event handling. Keybindings, display settings, and mouse capture behavior are all configurable through a YAML file loaded at startup. Connections can be configured using connection strings or individual parameters such as host, port, and credentials. The client supports saving frequently used SQL queries as named favorites for quick replay and can export query results or entire tables to CSV files saved to the system downloads directory.
This is a terminal-based database client rather than a web-based interface, making it a different category of tool than the browser-accessible management platform you are seeking.
ChartDB is a database schema visualizer and entity-relationship diagramming platform designed to help developers understand, design, and document complex data architectures. It functions as a visual workspace where users can create and modify database schemas, define table attributes, and map foreign key relationships. By parsing database metadata or SQL scripts, the tool generates interactive diagrams that provide a clear overview of structural interdependencies and data associations. The platform distinguishes itself through its focus on automated documentation and schema synchronization. It supports programmatic diagram generation and scheduled background tasks that refresh visual representations to reflect changes in the underlying database structure. This ensures that technical documentation remains aligned with the live schema, while features like dependency mapping and relationship cardinality visualization provide deeper insights into how data entities interact. Beyond visualization, the tool facilitates schema portability by converting diagrams into standard database markup scripts, enabling version control and migration across different environments. Users can manage their workspace through automated layout engines, grid alignment, and filtering tools, or export diagrams as images for stakeholder sharing. The platform also supports embedding interactive diagrams into external documentation and offers containerized self-hosting options for teams requiring private infrastructure and data sovereignty.
This tool is a schema visualizer and ERD designer rather than a general-purpose database management interface for executing queries and managing data records.
Prisma is a type-safe database object-relational mapper that uses a declarative schema to map data models to relational and document databases. It provides a unified toolkit for data access, combining a database driver with tools for schema management and record manipulation. The project features a multi-database driver that standardizes interactions across PostgreSQL, MySQL, and MongoDB. It includes a system for tracking and applying structural schema migrations across different environments and a graphical user interface for browsing and editing database records. The system ensures data integrity through static type generation and a type-safe client, allowing for query execution with automatic type checking. It translates high-level data modeling into physical database tables or collections via a declarative schema definition.
Prisma is an ORM and database toolkit designed for application development rather than a standalone web-based administration interface for managing MySQL or MariaDB servers.
SQLiteStudio is an open-source graphical tool for browsing, editing, and managing SQLite database files. It combines a full-featured SQL editor with syntax highlighting, a visual database schema designer for creating entity-relationship diagrams, and a plugin-based extensibility platform that allows adding custom functionality through C/C++, JavaScript, Tcl, or Python. The application distinguishes itself through its multi-language scripting engine, which embeds JavaScript, Tcl, and Python interpreters to enable user-defined functions and scripts within SQL queries. It supports encrypted database access using multiple cipher formats, drag-and-drop SQL generation for creating SELECT or UPDATE statements, and a grid-based data editing interface with inline cell editing, filtering, and selective commit or rollback of changes. The MDI document management system organizes database windows for simultaneous editing, while the plugin architecture allows extending core functionality through shared libraries. Beyond its core database management capabilities, SQLiteStudio provides comprehensive data import and export across formats including CSV, JSON, XML, HTML, SQL, and PDF. It includes tools for data population with test data generation, cross-table string search, and cross-database object copying or moving. The SQL editor offers automatic code completion, continuous syntax analysis, query history browsing, and SQL formatting with configurable options. Users can also load external SQLite extension libraries and create custom collation sequences or SQL functions.
This is a desktop-based GUI application for managing local SQLite files, which does not provide the web-based interface or the MySQL/MariaDB support required for your server-side database management needs.
Mathesar is a no-code database manager and PostgreSQL GUI that provides a visual interface for managing relational database structures and records. It functions as a low-code data platform for administering schemas, tables, and relationships without the need to write manual SQL commands. The platform allows for the creation of shareable forms to collect data and the management of file attachments linked directly to database records. It includes a PostgreSQL administration tool for controlling database roles, user permissions, and data validation rules. The system covers relational data modeling and visual database management, enabling users to link tables and query data through a visual builder. It provides capabilities for importing and exporting data, formatting column displays, and managing record associations via a spreadsheet-like interface.
This tool is a visual database manager and no-code platform designed specifically for PostgreSQL, making it incompatible with the requested MySQL and MariaDB requirements.