Agent Skills: Doctrine Fetch Modes (Symfony)

Optimize Doctrine fetching with DTO hydration (SELECT NEW; partial removed in ORM 3), lazy loading, query hints, and DBAL 4 access

UncategorizedID: makfly/superpowers-symfony/doctrine-fetch-modes

Install this agent skill to your local

pnpm dlx add-skill https://github.com/dev-toolings/superpowers-symfony/tree/HEAD/content/skills/doctrine-fetch-modes

Skill Files

Browse the full folder contents for doctrine-fetch-modes.

Download Skill

Loading file tree…

content/skills/doctrine-fetch-modes/SKILL.md

Skill Metadata

Name
doctrine-fetch-modes
Description
Optimize Doctrine fetching with DTO hydration (SELECT NEW; partial removed in ORM 3), lazy loading, query hints, and DBAL 4 access

Doctrine Fetch Modes (Symfony)

Use when

  • Designing entity relations or schema evolution.
  • Improving Doctrine correctness/performance.

Default workflow

  1. Model ownership/cardinality and transactional boundaries.
  2. Apply mapping/schema changes with migration safety.
  3. Tune fetch/query behavior for hot paths.
  4. Verify lifecycle behavior with targeted tests.

Guardrails

  • Keep owning/inverse sides coherent.
  • Avoid destructive migration jumps in one release.
  • Eliminate accidental N+1 and over-fetching.

Progressive disclosure

  • Use this file for execution posture and risk controls.
  • Open references when deep implementation details are needed.

Output contract

  • Entity/migration changes.
  • Integrity and performance decisions.
  • Validation outcomes and rollback notes.

References

  • reference.md
  • docs/complexity-tiers.md