411-frameworks-quarkus-jdbc SKILL.md skillA

411-frameworks-quarkus-jdbc from jabrena/plinth is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add jabrena/plinth/411-frameworks-quarkus-jdbc@v0.19.0

Pins v0.19.0 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
jabrena/plinth
Path
skills/411-frameworks-quarkus-jdbc/SKILL.md
Versions recorded
6
Latest version
v0.19.0, committed Sep 26, 2026
First version recorded
Apr 26, 2026
Size
3,310 bytes
Repository stars
461
License
Apache-2.0

Use when you need programmatic JDBC in Quarkus — Agroal DataSource, parameterized SQL, transactions, batching, and Dev Services. This should trigger for requests such as Review JDBC or SQL data access in a Quarkus project; Improve transactions and parameter binding for Quarkus JDBC; Translate SQLException to domain exceptions or stream large result sets; Fix CDI self-invocation bypassing @Transactional in Quarkus; Review Agroal DataSource usage in Quarkus JDBC. Part of Plinth Toolkit.

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# Quarkus JDBC — programmatic SQL

Apply programmatic JDBC patterns in Quarkus with safe SQL and clear transactions.

**What is covered in this Skill?**

- Injected javax.sql.DataSource (Agroal-backed) and try-with-resources for Connection / PreparedStatement
- PreparedStatement with bind parameters — never string concatenation
- Mapping ResultSet rows to Java records (dedicated mapRow method)
- Safe single-row queries with Optional<T>; never assume rs.next() succeeds
- SQLException translation to domain exceptions (catch-translate-rethrow)
- Streaming large result sets with setFetchSize to avoid OOM
- Batch updates with addBatch / executeBatch for bulk inserts
- @Transactional service boundaries and propagation types (TxType.REQUIRES_NEW for independent commits)
- CDI self-invocation pitfall: always call transactional methods through the injected proxy
- Dev Services for databases in dev/test
- When to prefer Panache (`@412`) vs raw JDBC

**Scope:** Apply recommendations based on the reference rules and good/bad code examples.

## Constraints

Compile before JDBC refactors; verify after changes.

- **MANDATORY**: Run `./mvnw compile` or `mvn compile` before applying any change
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add jabrena/plinth/411-frameworks-quarkus-jdbc@sha256:cabd301d628d1dec

The line at the top of this page pins the label v0.19.0, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_ncmsnafbjvpisks2.svg)](https://markdownregistry.com/a/art_ncmsnafbjvpisks2)

3 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 6 versions of this file, between Apr 26, 2026 and Sep 26, 2026, about one every 31 days.

versioncommittedcommitsizeaudit
v0.19.0 latest2026-09-26 9569c35 3,310 BA view · diff
v0.18.02026-08-01 26b0e71 3,310 BA view · diff
v0.17.02026-07-10 aaee915 3,310 BA view · diff
v0.16.02026-06-15 b73c9d3 3,224 BA view · diff
v0.15.02026-05-29 a800339 3,224 BA view · diff
v0.15.0-SNAPSHOT2026-04-26 819f349 3,233 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (3310 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

jabrena/plinth · 461 stars · license Apache-2.0 · pushed 2026-11-06 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_ncmsnafbjvpisks2
GET https://markdownregistry.com/api/v1/resolve?ref=jabrena/plinth/411-frameworks-quarkus-jdbc
GET https://markdownregistry.com/api/v1/blob/cabd301d628d1decf0688c6a2edb1c378e4e25193839810ca4a7fdbad07b4ce7

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from jabrena/plinth

AGENTS.md AGENTS.md file
jabrena/plinth · AGENTS.md
git:20260801.26b0e71 · audit A · 461 stars
openspec-propose SKILL.md skill
jabrena/plinth · benchmarks/problem1/scenario3/.agents/skills/openspec-propose/SKILL.md · Propose a new change with all artifacts generated in one step. Use when the user wants to quickly describe what they…
v1.0 · audit A · 461 stars
openspec-propose SKILL.md skill
jabrena/plinth · benchmarks/problem2/scenario3/.agents/skills/openspec-propose/SKILL.md · Propose a new change with all artifacts generated in one step. Use when the user wants to quickly describe what they…
v1.0 · audit A · 461 stars
001-commands-inventory SKILL.md skill
jabrena/plinth · skills/001-commands-inventory/SKILL.md · Use when you need to generate a checklist document with embedded commands inventory, following the embedded template…
v0.19.0 · audit A · 461 stars
002-agents-inventory SKILL.md skill
jabrena/plinth · skills/002-agents-inventory/SKILL.md · Use when you need to generate a checklist document with embedded agents inventory, following the embedded template…
v0.19.0 · audit A · 461 stars
003-skills-inventory SKILL.md skill
jabrena/plinth · skills/003-skills-inventory/SKILL.md · Use when you need to generate a checklist document with Java system prompts from skills.xml, following the embedded…
v0.19.0 · audit A · 461 stars
004-commands-installation SKILL.md skill
jabrena/plinth · skills/004-commands-installation/SKILL.md · Use when you need to install the embedded project commands into command directories (.github/commands…
v0.19.0 · audit A · 461 stars
005-agents-installation SKILL.md skill
jabrena/plinth · skills/005-agents-installation/SKILL.md · Use when you need to install the embedded robot agents into .github/agents, .claude/agents, .cursor/agents, or…
v0.19.0 · audit A · 461 stars
012-agile-epic SKILL.md skill
jabrena/plinth · skills/012-agile-epic/SKILL.md · Guides the creation of agile epics with comprehensive definition including business value, success criteria, and…
v0.19.0 · audit A · 461 stars
013-agile-feature SKILL.md skill
jabrena/plinth · skills/013-agile-feature/SKILL.md · Guides the creation of detailed agile feature documentation from an existing epic. Use when the user wants to split an…
v0.19.0 · audit A · 461 stars
014-agile-user-story SKILL.md skill
jabrena/plinth · skills/014-agile-user-story/SKILL.md · Guides the creation of agile user stories. Use when the user wants to create a user story. This should trigger for…
v0.19.0 · audit A · 461 stars
021-problem-framing SKILL.md skill
jabrena/plinth · skills/021-problem-framing/SKILL.md · Use when a problem or issue needs explicit framing before deeper analysis begins — establishing the Problem statement…
v0.19.0 · audit A · 461 stars

Every file in jabrena/plinth

Browse by kind, by grade A, or by owner.