A complete workspace
Tree of sessions, databases and objects with sizes and filters; Host, Database, Table, Data and Query tabs, just like HeidiSQL.
myDBmanager brings the proven HeidiSQL experience to the browser — object tree, query editor, data grid and table editor — and adds what was missing: multiple users, centralized encrypted connections, auditing and access from anywhere. Install it once on a server and your whole team works from the browser.
Connects to all of these — and to any database with an ODBC driver
Desktop database managers are great — until you have to install them on every machine, pass connections around and control who can access what. myDBmanager keeps the workflow DBAs already know and takes care of the rest.
From quick queries to server administration, all in one place — with the same logic as the most popular SQL clients.
Tree of sessions, databases and objects with sizes and filters; Host, Database, Table, Data and Query tabs, just like HeidiSQL.
Syntax highlighting, autocomplete, run all, the selection or the current statement (F9), EXPLAIN, multiple result tabs and SQL formatting.
Paging, filters, multi-column sorting, in-grid editing, NULL, ENUM/SET, foreign keys and long texts — every change becomes SQL in the log.
Columns, indexes, foreign keys, CHECKs and partitions, with live CREATE/ALTER code generated for each server.
16 grid formats (CSV, JSON, XML, Markdown, SQL…), .sql, .gz or .zip dumps, direct copy to another server and step-by-step SQL/CSV import.
Everyone gets their own connections, queries, history, tabs and preferences. The master user adds the team and sets the rules.
AES-256-GCM encrypted passwords, CSRF protection, allowed and blocked servers, password rules, reCAPTCHA and an audit log.
One password-protected file with connections, queries and preferences; restore by merging or replacing. Automatic daily copies.
English and Portuguese out of the box. Create new translations inside the app, with an editor, a flag and number/date formats.
Logo, icons, colors, fonts, login texts and light or dark theme, configurable in minutes.
Accounts, passwords, limits, SSL and privileges — global, per database, table, column and routine (MySQL/MariaDB).
Progress OpenEdge in the format used by Datasul/TOTVS, with multiple databases in the tree, ROWID editing and charset conversion.
Real screenshots, no retouching.
Write SQL with autocomplete and helpers, run it with F9 and get results in tabs. Everything is recorded in the SQL log.
Browse, filter and edit records right in the grid, with foreign keys, special types and one-click export.
Change columns, indexes and keys visually: the right SQL for each server is generated for you.
Sessions, recent queries and this month’s numbers as soon as you sign in.
Light or dark theme for each user, always in your brand colors.
myDBmanager did not start from scratch: it builds on decades of experience from open-source projects that millions of professionals use every day.
A reference among desktop database managers. It gave us the working model — sessions, tree, Host/Database/Table/Data/Query tabs — plus the list of SQL functions, data types and keywords.
The best-known web manager in the MySQL world. It is the basis for the privilege descriptions and collations.
Bootstrap, CodeMirror, Font Awesome, SweetAlert2, Tom Select, sql-formatter and PHPMailer: mature libraries, each under its own license.
Enable in PHP only the extensions for the databases you use.
Requirements| Database | PHP extension | Highlights |
|---|---|---|
| MySQL / MariaDB | pdo_mysql | Full feature set: visual routine and event editors, users and privileges, maintenance |
| PostgreSQL | pdo_pgsql | Schemas as databases, sequences, views and routines |
| SQLite | pdo_sqlite | Per-user files; the editor rebuilds the table when needed |
| SQL Server | pdo_sqlsrvpdo_dblib | Schemas, procedures, functions and triggers |
| Oracle | oci8pdo_oci | PL/SQL with “/”, DBMS_OUTPUT, EXPLAIN PLAN and ROWID editing |
| Firebird / InterBase | pdo_firebird | SET TERM, domains, exceptions, generators and packages |
| IBM Db2 (LUW) | pdo_ibmodbc | SYSCAT catalog, SQL PL, RUNSTATS and REORG |
| Progress OpenEdge (Datasul) | odbcpdo_odbc | Multiple databases in the tree, ROWID and ISO-8859-1 conversion |
| Any ODBC database | odbcpdo_odbc | Structure from the ODBC catalog functions |
Runs on any hosting plan or server with a modern PHP. The app’s own database can be MySQL/MariaDB or a simple SQLite file.
Upload the folder to your server, for example /var/www/mydbmanager.
PHP needs to write to these folders:
chown -R www-data:www-data config storage uploads translationsOpen https://your-server/install/, choose MySQL or SQLite and the language, and create the master user.
Sign in, add your sessions (connections) and invite the team. Keep a copy of config/config.php.
; php.ini / .user.ini upload_max_filesize = 64M ; SQL/CSV uploads post_max_size = 64M max_execution_time = 300 ; long-running queries memory_limit = 512M ; large result sets # Ubuntu/Debian: most used extensions sudo apt install php8.3-mysql php8.3-pgsql php8.3-sqlite3 \ php8.3-mbstring php8.3-zip php8.3-gd php8.3-odbc
Free for personal and commercial use, under the GPL-2.0 license.
c26df957b3ddb8d944a1b0345fae0eb7a2534550b4ebab55e630b03fb128571bmyDBmanager is free and will stay that way. Donations help keep the website running, test new databases and spend more hours on new features.
Questions, suggestions, bug reports or partnership proposals: write to the address below.
contact@mydbmanager.com.br