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

•

Database Management

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.

Key Features

01Generates CakePHP-compliant Phinx migration files and table structures

02Architects multi-tenant database patterns for SaaS applications

03Provides advanced indexing strategies and query performance tuning

04Implements standard business patterns like Audit Trails and Soft Deletes

05Optimizes data types and constraints for MySQL/MariaDB environments

062 GitHub stars

Use Cases

01Refactoring legacy database tables into normalized relational structures

02Building a multi-tenant SaaS platform with isolated customer data

03Generating complex database migrations for new CakePHP feature sets

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add masanao-ohba/claude-manifests php-cakephp

For use in Claude.ai and ChatGPT

Download Skill