---
title: "aiup-jooq"
description: "AI Unified Process persistence layer: jOOQ repositories, projections, and repository tests"
canonical: https://agentpluginsdirectory.com/plugins/aiup-jooq
last-updated: 2026-10-24
---

# aiup-jooq
AI Unified Process persistence layer: jOOQ repositories, projections, and repository tests
- Slug: aiup-jooq
- Publisher: Simon Martinelli
- Repository: https://github.com/AI-Unified-Process/marketplace
- Manifest: aiup-jooq/plugin.json
- Version: 3.0.1
- Category (editorial): other
- Skills: 2 (jooq-persistence-test, jooq-persistence)
- MCP servers: 2 (JavaDocs, jOOQ)
- Stars: 150
- Repository created: 2026-02-28
- Repository last pushed: 2026-10-24
- Publisher type: Organization
- Listing: https://agentpluginsdirectory.com/plugins/aiup-jooq
- Schema: https://agent-plugins.org/schemas/1.0.0/plugin.schema.json

## What aiup-jooq does, in the publisher's words

aiup-jooq is the AI Unified Process layer plugin for the persistence layer with jOOQ: type-safe repositories over the classes jOOQ generates from the Flyway migrations, and their tests against a real database. It is one plugin of a layer combination; it builds neither the schema nor services or UI.

- /jooq-persistence UC-001: one @Repository per aggregate with an injected DSLContext; projections into Java records with Records.mapping, MULTISET for nested collections, paging and dynamic filters, optimistic locking for versioned entities, and jOOQ code generation from the migrations when the project has none. Business rules enforced by a query condition carry // UC-XXX BR-YYY:. Transactions stay with the service layer. Its Handover lists the repository methods and record types the service layer builds on.

From the project README, punctuation lightly normalized. Full text: https://raw.githubusercontent.com/AI-Unified-Process/marketplace/HEAD/aiup-jooq/README.md

## Skills

- jooq-persistence-test: Writes the persistence layer tests of a use case (UC-XXX) for jOOQ repositories: integration tests against a real database (Testcontainers PostgreSQL or the project's database) with @SpringBootTest or @JooqTest, test data from Flyway test migrations, expected values from the specification and the t…
- jooq-persistence: Builds the persistence layer of a use case (UC-XXX) with jOOQ: one @Repository per aggregate with an injected DSLContext, type-safe queries against the classes jOOQ generates from the Flyway migrations, projections into Java records with Records.mapping, MULTISET for nested collections, paging and…

Descriptions come from the frontmatter of each SKILL.md, punctuation lightly normalized.

## MCP servers

- JavaDocs: transport: streamable-http; url: https://www.javadocs.dev/mcp
- jOOQ: transport: streamable-http; url: https://jooq-mcp.martinelli.ch/mcp

Read from the plugin's own mcp.json. Environment variable names only, never values.