PocketBase Data Modeling (Advanced)

Overview

Use this only for deeper schema/migration design. Default to pocketbase-agent-orchestrator for common management tasks.

Focus

• Collection boundaries and relation modeling
• Index strategy for filters/sorts
• Safe schema evolution and staged migrations

Minimal Workflow

1. Capture expected read/write/query patterns.
2. Design schema + relations + indexes.
3. Plan additive migration, backfill, and cleanup phases.
4. Validate against auth rules and API usage.

References

• schema-patterns.md
• migration-playbook.md
• index-guidelines.md