# cakephp/phinx

PHP Database Migrations for Everyone

Repository: https://github.com/cakephp/phinx
Canonical: https://ross.abutalabs.com/products/phinx
Homepage: https://phinx.org
Language: PHP
License: MIT
License Family: permissive
Topics: php, migrations, database-migrations, php-database-migrations
Last push: 2026-07-21T18:07:11+00:00

## Health v2 (maintenance only)
Score: 90/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 93, release rhythm 79, longevity 100
- inputs: {"age_days": 5363, "days_push": 43, "days_rel": 61, "gap_med": 43, "n_releases_24m": 10}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 4539, forks 884 (observed 2026-08-28T04:08:53.098948+00:00)

## What it is
Phinx is a standalone PHP database migration tool that lets developers manage and version database schema changes using database-agnostic PHP or SQL code. It runs from the command line, supports up/down migrations and data seeding, and works with MySQL, PostgreSQL, SQLite, and SQL Server without requiring a full framework or ORM.

## Use cases
- manage database schema migrations for a PHP app
- roll back database changes on deployment
- seed test or initial data after database creation
- write database-agnostic migrations that work across MySQL, PostgreSQL, SQLite, and SQL Server
- integrate database migrations into CI/CD or deploy pipelines
- track migration status from the command line

## When to choose
- you need framework-independent database migrations in a PHP project
- you want migrations portable across multiple database vendors
- you need a lightweight migration tool without pulling in an ORM
- you want to seed databases and run migrations from CLI or CI

## When to avoid
- your framework already ships its own migration system you prefer to use
- you need migrations for databases outside the four supported adapters
- you want a GUI-based database management tool
- your project is not written in PHP

## Facets
- artifact type: library
- maturity: stable
- function: database, cli, developer-tools
- domain: databases, developer-tools, backend
- platform: php, cli, cross-platform
- tags: database-migrations, schema-migrations, database-seeding, mysql, postgresql, sqlite, sql-server, composer, command-line

## Member repositories
- cakephp/phinx (main) score 90

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:08:53.098948+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T18:20:10.163471+00:00, confidence not recorded.
  - readme: https://github.com/cakephp/phinx (fetched 2026-08-28T04:08:53.098948+00:00, sha 80270747b58b)
  - homepage: https://phinx.org (fetched 2026-08-29T09:05:57.143878+00:00, sha 6fd8588fea34)
  - site_page: https://phinx.org/docs (fetched 2026-08-29T09:05:57.146505+00:00, sha b2626c82f9a3)
  - site_page: http://docs.phinx.org (fetched 2026-08-29T09:05:57.148252+00:00, sha bb22e10e5f6a)
  - site_page: http://docs.phinx.org/ (fetched 2026-08-29T09:05:57.149783+00:00, sha bb22e10e5f6a)
- Data as of 2026-08-30T08:39:29.467469+00:00.