Skip to content
cccskills
FreePublished on GitHub

acc-create-query

Generates CQRS Queries and Handlers for PHP 8.5. Creates read-only query DTOs with handlers that return data without side effects. Includes unit tests.

The English summary is being prepared. Showing the original description.

See how to install

Files included (1)

  • SKILL.md3.7 KB

SKILL.md (original)

Review the instructions the agent will receive before you install.

Query Generator

Generate CQRS-compliant Queries and Query Handlers with tests.

Query Characteristics

  • Immutable: final readonly class
  • Interrogative naming: Get/Find/List + noun
  • No side effects: Handler never modifies state
  • Returns DTOs: Never returns domain entities
  • Read-optimized: Can use dedicated read models

Generation Process

Step 1: Generate Query

Path: src/Application/{BoundedContext}/Query/

  1. {Name}Query.php — Immutable query DTO with parameters

Step 2: Generate Handler

Path: src/Application/{BoundedContext}/Handler/

  1. {Name}Handler.php — Read model consumer

Step 3: Generate DTOs

Path: src/Application/{BoundedContext}/DTO/

  1. {Name}DTO.php — Result data structure
  2. PaginatedResultDTO.php — For list queries (optional)

Step 4: Generate Read Model Interface

Path: src/Application/{BoundedContext}/ReadModel/

  1. {Name}ReadModelInterface.php — Query methods contract

Step 5: Generate Tests

Path: tests/Unit/Application/{BoundedContext}/


File Placement

ComponentPath
Querysrc/Application/{BoundedContext}/Query/
Handlersrc/Application/{BoundedContext}/Handler/
DTOsrc/Application/{BoundedContext}/DTO/
Read Model Interfacesrc/Application/{BoundedContext}/ReadModel/
Unit Teststests/Unit/Application/{BoundedContext}/

Query Naming Conventions

PurposeQuery NameReturns
Single by IDGetOrderDetailsQueryDTO or throws
Single by fieldFindUserByEmailQueryDTO or null
List/CollectionListOrdersQueryPaginatedResult
SearchSearchProductsQueryarray of DTOs
CountCountPendingOrdersQueryint
Check existenceCheckEmailExistsQuerybool

Quick Template Reference

Query

final readonly class {Name}Query
{
    public function __construct(
        public {IdType} $id
    ) {}
}

Query with Pagination

final readonly class List{Name}Query
{
    public function __construct(
        public ?{FilterType} $filter = null,
        public int $limit = 20,
        public int $offset = 0,
        public string $sortBy = 'created_at',
        public string $sortDirection = 'desc'
    ) {
        if ($limit < 1 || $limit > 100) {
            throw new \InvalidArgumentException('Limit must be between 1 and 100');
        }
    }
}

Handler

final readonly class {Name}Handler
{
    public function __construct(
        private {ReadModelInterface} $readModel
    ) {}

    public function __invoke({Name}Query $query): {ResultDTO}
    {
        $result = $this->readModel->findById($query->id->value);

        if ($result === null) {
            throw new {NotFoundException}($query->id);
        }

        return $result;
    }
}

Anti-patterns to Avoid

Anti-patternProblemSolution
Side EffectsHandler modifies stateKeep read-only
Returning EntitiesLeaking domainReturn DTOs only
No ValidationInvalid parametersValidate in constructor
Unbounded ListsPerformance issuesAlways paginate
Missing Read ModelQuerying write modelUse dedicated read model

References

For complete PHP templates and examples, see:

  • references/templates.md — Query, Handler, DTO, PaginatedResult, ReadModel templates
  • references/examples.md — GetOrderDetails, ListOrders, OrderDTO examples and tests

Reviews

No reviews yet. Tell others what you thought.

Comments

No login needed. Share how it worked for you, ask a question, or note where it did not run.

No comments yet. Be the first to write one.

Comments are published right away. Do not include personal information such as email addresses or phone numbers. Up to 2 URLs.

0 / 1,000 characters

This form is protected by reCAPTCHA, and the Google Privacy Policy and Terms of Service apply.

More skills from this repository

Master backend architectures, REST API design, microservices, and server-side development across multiple languages. Use this as a central index to access specialized sub-skills.

The English summary is being prepared. Showing the original description.

MikeCheng1208/BattleTree2Updated Jul 22, 2026

在每次回复中使用固定前缀并列出本次实际参考的指令/文件,便于校验是否遵循上下文与规则。

The English summary is being prepared. Showing the original description.

MikeCheng1208/BattleTree2Updated Jul 22, 2026

Automate 21risk tasks via Rube MCP (Composio). Always search tools first for current schemas.

The English summary is being prepared. Showing the original description.

MikeCheng1208/BattleTree2Updated Jul 22, 2026

Automate 2chat tasks via Rube MCP (Composio). Always search tools first for current schemas.

The English summary is being prepared. Showing the original description.

MikeCheng1208/BattleTree2Updated Jul 22, 2026

Arquitecto de Soluciones Principal y Consultor Tecnológico de Andru.ia. Diagnostica y traza la hoja de ruta óptima para proyectos de IA en español.

The English summary is being prepared. Showing the original description.

MikeCheng1208/BattleTree2Updated Jul 22, 2026

[00] META. Orchestrate skills into dynamic chains for complex tasks. Analyzes the task, discovers available skills, builds an optimal chain, explains why each skill is needed, and executes step-by-step with user confirmation. Use for any complex task requiring multiple thinking/research/analysis steps. Triggers on "plan this", "how to approach", "what's the strategy", "build a plan", or any multi-step problem requiring skill orchestration.

The English summary is being prepared. Showing the original description.

MikeCheng1208/BattleTree2Updated Jul 22, 2026

See all skills by MikeCheng1208

Report a problem with this skill