PHPackages                             zaryabakhtar/laravel-db-sync - 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. zaryabakhtar/laravel-db-sync

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

zaryabakhtar/laravel-db-sync
============================

Sync database down.

015PHP

Since Mar 15Pushed 2y agoCompare

[ Source](https://github.com/Zaryabakhtar/laravel-db-sync)[ Packagist](https://packagist.org/packages/zaryabakhtar/laravel-db-sync)[ RSS](/packages/zaryabakhtar-laravel-db-sync/feed)WikiDiscussions main Synced 1mo ago

READMEChangelogDependenciesVersions (1)Used By (0)

Community
---------

[](#community)

There is a Discord community.  For quick help, ask questions in the appropriate channel.

Laravel DB Sync
===============

[](#laravel-db-sync)

[![DB Dync](https://repository-images.githubusercontent.com/506690782/a5b01352-4869-4e6d-8e46-d44e93c960df)](https://repository-images.githubusercontent.com/506690782/a5b01352-4869-4e6d-8e46-d44e93c960df)

Introduction
------------

[](#introduction)

Sync remote database to a local database

> A word of warning you should only sync a remote database into a local database if you have permission to do so within your organisation's policies. I'm syncing during early phases of development where the data is largely test data and not actual customer data.

Connection can be made over SSH or using a remote MySQL connection.

Install
-------

[](#install)

Install the package.

```
composer require dcblogdev/laravel-db-sync
```

Config
------

[](#config)

You can publish the config file with:

```
php artisan vendor:publish --provider="Dcblogdev\DbSync\DbSyncServiceProvider" --tag="config"

```

.env
----

[](#env)

Set the remote database credentials in your .env file

When using SSH Add:

```
REMOTE_USE_SSH=true
REMOTE_SSH_PORT=22
REMOTE_SSH_USERNAME=
REMOTE_DATABASE_HOST=

REMOTE_DATABASE_USERNAME=
REMOTE_DATABASE_PORT=3306
REMOTE_DATABASE_NAME=
REMOTE_DATABASE_PASSWORD=
REMOTE_DATABASE_IGNORE_TABLES=''

REMOTE_REMOVE_FILE_AFTER_IMPORT=true
REMOTE_IMPORT_FILE=true

```

For only MySQL remote connections:

```
REMOTE_DATABASE_HOST=
REMOTE_DATABASE_USERNAME=
REMOTE_DATABASE_PORT=3306
REMOTE_DATABASE_NAME=
REMOTE_DATABASE_PASSWORD=
REMOTE_DATABASE_IGNORE_TABLES=''

REMOTE_REMOVE_FILE_AFTER_IMPORT=true
REMOTE_IMPORT_FILE=true

```

Set a comma seperate list of tables NOT to export in `REMOTE_DATABASE_IGNORE_TABLES`

To generate a SQL with a custom file name `REMOTE_DEFAULT_FILE_NAME`

To specify a different local database connection:

```
LOCAL_TARGET_CONNECTION=different_mysql_connection

```

Set the mysql command path:

```
LOCAL_MYSQL_PATH=/usr/bin/mysql

```

For only mysqldump:

```
REMOTE_MYSQLDUMP_SKIP_TZ_UTC=true

```

Usage
-----

[](#usage)

To export a remote database to OVERRIDE your local database by running:

```
php artisan db:production-sync
```

Provide a filename for export on the fly by passing the option --filename, remember to provide .sql

```
php artisan db:production-sync --filename=other.sql
```

Run the command without attempting to export:

```
php artisan db:production-sync --test
```

Aliases
-------

[](#aliases)

There are shortcuts that can be used:

`-T` = will use `--test``F` = will use `--filename`

Alternative name
----------------

[](#alternative-name)

When connecting to a none production database, say a staging database you can choose to use this alternative name:

`db:remote-sync` may be used instead of `db:production-sync`

###  Health Score

14

—

LowBetter than 2% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity6

Limited adoption so far

Community13

Small or concentrated contributor base

Maturity19

Early-stage or recently created project

 Bus Factor1

Top contributor holds 76.2% 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.

### Community

Maintainers

![](https://www.gravatar.com/avatar/ce4bf17efdb92840dfddd780a090678c911d5103a51c1d0bd1e0f257ab51ff99?d=identicon)[zaryabakhtar](/maintainers/zaryabakhtar)

---

Top Contributors

[![dcblogdev](https://avatars.githubusercontent.com/u/1018170?v=4)](https://github.com/dcblogdev "dcblogdev (48 commits)")[![Zaryabakhtar](https://avatars.githubusercontent.com/u/42775803?v=4)](https://github.com/Zaryabakhtar "Zaryabakhtar (6 commits)")[![thursdaydan](https://avatars.githubusercontent.com/u/8914312?v=4)](https://github.com/thursdaydan "thursdaydan (3 commits)")[![Witti](https://avatars.githubusercontent.com/u/80333?v=4)](https://github.com/Witti "Witti (1 commits)")[![xfolder](https://avatars.githubusercontent.com/u/13942856?v=4)](https://github.com/xfolder "xfolder (1 commits)")[![davidbirkin](https://avatars.githubusercontent.com/u/34802973?v=4)](https://github.com/davidbirkin "davidbirkin (1 commits)")[![zmeeeeeva](https://avatars.githubusercontent.com/u/13080665?v=4)](https://github.com/zmeeeeeva "zmeeeeeva (1 commits)")[![imsus](https://avatars.githubusercontent.com/u/1058471?v=4)](https://github.com/imsus "imsus (1 commits)")[![m-popa](https://avatars.githubusercontent.com/u/23634938?v=4)](https://github.com/m-popa "m-popa (1 commits)")

### Embed Badge

![Health badge](/badges/zaryabakhtar-laravel-db-sync/health.svg)

```
[![Health](https://phpackages.com/badges/zaryabakhtar-laravel-db-sync/health.svg)](https://phpackages.com/packages/zaryabakhtar-laravel-db-sync)
```

###  Alternatives

[doctrine/orm

Object-Relational-Mapper for PHP

10.2k285.3M6.2k](/packages/doctrine-orm)[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k115.1M102](/packages/jdorn-sql-formatter)[illuminate/database

The Illuminate Database package.

2.8k52.4M9.4k](/packages/illuminate-database)[mongodb/mongodb

MongoDB driver library

1.6k64.0M546](/packages/mongodb-mongodb)[ramsey/uuid-doctrine

Use ramsey/uuid as a Doctrine field type.

90340.3M211](/packages/ramsey-uuid-doctrine)[reliese/laravel

Reliese Components for Laravel Framework code generation.

1.7k3.4M16](/packages/reliese-laravel)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)