jooq-persistence-test

jooq-persistence-test is a skill for Claude Code from AI-Unified-Process/marketplace. It costs 220 tokens per session (571 once invoked), scanned A, original, Apache-2.0.

A guide for testing jOOQ repositories against a real temporary database. jOOQ is a Java library for writing database queries with generated, type-checked code, and Flyway migrations define the database structure.

In plain words
What is it for?
It helps test every query used by a use case, including allowed and rejected data rows, using PostgreSQL or the project's database and test migrations.
Why use it?
It catches errors in queries, mappings, and database conditions that tests using mocked repositories may miss.

Skill for Claude Code

Written for Claude Code: $ARGUMENTS substitution.

Part of the aiup-core plugin — 29 skills, 1 agent shipped together

Good fit It helps test every query used by a use case, including allowed and rejected data rows, using PostgreSQL or the project's database and test migrations.

Compare 6 skills from other repositories ↓
Install with agentmods
npx agentmods add skills/ai-unified-process/marketplace/jooq-persistence-test
Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent
npx skills add AI-Unified-Process/marketplace --skill jooq-persistence-test
Clone the repo
git clone --depth 1 https://github.com/AI-Unified-Process/marketplace

Made for: Claude Code.

Or install aiup-core, the plugin that ships this one along with the rest of its 29 skills, 1 agent.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for jooq-persistence-test

README.md
[![agentmods](https://agentmods.dev/badge/skills/ai-unified-process/marketplace/jooq-persistence-test/github.svg)](https://agentmods.dev/skills/ai-unified-process/marketplace/jooq-persistence-test)
Your own site
<a href="https://agentmods.dev/skills/ai-unified-process/marketplace/jooq-persistence-test"><img src="https://agentmods.dev/badge/skills/ai-unified-process/marketplace/jooq-persistence-test/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for jooq-persistence-test

Your own site · 80×15
<a href="https://agentmods.dev/skills/ai-unified-process/marketplace/jooq-persistence-test"><img src="https://agentmods.dev/badge/skills/ai-unified-process/marketplace/jooq-persistence-test.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 220 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 571 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00220 $0.00571
Opus 5.5 $0.00088 $0.00228
Sonnet 5.5 $0.00044 $0.00114
Haiku 4.5 $0.00022 $0.00057

Measured today against content hash d2d336e47ca0, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, from the pricing page.

Security

Grade A, and why

jooq-persistence-test scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured today.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

aiup-core/evals/scenario-17/layer-skills/jooq-persistence-test/SKILL.md · 46 lines

What it actually says

jOOQ Persistence Test

Instructions

Write the repository tests of the use case $ARGUMENTS against a Testcontainers PostgreSQL database with the real Flyway migrations. Name the class UC<id><Name>RepositoryTest and annotate every method with @UseCase.

Run Directly or from /use-case-test

Run from /use-case-test, this skill follows that skill's sections "If Tests for This Use Case Already Exist", "When a Test Fails", and "Which Layer Tests What"; it does not repeat them. The specification is the oracle: take every expected value from it, never from what the code returns.

What to Test

Every query the use case's steps run and every condition that carries a UC-XXX BR-YYY marker, with an allowed and a rejected row. Below a Vaadin Flow, REST, or service integration layer these queries are already exercised; /use-case-test runs this skill only when it is named or tests of this use case already exist here.

Markers

Keep this skill's rows in the Markers table of docs/architecture/stack.md exactly as references/markers.md lists them: add them when they are missing, correct them when they differ. Touch no other row.

Files

What ships with it

1 file beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. today First seen · 46 lines · 220 tokens per session scan A d2d336e47ca0

Subscribe to this mod's changes

jooq-persistence-test is a skill published in the GitHub repository AI-Unified-Process/marketplace (150 stars, last pushed yesterday), licensed Apache-2.0. It adds 220 tokens to every session and 571 once invoked, about $0.0009 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-10-25.

Related

Other skills, from other repositories

review-prs

Review a GitHub pull request in the googleapis/mcp-toolbox repo against the team's reviewer checklist: PR title/description conventions, linked issue, logic errors and unhandled edge cases, breaking changes, test coverage, docs updates, security (input handling), and new dependencies. Use whenever a maintainer asks…

googleapis/mcp-toolbox · 162 tokens

fix-failing-tests

Diagnose a failing test in the googleapis/mcp-toolbox repo and land a fix by reasoning from the actual error: read the failure, reproduce it, shrink it until the cause is forced into the open, then fix the cause. Use this whenever a test or CI job is red, a build breaks after a change, many packages fail at once, or a…

googleapis/mcp-toolbox · 87 tokens

reproduce-bug

Reproduce a reported bug in googleapis/mcp-toolbox and decide whether it is real, delivering an evidence-backed verdict: confirmed, already fixed, misconfiguration, client-side, works as intended, not reproducible, or blocked. Use whenever a maintainer asks you to reproduce, verify, confirm, or investigate a bug…

googleapis/mcp-toolbox · 130 tokens

azure-cosmos-db-py

Build Azure Cosmos DB NoSQL services with Python/FastAPI following production-grade patterns. Use when implementing database client setup with dual auth (DefaultAzureCredential + emulator), service layer classes with CRUD operations, partition key strategies, parameterized queries, or TDD patterns for Cosmos. Triggers…

microsoft/skills · 96 tokens

Drizzle ORM Testing

Testing patterns for Drizzle ORM covering migration testing, query builder testing, transaction testing, and database integration testing with PostgreSQL, SQLite, and MySQL.

PramodDutta/qaskills · 36 tokens

finance-weekly-outlook

Generate a source-backed weekly financial trading outlook from daily-finance, finance-core-analysis, and finance-explosive-article outputs plus fresh authoritative market data. Use when the user asks for future-one-week market outlook, weekly bullish/bearish sectors, stock picks, China A-share and US stock coverage…

digoal/blog · 122 tokens