xnoire666/db-diff

Laravel artisan command that diffs two MySQL databases and generates SQL files for the missing tables, views, columns, and mismatched column properties.

v0.1.0 2026-05-18 09:27 UTC

Requires

• php: ^8.0
• illuminate/console: ^9.0|^10.0|^11.0|^12.0
• illuminate/database: ^9.0|^10.0|^11.0|^12.0
• illuminate/filesystem: ^9.0|^10.0|^11.0|^12.0
• illuminate/support: ^9.0|^10.0|^11.0|^12.0

MIT

• rickyx12

• database
• mysql
• schema
• sync
• diff
• laravel
• artisan

Published on Packagist.org on 2026-05-18 09:35 UTC

README

Laravel artisan command that diffs two MySQL databases and generates SQL files describing what the second one is missing — perfect for syncing a staging schema against production.

Install

composer require xnoire666/db-diff

Laravel auto-discovers the service provider — no manual registration needed.

Configure

Publish the config file:

php artisan vendor:publish --tag=db-diff-config

This creates config/db-diff.php. Then set the connection details in your application's .env:

DB_DIFF_MYSQL1_HOST=
DB_DIFF_MYSQL1_DATABASE=
DB_DIFF_MYSQL1_USERNAME=
DB_DIFF_MYSQL1_PASSWORD=

DB_DIFF_MYSQL2_HOST=
DB_DIFF_MYSQL2_DATABASE=
DB_DIFF_MYSQL2_USERNAME=
DB_DIFF_MYSQL2_PASSWORD=

• mysql1 = the source (source of truth)
• mysql2 = the target being compared against the source

Optional keys: DB_DIFF_MYSQL{1,2}_CHARSET, DB_DIFF_MYSQL{1,2}_COLLATION, and DB_DIFF_OUTPUT_DISK (defaults to local).

Run

php artisan db:diff

Generates the following SQL files in storage/app/ (or whichever disk you configured):

File	What it contains
missing_tables.sql	CREATE TABLE IF NOT EXISTS for tables that exist in mysql1 but not mysql2
missing_views.sql	CREATE OR REPLACE VIEW for views missing in mysql2
missing_columns.sql	ALTER TABLE ... ADD COLUMN for columns missing in mysql2
mismatch_column_props.sql	ALTER TABLE ... MODIFY COLUMN for columns whose type, nullability, default, or extra differs

Review the generated SQL before running it against mysql2.

Requirements

• PHP ^8.0
• Laravel 9, 10, 11, or 12
• Both connections must be MySQL (the command uses SHOW TABLES / SHOW CREATE TABLE)

License

MIT