PHPackages delta-solutions/mysqltools - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Database & ORM](/categories/database) 4. / 5. delta-solutions/mysqltools ActiveLibrary[Database & ORM](/categories/database) delta-solutions/mysqltools ========================== Mysqltools is a tool to manage your mysql databases 1.0.8(2mo ago)1832MITPHP Since Apr 26Pushed 2mo ago1 watchersCompare [ Source](https://github.com/Delta-Solutions/mysqltools)[ Packagist](https://packagist.org/packages/delta-solutions/mysqltools)[ RSS](/packages/delta-solutions-mysqltools/feed)WikiDiscussions main Synced 1mo ago READMEChangelog (6)Dependencies (8)Versions (10)Used By (0) [![mysqltools](https://camo.githubusercontent.com/cb6be044978f9306f816b43759df9cfa262f7d418607c9be5f7981943c7301a8/68747470733a2f2f62616e6e6572732e6265796f6e64636f2e64652f6d7973716c746f6f6c732e706e673f7468656d653d6c69676874267061636b6167654d616e616765723d636f6d706f7365722b676c6f62616c2b72657175697265267061636b6167654e616d653d64656c74612d736f6c7574696f6e732532466d7973716c746f6f6c73267061747465726e3d617263686974656374267374796c653d7374796c655f31266465736372697074696f6e3d4d7973716c746f6f6c732b69732b612b636f6d6d616e642b6c696e652b746f6f6c2b746f2b636f6d706172652b64617461626173652b737472756374757265732b616e642b6261636b75702b7468656d266d643d312673686f7757617465726d61726b3d3026666f6e7453697a653d313030707826696d616765733d6461746162617365)](https://camo.githubusercontent.com/cb6be044978f9306f816b43759df9cfa262f7d418607c9be5f7981943c7301a8/68747470733a2f2f62616e6e6572732e6265796f6e64636f2e64652f6d7973716c746f6f6c732e706e673f7468656d653d6c69676874267061636b6167654d616e616765723d636f6d706f7365722b676c6f62616c2b72657175697265267061636b6167654e616d653d64656c74612d736f6c7574696f6e732532466d7973716c746f6f6c73267061747465726e3d617263686974656374267374796c653d7374796c655f31266465736372697074696f6e3d4d7973716c746f6f6c732b69732b612b636f6d6d616e642b6c696e652b746f6f6c2b746f2b636f6d706172652b64617461626173652b737472756374757265732b616e642b6261636b75702b7468656d266d643d312673686f7757617465726d61726b3d3026666f6e7453697a653d313030707826696d616765733d6461746162617365) Mysqltools ========== [](#mysqltools) [![Latest Version on Packagist](https://camo.githubusercontent.com/ce96870b3603cac84192c696f16a70274a16efbf6dfb96e8ab4e70de0fb3339c/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f762f64656c74612d736f6c7574696f6e732f6d7973716c746f6f6c732e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/delta-solutions/mysqltools)[![Downloads](https://camo.githubusercontent.com/439b541e741af1ff9793bed31229c2e22810e23c3a34eac87bd5fc743046c0e6/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f64656c74612d736f6c7574696f6e732f6d7973716c746f6f6c732e7376673f7374796c653d666c61742d737175617265)](https://camo.githubusercontent.com/439b541e741af1ff9793bed31229c2e22810e23c3a34eac87bd5fc743046c0e6/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f64656c74612d736f6c7574696f6e732f6d7973716c746f6f6c732e7376673f7374796c653d666c61742d737175617265) Mysqltools is a versatile command-line tool designed to streamline the management of your MySQL databases. With its user-friendly interface and powerful features, this tool simplifies tasks such as comparing database structures and creating backups. Use case -------- [](#use-case) Managing database structures can be challenging, especially when you prefer creating databases in your favorite SQL tool rather than using migrations. Mysqltools solves this problem by allowing you to compare the structure of a source database with a target database. You can easily retrieve SQL statements to synchronize the structures, ensuring consistency between your development and live databases. Requirements ------------ [](#requirements) Mysqltools is a command-line tool that has been extensively tested on both macOS desktops and Linux servers. Its compatibility with these platforms ensures a seamless experience, providing you with a reliable and efficient solution for your database management needs. Installation ------------ [](#installation) ``` composer global require delta-solutions/mysqltools ``` Usage ----- [](#usage) Once mysqltools is installed you can get an overview of all the commands by running the `mysqltools` command. You will see this welcome screen. ### The welcome screen [](#the-welcome-screen) [![Mysqltools home screen](brand/brand.png?raw=true "Mysqltools home screen")](brand/brand.png?raw=true) ### Backup a database [](#backup-a-database) command to run: `mysqltools mysql:backup` or `mt mb` This command dumps the structure of your database to an SQL file and stores the data from the database in .csv files. The resulting files are stored in your Downloads folder. If you only want to create a backup of the structure without the data, you can add the --nodata option. If you want to create a backup of only the structure you can add the --nodata option ### Compare two database structures [](#compare-two-database-structures) command to run: `mysqltools mysql:compare` or `mt mc` This command compares the structure of two databases and outputs the differences between the source and target databases in an SQL file. The resulting file is stored in your Downloads folder. ### Create an ssh tunnel from your local machine to a mysql server [](#create-an-ssh-tunnel-from-your-local-machine-to-a-mysql-server) command to run: `mysqltools mysql:tunnel` or `mt mt` This command sets up an SSH tunnel from your local machine to a MySQL server. It is useful when you want to connect your application over an SSH tunnel to your database server. By using this command, you can choose a specific port (e.g., 13306) to connect to your database over SSH. You can then configure your application to connect to the local port as if it were connecting to localhost. This allows your application to reach the database server even if it's located on another location that requires an SSH tunnel. ### Health Score 42 — FairBetter than 90% of packages Maintenance85 Actively maintained with recent releases Popularity15 Limited adoption so far Community7 Small or concentrated contributor base Maturity50 Maturing project, gaining track record Bus Factor1 Top contributor holds 100% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Every ~130 days Recently: every ~254 days Total 9 Last Release 79d ago ### Community Maintainers ![](https://www.gravatar.com/avatar/0a5498402f8114208ae9befe10cb82ea43e33e256ce22c96ff0ec97cb6c87fc5?d=identicon)[dietercoopman](/maintainers/dietercoopman) --- Top Contributors [![dietercoopman](https://avatars.githubusercontent.com/u/4672752?v=4)](https://github.com/dietercoopman "dietercoopman (32 commits)") ### Code Quality Code StylePHP CS Fixer ### Embed Badge ![Health badge](/badges/delta-solutions-mysqltools/health.svg) ``` [![Health](https://phpackages.com/badges/delta-solutions-mysqltools/health.svg)](https://phpackages.com/packages/delta-solutions-mysqltools) ``` ### Alternatives [laravel/framework The Laravel Framework. 34.6k509.9M17.0k](/packages/laravel-framework)[sylius/sylius E-Commerce platform for PHP, based on Symfony framework. 8.4k5.6M651](/packages/sylius-sylius)[shopware/platform The Shopware e-commerce core 3.3k1.5M3](/packages/shopware-platform)[sulu/sulu Core framework that implements the functionality of the Sulu content management system 1.3k1.3M152](/packages/sulu-sulu)[laravel-zero/framework The Laravel Zero Framework. 3371.4M369](/packages/laravel-zero-framework)[rector/rector-src Instant Upgrade and Automated Refactoring of any PHP code 134391.5k12](/packages/rector-rector-src) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)