PHPackages                             phlib/schemadiff - 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. phlib/schemadiff

ActiveLibrary[Database & ORM](/categories/database)

phlib/schemadiff
================

Schema Diff: Show difference between MySQL databases

2.1.0(1y ago)79.3k↓50%1LGPL-3.0PHPPHP ^8.1CI passing

Since Feb 2Pushed 1y ago4 watchersCompare

[ Source](https://github.com/phlib/schemadiff)[ Packagist](https://packagist.org/packages/phlib/schemadiff)[ Docs](https://github.com/phlib/schemadiff)[ RSS](/packages/phlib-schemadiff/feed)WikiDiscussions main Synced 1mo ago

READMEChangelog (7)Dependencies (3)Versions (9)Used By (0)

phlib/schemadiff
================

[](#phlibschemadiff)

[![Code Checks](https://camo.githubusercontent.com/da4da701df55f726fe073b6a06828459e7ab2c82db7e0af1968014cbbd886260/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f616374696f6e732f776f726b666c6f772f7374617475732f70686c69622f736368656d61646966662f636f64652d636865636b732e796d6c3f6c6f676f3d676974687562)](https://github.com/phlib/schemadiff/actions/workflows/code-checks.yml)[![Codecov](https://camo.githubusercontent.com/86031f0a35b07305f319e897d6f2b5849407d4542f15267f6efd8f2d2e72c5f7/68747470733a2f2f696d672e736869656c64732e696f2f636f6465636f762f632f6769746875622f70686c69622f736368656d61646966662e7376673f6c6f676f3d636f6465636f76)](https://codecov.io/gh/phlib/schemadiff)[![Latest Stable Version](https://camo.githubusercontent.com/ab93e6df02fc2bff8e7b2ca90e14135307caffd43c2f21ffe7a1840f2ffe3e38/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f762f70686c69622f736368656d61646966662e7376673f6c6f676f3d7061636b6167697374)](https://packagist.org/packages/phlib/schemadiff)[![Total Downloads](https://camo.githubusercontent.com/8b099fb1f1db8b63c375658d987c7c395d806d3ab84c603c8b6e8405df74e486/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f70686c69622f736368656d61646966662e7376673f6c6f676f3d7061636b6167697374)](https://packagist.org/packages/phlib/schemadiff)[![Licence](https://camo.githubusercontent.com/294ea06485d3ded7e5a3e2fa1a10f0e40ed7a973ace4a86eab226f5d3010a450/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f6c6963656e73652f70686c69622f736368656d61646966662e737667)](https://camo.githubusercontent.com/294ea06485d3ded7e5a3e2fa1a10f0e40ed7a973ace4a86eab226f5d3010a450/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f6c6963656e73652f70686c69622f736368656d61646966662e737667)

MySQL Schema Diff, a Symfony Console tool for displaying differeance between two schemas. This can be useful by showing differences between production and development. It's then up to the developer to create some kind of migration scripts.

Install
-------

[](#install)

Via Composer

Single project

```
$ composer require phlib/schemadiff
```

Globally

```
$ composer global require phlib/schemadiff
```

Command Line Usage
------------------

[](#command-line-usage)

If you install schemadiff globally

And add this to your PATH in your ~/.bash\_profile

```
export PATH=~/.composer/vendor/bin:$PATH
```

Then you can run schemadiff like this

```
$ schemadiff --help
$ schemadiff h=127.0.0.1,u=user,p=pass,D=db1 h=127.0.0.1,u=user,p=pass,D=db2
```

Otherwise run it from your project

```
$ ./vendor/bin/schemadiff --help
$ ./vendor/bin/schemadiff h=127.0.0.1,u=user,p=pass,D=db1 h=127.0.0.1,u=user,p=pass,D=db2
```

PHP Usage
---------

[](#php-usage)

```