PHPackages                             zyimm/sync-data-struct - 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. zyimm/sync-data-struct

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

zyimm/sync-data-struct
======================

比较两个数据库之间的数据结构差异,并生成更新DDL|Compare the data structure differences between the two databases and generate update DDL

v1.0.6(2y ago)41023[1 issues](https://github.com/zyimm/sync-data-struct/issues)MITPHPPHP >=5.4

Since Jul 29Pushed 2y ago1 watchersCompare

[ Source](https://github.com/zyimm/sync-data-struct)[ Packagist](https://packagist.org/packages/zyimm/sync-data-struct)[ RSS](/packages/zyimm-sync-data-struct/feed)WikiDiscussions master Synced 3w ago

READMEChangelog (5)DependenciesVersions (8)Used By (0)

sync-data-struct
----------------

[](#sync-data-struct)

sync-data-struct是一个用来比较两个数据库之间的数据结构差异,并生成更新DDL的工具包，不依赖于任何三方库.方便对比出两个数据库之间差异来进行数据结构同步.| sync-data-struct is a toolkit for comparing data structure differences between two databases and generating updated DDL. Easy to compare the difference between the two databases for data structure synchronization

support database && 支持的数据库
----------------------------------

[](#support-database--支持的数据库)

- mysql

install && 安装
---------------------

[](#install--安装)

```
composer  require zyimm/sync-data-struct

```

example && 示例
---------------------

[](#example--示例)

```
//set error
error_reporting(E_ALL);
ini_set('display_errors', true);
//autoload
include '../vendor/autoload.php';
//db
$config = [
    //本地数据库
    'local' => [
        'host'     => 'mysql',
        'username' => 'root',
        'passwd'   => '123456',
        'dbname'   => 'local'
    ],
    //开发数据库或目标同步数据
    'dev'   => [
        'host'     => 'mysql',
        'username' => 'root',
        'passwd'   => '123456',
        'dbname'   => 'dev'
    ]
];
$handle = new \Zyimm\dbStructSync\Sync($config);
echo $handle->toHtml();

```

issue
-----

[](#issue)

能力有限！欢迎提出issue,共同学习进步。

###  Health Score

26

—

LowBetter than 41% of packages

Maintenance15

Infrequent updates — may be unmaintained

Popularity16

Limited adoption so far

Community9

Small or concentrated contributor base

Maturity55

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 ~234 days

Recently: every ~292 days

Total

6

Last Release

992d ago

PHP version history (2 changes)v1.0.1PHP >=5.2

v1.0.6PHP >=5.4

### Community

Maintainers

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

---

Top Contributors

[![zyimm](https://avatars.githubusercontent.com/u/13979159?v=4)](https://github.com/zyimm "zyimm (26 commits)")

---

Tags

mysqlmysql-databasephpmysqlsql structure

### Embed Badge

![Health badge](/badges/zyimm-sync-data-struct/health.svg)

```
[![Health](https://phpackages.com/badges/zyimm-sync-data-struct/health.svg)](https://phpackages.com/packages/zyimm-sync-data-struct)
```

###  Alternatives

[leantime/leantime

Open source project management system for non-project managers. Simple like Trello, powerful like Jira. Built with neurodiversity in mind.

10.2k3.5k](/packages/leantime-leantime)[clouddueling/mysqldump-php

PHP version of mysqldump cli that comes with MySQL

1.3k23.2k](/packages/clouddueling-mysqldump-php)[stefangabos/zebra_database

An advanced, compact and lightweight MySQL database wrapper library, built around PHP's MySQLi extension.

11712.6k](/packages/stefangabos-zebra-database)[eftec/pdoone

Minimaist procedural PDO wrapper library

1116.3k9](/packages/eftec-pdoone)[popphp/pop-db

Pop Db Component for Pop PHP Framework

1816.5k12](/packages/popphp-pop-db)[matthew-p/docker-server

Universal docker server, Nginx, PHP-FPM, MySql, Redis

115.1k](/packages/matthew-p-docker-server)

PHPackages © 2026

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