awesome-repositories.com
Blog
MCP
awesome-repositories.com

Discover the best open-source repositories with AI-powered search.

ExploreCurated searchesOpen-source alternativesSelf-hosted softwareBlogSitemap
ProjectMCP serverAboutHow we rankPress
LegalPrivacyTerms
© 2026 Bringes Technology SRL·VAT RO45896025·hello@awesome-repositories.com
cakephp avatar

cakephp/phinx

0
View on GitHub↗
4,537 stars·886 forks·PHP·MIT·24 viewsphinx.org↗

Phinx

Phinx is a PHP database migration and versioning tool used to track and deploy structural changes to database schemas across different environments. It functions as a version control system for databases, allowing structural modifications to be defined and managed through PHP code.

The tool provides mechanisms for database schema versioning and rollback, enabling users to undo previously applied migrations and restore a database to a specific previous state. Additionally, it includes a database seeder for populating tables with initial baseline records or dummy data.

The system operates as a standalone command line interface that manages the sequential execution of migrations and tracks the current schema version via a metadata table within the target database.

Features

  • Database Schema Version Control - Provides a version control system for database schemas using reproducible PHP migration files.
  • Database Migrations - Tracks and deploys structural changes to database schemas using versioned PHP code.
  • Database Versioning - Manages the evolution of database structures to synchronize schemas across different environments.
  • Migration Execution - Executes database schema updates in chronological order to ensure consistent evolution.
  • Schema Rollbacks - Enables users to undo previously applied migrations and restore the database to a stable previous state.
  • Schema Version Tracking - Tracks applied migrations via a dedicated metadata table within the target database.
  • Change Rollback Mechanisms - Supports reverting problematic schema updates to restore a stable database state without manual SQL.
  • PHP-Based Definitions - Allows structural changes to be defined as portable PHP code for version control.
  • Database Migration Tools - Serves as a PHP-based utility for versioning and applying incremental schema changes.
  • Database Schema Rollback Tools - Provides a dedicated mechanism to undo migrations and restore the schema to a specific previous state.
  • Data Seeding Utilities - Includes a seeder to populate database tables with initial baseline or dummy records.
  • Database Adapters - Provides standardized interfaces to decouple migration logic from specific database engines.
  • Database Seeding Tools - Automates the population of fresh databases with baseline records required for application functionality.
  • Standalone CLI Runtimes - Operates as a standalone CLI tool to execute migrations independently of a full framework.
  • Command Patterns - Implements reversible command patterns using up and down methods for schema application and rollback.
  • Database Seeders - Provides a seeder for populating database tables with initial records for development and testing.
  • Database Migrations - Manages database migrations.

Star history

Star history chart for cakephp/phinxStar history chart for cakephp/phinx

How this analysis was created: This summary and feature list were written by an AI model that read the project's README and public documentation pages. Each feature links to the documentation it came from; stars, license and language come straight from the GitHub API. The model does not read the source code, and the analysis is refreshed when the project is re-analysed. Learn more on our About page.

AI search

Explore more awesome repositories

Describe what you need in plain English — the AI ranks thousands of curated open-source projects by relevance.

Start searching with AI

Open-source alternatives to Phinx

Similar open-source projects, ranked by how many features they share with Phinx.
  • mattes/migratemattes avatar

    mattes/migrate

    2,282View on GitHub↗

    This project is a database schema migration engine that provides a command-line interface and a library for managing sequential structural changes. It functions as a version control utility for database schemas, enabling the application, reversion, and synchronization of incremental updates across development and production environments. The tool distinguishes itself through a driver-based abstraction layer that supports a wide range of relational and non-relational storage systems. It maintains schema consistency by using a dedicated metadata table to track versions and prevent concurrent up

    Goaws-s3cassandracrate
    View on GitHub↗2,282
  • pressly/goosepressly avatar

    pressly/goose

    10,197View on GitHub↗

    Goose is a database schema versioning system and SQL migration tool designed for Go applications. It functions as a framework for tracking and applying incremental database changes through versioned SQL scripts, ensuring consistency across different environments. The project distinguishes itself by providing a build-time capability to exclude unused database drivers to optimize binary size and a filesystem abstraction that allows migration scripts to be bundled directly into a compiled executable. It also supports out-of-order execution logic to apply missing scripts that were created after a

    Godatabasedatabase-migrationsgo
    View on GitHub↗10,197
  • golang-migrate/migrategolang-migrate avatar

    golang-migrate/migrate

    18,118View on GitHub↗

    This project is a command-line utility designed to manage database schema versioning and automate incremental schema updates. It functions as a version control system for database structures, ensuring consistency across environments by tracking applied migrations in a dedicated metadata table and executing scripts in a sequential, reliable manner. The tool distinguishes itself through a driver-based abstraction layer that supports a wide range of database engines, including various SQL and distributed cloud databases. It provides robust concurrency control through advisory locking, which prev

    Goaws-s3cassandradatabase
    View on GitHub↗18,118
  • doctrine/migrationsdoctrine avatar

    doctrine/migrations

    4,770View on GitHub↗

    This project is a database version control system and schema evolution manager designed to track and apply incremental changes to database structures. It serves as a tool for versioning SQL database migrations using both programmatic PHP classes and SQL scripts. The system is designed specifically for integration with the Doctrine Object Relational Mapper for PHP, allowing database schemas to evolve incrementally without data loss through reversible migration steps. It covers capabilities for automated database migrations, environment synchronization, and schema versioning. These features fa

    PHP
    View on GitHub↗4,770
See all 30 alternatives to Phinx→

Frequently asked questions

What does cakephp/phinx do?

Phinx is a PHP database migration and versioning tool used to track and deploy structural changes to database schemas across different environments. It functions as a version control system for databases, allowing structural modifications to be defined and managed through PHP code.

What are the main features of cakephp/phinx?

The main features of cakephp/phinx are: Database Schema Version Control, Database Migrations, Database Versioning, Migration Execution, Schema Rollbacks, Schema Version Tracking, Change Rollback Mechanisms, PHP-Based Definitions.

What are some open-source alternatives to cakephp/phinx?

Open-source alternatives to cakephp/phinx include: mattes/migrate — This project is a database schema migration engine that provides a command-line interface and a library for managing… pressly/goose — Goose is a database schema versioning system and SQL migration tool designed for Go applications. It functions as a… golang-migrate/migrate — This project is a command-line utility designed to manage database schema versioning and automate incremental schema… doctrine/migrations — This project is a database version control system and schema evolution manager designed to track and apply incremental… liquibase/liquibase — Liquibase is a database schema change management tool and version control system designed to track, manage, and apply… db-migrate/node-db-migrate — This project is a database migration framework designed to manage and execute versioned schema changes across multiple…