Summary
A comprehensive reference for Ecto database patterns in Phoenix apps. Covers the full stack: schemas with proper changeset validation paired with database constraints, safe migration practices including DDL lock management, transactional workflows with Ecto.Multi, and performance concerns like N+1 preloading. The multi-tenancy section alone (prefix-based vs row-based partitioning) is worth having on hand. Particularly strong on the "don't just validate in changesets, enforce it in the database" principle that trips up developers coming from ORMs in other languages. If you're building anything beyond a toy Phoenix app, you'll reference the transaction and constraint patterns regularly.
Install to Claude Code
npx -y skills add bobmatnyc/claude-mpm-skills --skill ecto-patterns --agent claude-codeInstalls into .claude/skills of the current project.
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →
Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →
Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →
On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →
Files
SKILL.md
Select a file.
Featured
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →First SeenJun 3, 2026
