Phinx

Free plan Self-hosted

What Phinx is

Phinx is free, open-source software for managing database migrations in PHP applications without an ORM or application framework. Migrations can be written in PHP or SQL, run forward or backward, and executed during deployment. Phinx can seed data after database creation and supports multiple database environments, allowing work created in development to run in production. Native adapters are listed for MySQL, PostgreSQL, SQLite, and Microsoft SQL Server, with custom adapters supported through AdapterInterface. As a command-line tool, it can integrate with deployment, build, or CI tools. Installation uses Composer and requires PHP 8.1 or later, including a 64-bit PHP version. Configuration files contain database credentials and should stay outside publicly accessible web directories. Failed MySQL migrations may leave partial changes because some operations implicitly commit, and the README lists inability to set a unique constraint on a table as a PostgreSQL limitation. An introductory DRM-free MP4 screencast is listed at $5 USD.

Who it suits

Phinx suits PHP developers who need command-line schema migrations, rollback support, seeding, and deployment or CI integration. It is intended for self-hosted projects using one of its listed databases or a custom adapter.

What it does well

Free and open-source
Supports PHP and SQL migrations
Runs migrations up or down
Includes multiple database environments
Integrates with deployment and CI tools

What to know first

Requires PHP 8.1 or later
Requires a 64-bit PHP version
MySQL failures may leave partial migrations
PostgreSQL unique constraints have a listed limitation

Limits

Phinx is permanently free. The documented MySQL caveat is that failed migrations may leave the database partly migrated when operations cause implicit commits; the README lists inability to set a unique constraint on a table as a PostgreSQL limitation.

Plans

Plan	Billed and limits	Price
Free	Free, open-source software	Free

As phinx.org lists them, read 8 Oct 2026. The maker's own page has the final word.

Getting started

Install PHP 8.1 or later in a 64-bit version.
Install Phinx with Composer.
Configure the database environments for your project.
Write migrations in PHP or SQL and use the command line to run them.
Keep configuration files containing credentials outside publicly accessible web-server directories.

Verdict

Phinx provides migration and seeding workflows without requiring an ORM or framework. Its adapter range and command-line integration are useful, but the documented database limitations and credential-handling guidance deserve attention.

Questions

Does Phinx cost anything?

Phinx is free, open-source software. The site lists an introductory DRM-free MP4 screencast for $5 USD.

Which platforms or hosting model does Phinx use?

Phinx is self-hosted and runs from the command line.

Which databases does it support?

Native adapters are listed for MySQL, PostgreSQL, SQLite, and Microsoft SQL Server. A custom adapter can be registered if it implements Phinx’s AdapterInterface.

What does installation require?

The documentation directs users to install Phinx with Composer and requires PHP 8.1 or later, including a 64-bit PHP version.

Can Phinx run migrations as part of deployment?

Yes. Migrations can run during deployment, and the command-line tool can integrate with deployment, build, or CI tools.

What limitations should database teams consider?

A failed MySQL migration may leave the database partly migrated when operations cause implicit commits. The README lists inability to set a unique constraint on a table as a PostgreSQL limitation.

Facts from Phinx's own pages

Audience: Phinx is presented as a migration tool for PHP applications that avoids the bloat of an ORM or application framework. · github.com, 8 Oct 2026
Configuration security: The documentation warns that configuration files contain database credentials and should be stored outside publicly accessible web directories. · book.cakephp.org, 8 Oct 2026
Custom adapters: Users can register a custom adapter that implements Phinx’s AdapterInterface. · book.cakephp.org, 8 Oct 2026
Database adapters: Native adapters are listed for MySQL, PostgreSQL, SQLite, and Microsoft SQL Server. · book.cakephp.org, 8 Oct 2026
Data seeding: Phinx can seed data after database creation. · github.com, 8 Oct 2026
Deployment integration: Because Phinx runs from the command line, the maker says it can integrate with deploy, build, or CI tools. · phinx.org, 8 Oct 2026
Environments: Phinx supports multiple database environments, so migrations can be created in development and run in production. · book.cakephp.org, 8 Oct 2026
Installation: The documentation directs users to install Phinx with Composer and says it requires PHP 8.1 or later. · book.cakephp.org, 8 Oct 2026
Migration actions: Phinx supports migrating up and down, and running migrations during deployment. · github.com, 8 Oct 2026
Migration formats: Migrations can be written in PHP or SQL. · phinx.org, 8 Oct 2026
Migration operations: Phinx supports migrating up and down and running migrations during deployment. · github.com, 8 Oct 2026
MySQL limitation: The documentation says failed MySQL migrations may leave the database partially migrated because operations such as CREATE TABLE can cause implicit commits. · book.cakephp.org, 8 Oct 2026
PostgreSQL limitation: The repository README lists inability to set a unique constraint on a table as a PostgreSQL limitation. · github.com, 8 Oct 2026
Price: The maker describes Phinx as permanently free, open-source software and invites commercial users to donate or buy a screencast. · phinx.org, 8 Oct 2026
Purpose: Phinx manages database migrations for PHP applications. · phinx.org, 8 Oct 2026
Runtime requirement: Phinx requires a 64-bit version of PHP. · book.cakephp.org, 8 Oct 2026
Screencast: The Phinx site lists an introductory DRM-free MP4 screencast for $5 USD with a duration of 16 minutes 51 seconds. · phinx.org, 8 Oct 2026
Security guidance: The documentation warns that the configuration file contains database credentials and should be stored outside publicly accessible web-server directories. · book.cakephp.org, 8 Oct 2026
Seeding: Phinx can seed data after database creation. · github.com, 8 Oct 2026
Support: The Phinx site points users to its documentation and GitHub issue tracker for support. · phinx.org, 8 Oct 2026

Where Phinx stands on Freedom251

Database Migration Tools#23 of 32