What migration format does it use?

It generates migrations using the standard Phinx-based Migrations plugin format compatible with CakePHP 3.x, 4.x, and 5.x.

Does it handle relationships and foreign keys?

Yes, it supports designing many-to-many association tables, self-referencing hierarchical data, and complex foreign key constraints with CASCADE/RESTRICT rules.

Can it help with database performance?

Absolutely. It provides specific strategies for index design, composite indexes, and partitioning to ensure high-performance queries.

Does this skill support multi-tenant setups?

Yes, it includes specialized patterns for both shared database/shared schema (using company_id) and shared database/separate schema architectures.

CakePHP Database Designer

Name: CakePHP Database Designer
Author: masanao-ohba

bymasanao-ohba

•

データベース管理

Designs optimized database schemas, Phinx-based migrations, and multi-tenant architectures specifically for PHP CakePHP applications.

概要

The CakePHP Database Designer skill provides specialized guidance for architecting robust relational data layers within the CakePHP ecosystem. It streamlines the creation of normalized schemas (1NF-3NF) and generates production-ready migration files using the Phinx-based format standard in CakePHP. Beyond basic CRUD, it excels at designing complex multi-tenant architectures, implementing soft-delete patterns, and optimizing database performance through intelligent indexing and partitioning strategies, ensuring your application remains scalable as data grows.

主な機能

Generates CakePHP-compliant Phinx migration files and table structures
Architects multi-tenant database patterns for SaaS applications
Provides advanced indexing strategies and query performance tuning
Implements standard business patterns like Audit Trails and Soft Deletes
Optimizes data types and constraints for MySQL/MariaDB environments
2 GitHub stars

ユースケース

Refactoring legacy database tables into normalized relational structures
Building a multi-tenant SaaS platform with isolated customer data
Generating complex database migrations for new CakePHP feature sets

概要

主な機能

Generates CakePHP-compliant Phinx migration files and table structures
Architects multi-tenant database patterns for SaaS applications
Provides advanced indexing strategies and query performance tuning
Implements standard business patterns like Audit Trails and Soft Deletes
Optimizes data types and constraints for MySQL/MariaDB environments
2 GitHub stars

ユースケース

Refactoring legacy database tables into normalized relational structures
Building a multi-tenant SaaS platform with isolated customer data
Generating complex database migrations for new CakePHP feature sets