PHPackages                             aliengen/pachyderm-migration - 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. aliengen/pachyderm-migration

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

aliengen/pachyderm-migration
============================

A migration tool for Pachyderm SQL database

0117PHP

Since Aug 26Pushed 10mo agoCompare

[ Source](https://github.com/AlienGen/pachyderm-migration)[ Packagist](https://packagist.org/packages/aliengen/pachyderm-migration)[ RSS](/packages/aliengen-pachyderm-migration/feed)WikiDiscussions main Synced today

READMEChangelogDependenciesVersions (1)Used By (0)

Pachyderm Migration
===================

[](#pachyderm-migration)

[![PHP Version](https://camo.githubusercontent.com/9c2f8ad80d34105266a94c4c06234f8ed18c968d3595039c2d9a7becd1e71c8b/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f7068702d253345253344382e342d626c75652e737667)](https://php.net)[![License](https://camo.githubusercontent.com/8bb50fd2278f18fc326bf71f6e88ca8f884f72f179d3e555e20ed30157190d0d/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f6c6963656e73652d4d49542d677265656e2e737667)](LICENSE)

A simple and reliable SQL database migration tool for Pachyderm applications. Manage your database schema changes through SQL files with automatic tracking and ordered execution.

✨ Features
----------

[](#-features)

- **🔄 Automatic Tracking**: Tracks executed migrations automatically
- **📁 SQL File-based**: Simple SQL files for your migrations
- **🔄 Ordered Execution**: Runs migrations in alphabetical order
- **🛡️ Safe**: Prevents duplicate execution
- **⚡ Zero Config**: Works out of the box
- **🤖 Easy Setup**: Simple command to set up the migration structure

📋 Requirements
--------------

[](#-requirements)

- **PHP**: 8.4 or higher
- **Pachyderm**: Latest version
- **Composer**: For dependency management

🚀 Quick Start
-------------

[](#-quick-start)

### Installation

[](#installation)

```
composer require aliengen/pachyderm-migration
```

### Setup

[](#setup)

After installation, run the setup command to create the necessary files:

```
./vendor/bin/pachyderm-migration --setup
```

This will automatically create:

- `database/migrations/` folder for your SQL files
- `migration.php` file for easy execution

### Basic Usage

[](#basic-usage)

1. **Create a migration** by adding a SQL file to `database/migrations/`:

```
-- database/migrations/001_create_users_table.sql
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(255) NOT NULL UNIQUE,
    email VARCHAR(255) NOT NULL UNIQUE,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
```

2. **Run migrations** using any of these methods:

```
# Option 1: Using the generated migration.php file
php migration.php

# Option 2: Using the vendor binary directly
./vendor/bin/pachyderm-migration

# Option 3: Using composer run
composer run pachyderm-migration
```

That's it! Your migration will be executed and tracked automatically.

📚 Usage
-------

[](#-usage)

Run all pending migrations using any of these methods:

```
# Using the generated file
php migration.php

# Using the vendor binary
./vendor/bin/pachyderm-migration

# Using composer
composer run pachyderm-migration
```

📁 Project Structure
-------------------

[](#-project-structure)

```
your-project/
├── database/
│   └── migrations/          # Your SQL migration files
│       ├── 001_create_users.sql
│       ├── 002_create_posts.sql
│       └── 003_add_indexes.sql
├── vendor/                  # Composer dependencies
├── migration.php           # Migration execution script
└── composer.json

```

🔧 Configuration
---------------

[](#-configuration)

### Database Connection

[](#database-connection)

Ensure your Pachyderm `config.php` file includes the necessary database configuration. The migration tool will use Pachyderm's database service to connect to your database.

Example of the `database` service declaration in the `config.php` file:

```
Service::set('database', function () {
  return Db::getInstance();
});
```

🤝 Contributing
--------------

[](#-contributing)

1. **Fork** the repository
2. **Create** a feature branch (`git checkout -b feature/amazing-feature`)
3. **Commit** your changes (`git commit -m 'Add amazing feature'`)
4. **Push** to the branch (`git push origin feature/amazing-feature`)
5. **Open** a Pull Request

📄 License
---------

[](#-license)

This project is licensed under the MIT License - see the [LICENSE](LICENSE) file for details.

📞 Support
---------

[](#-support)

- **Issues**: [GitHub Issues](https://github.com/aliengen/pachyderm-migration/issues)

---

**Made with ❤️ by the AlienGen team**

###  Health Score

18

—

LowBetter than 8% of packages

Maintenance39

Infrequent updates — may be unmaintained

Popularity12

Limited adoption so far

Community6

Small or concentrated contributor base

Maturity14

Early-stage or recently created project

 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.

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/711667?v=4)[Timothé Mermet-Buffet](/maintainers/mermetbt)[@mermetbt](https://github.com/mermetbt)

---

Top Contributors

[![mermetbt](https://avatars.githubusercontent.com/u/711667?v=4)](https://github.com/mermetbt "mermetbt (13 commits)")

### Embed Badge

![Health badge](/badges/aliengen-pachyderm-migration/health.svg)

```
[![Health](https://phpackages.com/badges/aliengen-pachyderm-migration/health.svg)](https://phpackages.com/packages/aliengen-pachyderm-migration)
```

###  Alternatives

[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k117.2M118](/packages/jdorn-sql-formatter)[propel/propel1

Propel is an open-source Object-Relational Mapping (ORM) for PHP5.

8351.6M87](/packages/propel-propel1)[pgvector/pgvector

pgvector support for PHP

198741.5k12](/packages/pgvector-pgvector)[jfelder/oracledb

Oracle DB driver for Laravel

11518.4k](/packages/jfelder-oracledb)

PHPackages © 2026

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