aguide-api-quarkus

Senior PostgreSQL + Java Quarkus backend specialist. Use when: designing or evolving PostgreSQL schemas via Flyway migrations; modeling JPA/Panache entities; defining entity relationships (OneToOne, OneToMany, ManyToMany); writing advanced SQL (CTEs, window functions, indexes); creating seed/fixture SQL scripts; writing safe targeted DELETE scripts respecting FK constraints; diagnosing entity mapping or migration conflicts; designing REST API layers (controllers, DTOs, mappers, services) aligned with the DB model.

Complete user messaging feature (conversations, messages, participants) in Java Quarkus backend. Analyzes existing code, identifies gaps, implements missing components following project architecture. Use for: finishing usermessage package, fixing messaging bugs, validating business logic, ensuring API contract compliance.