PHPackages                             orptech/laravel-migration-partition - 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. orptech/laravel-migration-partition

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

orptech/laravel-migration-partition
===================================

Laravel extensions that extends Illuminate to enable partitioned table creation within Laravel migrations.

v13.0.1(1mo ago)3829.0k↓25.3%7[1 PRs](https://github.com/orptech-com/laravel-migration-partition/pulls)MITPHPPHP ^8.3CI passing

Since Oct 6Pushed 1w ago4 watchersCompare

[ Source](https://github.com/orptech-com/laravel-migration-partition)[ Packagist](https://packagist.org/packages/orptech/laravel-migration-partition)[ Docs](https://github.com/orptech/laravel-migration-partition)[ RSS](/packages/orptech-laravel-migration-partition/feed)WikiDiscussions main Synced 2d ago

READMEChangelog (10)Dependencies (34)Versions (43)Used By (0)

[![](https://camo.githubusercontent.com/2517980964372c61e86022b23e1bd56d1903a8f62e8866085f5ab482354fa742/68747470733a2f2f6f7270746563682e636f6d2f6173736574732f696d616765732f6c6f676f732f6f7270746563682d6c6f676f2d77686974652e706e67)](https://orptech.com)

[![](https://camo.githubusercontent.com/e2e7c4f41a3bc71a73b3b6e7a9c802148ee71f2622cc865927c4f96be7b52fca/68747470733a2f2f726574726f636b65742e696f2f636f6d6d6f6e2f696d672f6c6f676f5f77686974652e706e67)](https://retrocket.io)

Database Partitions via Migrations for Laravel (aka Laravel Migration Partitions)
=================================================================================

[](#database-partitions-via-migrations-for-laravel-aka-laravel-migration-partitions)

This package extends Illuminate to provide partitioned table creation in migrations for PostgreSQL. Support for other DMBS's will be added soon.

[![Latest Version on Packagist](https://camo.githubusercontent.com/798c01c37c285cc873f67851bc68e2a03d70267329b5907181a9bea79d79874c/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f762f6f7270746563682f6c61726176656c2d6d6967726174696f6e2d706172746974696f6e2e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/orptech/laravel-migration-partition)[![Total Downloads](https://camo.githubusercontent.com/b24e1a91400644bae3a4bad81e8cfd930a55b1f0f99a4322dffae0fc6daa687f/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f6f7270746563682f6c61726176656c2d6d6967726174696f6e2d706172746974696f6e2e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/orptech/laravel-migration-partition)

ORPtech Software
----------------

[](#orptech-software)

We are ORPtech. Here at ORPtech, we pride ourselves in ensuring that clients and services have a peaceful, safe and smooth interaction. We know how difficult it is to build trust for a service, therefore we are here to help bridge the gaps within the market via our robust applications. Please contact us for further information on how our services might help your business.

Version Matching
----------------

[](#version-matching)

**Package Version****Supported**11.x.x**Laravel 11**12.x.x**Laravel 12**13.x.x**Laravel 13**Installation
------------

[](#installation)

You can install the package via composer:

```
composer require orptech/laravel-migration-partition
```

DBMS Support
------------

[](#dbms-support)

- PostgreSQL

### Planned Development

[](#planned-development)

- MySQL - Looking for Contributors
- MariaDB - Looking for Contributors
- SQL Server 2017+
- SQLite 3.8.8+

Usage
-----

[](#usage)

This package currently, only supports PostgreSQL.

PostgreSQL
----------

[](#postgresql)

PostgreSQL also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance.

### Range Partitioning

[](#range-partitioning)

Instead of importing Illuminate's Schema import this package's schema:

```
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
```

Template Usage
--------------

[](#template-usage)

### Range Partition

[](#range-partition)

```
use ORPTech\MigrationPartition\Database\Schema\Blueprint;
use ORPTech\MigrationPartition\Support\Facades\Schema;

Schema::createRangePartitioned('[YourTableNameHere]', function (Blueprint $table) {
    //...
}, '[compositeKeyOne]', '[compositeKeyTwo]', '[rangePartitionKey]');
```

Enter null for `[compositeKeyOne]`, `[compositeKeyTwo]` if you don't need a primary key.

##### Creating a Range Partition for a Partitioned Table

[](#creating-a-range-partition-for-a-partitioned-table)

```
use ORPTech\MigrationPartition\Database\Schema\Blueprint;
use ORPTech\MigrationPartition\Support\Facades\Schema;

Schema::createRangePartition('[YourPartitionedTableNameHere]', function (Blueprint $table) {}, '[suffixForPartition]', '[startDate]', '[endDate]');
```

##### Attaching a Range Partition to a Partitioned Table

[](#attaching-a-range-partition-to-a-partitioned-table)

```
use ORPTech\MigrationPartition\Database\Schema\Blueprint;
use ORPTech\MigrationPartition\Support\Facades\Schema;

Schema::attachRangePartition('[YourPartitionedTableNameHere]', function (Blueprint $table) {}, '[suffixForPartition]', '[startDate]', '[endDate]');
```

### List Partition

[](#list-partition)

```
use ORPTech\MigrationPartition\Database\Schema\Blueprint;
use ORPTech\MigrationPartition\Support\Facades\Schema;

Schema::createListPartitioned('[YourTableNameHere]', function (Blueprint $table) {
    //...
}, '[compositeKeyOne]', '[compositeKeyTwo]', '[listPartitionKey]');
```

Enter null for `[compositeKeyOne]`, `[compositeKeyTwo]` if you don't need a primary key.

##### Creating a List Partition for a Partitioned Table

[](#creating-a-list-partition-for-a-partitioned-table)

```
use ORPTech\MigrationPartition\Database\Schema\Blueprint;
use ORPTech\MigrationPartition\Support\Facades\Schema;

Schema::createListPartition('[YourPartitionedTableNameHere]', function (Blueprint $table) {}, '[suffixForPartition]', '[listPartitionValue]');
```

##### Attaching a List Partition to a Partitioned Table

[](#attaching-a-list-partition-to-a-partitioned-table)

```
use ORPTech\MigrationPartition\Database\Schema\Blueprint;
use ORPTech\MigrationPartition\Support\Facades\Schema;

Schema::attachListPartition('[YourPartitionedTableNameHere]', function (Blueprint $table) {}, '[suffixForPartition]', '[listPartitionValue]');
```

### Hash Partition

[](#hash-partition)

```
use ORPTech\MigrationPartition\Database\Schema\Blueprint;
use ORPTech\MigrationPartition\Support\Facades\Schema;

Schema::createHashPartitioned('[YourTableNameHere]', function (Blueprint $table) {
    //...
}, '[compositeKeyOne]', '[compositeKeyTwo]', '[hashPartitionKey]');
```

Enter null for `[compositeKeyOne]`, `[compositeKeyTwo]` if you don't need a primary key.

##### Creating a Hash Partition for a Partitioned Table

[](#creating-a-hash-partition-for-a-partitioned-table)

```
use ORPTech\MigrationPartition\Database\Schema\Blueprint;
use ORPTech\MigrationPartition\Support\Facades\Schema;

Schema::createHashPartition('[YourPartitionedTableNameHere]', function (Blueprint $table) {}, '[suffixForPartition]', '[hashModulus]', '[hashRemainder]');
```

##### Attaching a Hash Partition to a Partitioned Table

[](#attaching-a-hash-partition-to-a-partitioned-table)

```
use ORPTech\MigrationPartition\Database\Schema\Blueprint;
use ORPTech\MigrationPartition\Support\Facades\Schema;

Schema::attachHashPartition('[YourPartitionedTableNameHere]', function (Blueprint $table) {}, '[suffixForPartition]', '[hashModulus]', '[hashRemainder]');
```

#### Removing a Partition

[](#removing-a-partition)

```
use ORPTech\MigrationPartition\Database\Schema\Blueprint;
use ORPTech\MigrationPartition\Support\Facades\Schema;

Schema::detachPartition('[YourPartitionedTableNameHere]', function (Blueprint $table) {}, '[partitionTableName]');
```

Commands
--------

[](#commands)

##### New Series of Range Partition Migrations

[](#new-series-of-range-partition-migrations)

This command will create a new series of migrations for all range partitioned tables.

```
php artisan partition:range
```

##### New Series of List Partition Migrations

[](#new-series-of-list-partition-migrations)

This command will create a new series of migrations for all list partitioned tables.

```
php artisan partition:list
```

##### New Series of Hash Partition Migrations

[](#new-series-of-hash-partition-migrations)

This command will create a new series of migrations for all hash partitioned tables.

```
php artisan partition:hash
```

##### Listing Partitions

[](#listing-partitions)

This command will list all the partitioned tables.

```
php artisan partition:partitions
```

### Important

[](#important)

- This package currently supports PostgreSQL Range Partitions.
- You shouldn't define any primary keys in your migration. The package creates a composite key while setting up the table.
- You need to create an initial partition to start using the tables. (PostgreSQL)

Testing
-------

[](#testing)

```
composer test
```

Changelog
---------

[](#changelog)

Please see [CHANGELOG](CHANGELOG.md) for more information on what has changed recently.

Security Vulnerabilities
------------------------

[](#security-vulnerabilities)

Please review [our security policy](../../security/policy) on how to report security vulnerabilities.

Credits
-------

[](#credits)

- [ORPtech](https://github.com/orptech-com)
- [Retrocket](https://github.com/retrocket)
- [Laravel](https://github.com/laravel)

License
-------

[](#license)

The MIT License (MIT). Please see [License File](LICENSE.md) for more information.

###  Health Score

60

—

FairBetter than 98% of packages

Maintenance95

Actively maintained with recent releases

Popularity39

Limited adoption so far

Community16

Small or concentrated contributor base

Maturity74

Established project with proven stability

 Bus Factor1

Top contributor holds 66.7% 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 ~55 days

Recently: every ~93 days

Total

25

Last Release

39d ago

Major Versions

v3.0.0 → v4.0.02023-02-17

v4.0.4 → v11.0.02024-06-08

v11.0.0 → v12.0.02025-05-19

v12.0.0 → v13.0.02025-09-08

v12.0.1 → v13.0.0-beta2026-03-23

PHP version history (3 changes)v1.0.0PHP ^8.1

v11.0.0PHP ^8.2

v13.0.0-betaPHP ^8.3

### Community

Maintainers

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

---

Top Contributors

[![ArdaKaraderi](https://avatars.githubusercontent.com/u/22325146?v=4)](https://github.com/ArdaKaraderi "ArdaKaraderi (48 commits)")[![denizgolbas](https://avatars.githubusercontent.com/u/27892099?v=4)](https://github.com/denizgolbas "denizgolbas (10 commits)")[![dependabot[bot]](https://avatars.githubusercontent.com/in/29110?v=4)](https://github.com/dependabot[bot] "dependabot[bot] (10 commits)")[![megasteve19](https://avatars.githubusercontent.com/u/32229751?v=4)](https://github.com/megasteve19 "megasteve19 (4 commits)")

---

Tags

laravellaravel-frameworklaravel-packagemysqlpartitionpartitioningpostgrespostgresqllaraveldatabasepostgresmigrationspostgrepsqlORPTechlaravel-migration-partition

###  Code Quality

TestsPest

Static AnalysisPHPStan

Code StyleLaravel Pint

### Embed Badge

![Health badge](/badges/orptech-laravel-migration-partition/health.svg)

```
[![Health](https://phpackages.com/badges/orptech-laravel-migration-partition/health.svg)](https://phpackages.com/packages/orptech-laravel-migration-partition)
```

###  Alternatives

[laravel/ai

The official AI SDK for Laravel.

1.0k3.2M195](/packages/laravel-ai)[illuminate/queue

The Illuminate Queue package.

21332.6M1.6k](/packages/illuminate-queue)[spatie/laravel-medialibrary

Associate files with Eloquent models

6.1k43.2M632](/packages/spatie-laravel-medialibrary)[spatie/laravel-health

Monitor the health of a Laravel application

87512.0M165](/packages/spatie-laravel-health)[psalm/plugin-laravel

Psalm plugin for Laravel

3355.3M346](/packages/psalm-plugin-laravel)[roots/acorn

Framework for Roots WordPress projects built with Laravel components.

9762.4M131](/packages/roots-acorn)

PHPackages © 2026

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