Ready to supercharge your AI agents?

Install any skill in seconds. Free to start, no credit card required.

Micronaut JDBC — programmatic SQL · jabrena | DecimalAI

jabrena/511-frameworks-micronaut-jdbc

SkillScore91Maintained

Use when you need programmatic JDBC in Micronaut — pooled DataSource, parameterized SQL, io.micronaut.transaction.annotation.Transactional, batching, and domain exception translation. This should trigger for requests such as Review JDBC or SQL data access in a Micronaut project; Improve transactions and parameter binding for Micronaut JDBC; Translate SQLException to domain exceptions or stream large result sets; Fix self-invocation bypassing @Transactional in Micronaut; Review Hikari or pooled d

codingby jabrena

Links this skill to your agents and keeps it current with the author’s updates.

Automatic

Coding pack

1 · One-time — install the CLI (docs ↗)

pip install decimalai

2 · Get the skill — writes .claude/skills/jabrena-511-frameworks-micronaut-jdbc/SKILL.md

decimalai skills pull jabrena-511-frameworks-micronaut-jdbc --out .claude/skills/

No CLI? Get the same file — curl · raw file

curl -fsSL --create-dirs -o .claude/skills/jabrena-511-frameworks-micronaut-jdbc/SKILL.md https://app.decimal.ai/s/jabrena-511-frameworks-micronaut-jdbc/SKILL.md

Raw file: /s/jabrena-511-frameworks-micronaut-jdbc/SKILL.md ↗ · machine-readable summary at /s/jabrena-511-frameworks-micronaut-jdbc.json ↗

In productionGlobal

how this skill behaves on real traffic · last 30 days

No production data for this skill yet — usage numbers appear here once agents start running it.

Anonymized aggregate across every org using this skill — proof from real production use, not a demo.

Does this skill help? · Benchmark: with vs. withoutsign in to run this on your agents

22 test cases from the publisher’s eval.yaml · each run twice on gemini-3.6-flash — with the skill injected, then without · last run 9d ago

—-3% tokens0% turns91% of whole cases pass with skill (20/22)

Test case	Without → With	Effect	Δ tokens	Δ turns
case-05	✗→✓	▲ Improved	-8%	0%
case-22	✗→✓	▲ Improved	28%	0%
case-03	✓→✓	＝ Same ✓	-24%	0%
case-04	✓→✓	＝ Same ✓	-2%	0%
case-06	✓→✓	＝ Same ✓	2%	0%

Showing 5 of 22 cases

SkillSafety

✓ 3 of 3 passed

Code scan15 of 15 checks clean

0 critical · 0 warning · 0 info — scanner v4 — 8/3/2026

live_secretremote_code_executionreverse_shelldata_exfiltrationssrf_metadataagent_snoopinganti_refusaldestructive_commandsobfuscated_unicodeunicode_homoglyphopaque_blobsuspicious_urltool_overreachtrigger_abuseprompt_injection_phrasing

IntentSafe

LLM judge · does the skill do what it claims

ContentClean

LLM judge · policy & harmful-content review

Source

Imported

jabrena / plinth

skills/511-frameworks-micronaut-jdbc/SKILL.md

View on GitHub ↗

License Apache-2.0Imported 8/3/2026Version v1Bundled 1 file

Skill contents

references/

SKILL.md

Micronaut JDBC — programmatic SQL

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

What is covered in this Skill?

Injected javax.sql.DataSource (Hikari-backed with micronaut-jdbc-hikari) 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 TransactionDefinition.Propagation (e.g. REQUIRES_NEW for independent commits)
Self-invocation pitfall: call transactional collaborators through injected beans, not this.method()
SQL text blocks for multi-line SQL (upserts, dialect-specific clauses)
When to prefer Micronaut Data (@512) 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
PREREQUISITE: Project must compile before applying JDBC improvements
SAFETY: If compilation fails, stop immediately
BLOCKING CONDITION: Compilation errors must be resolved by the user before proceeding
VERIFY: Run ./mvnw clean verify or mvn clean verify after applying improvements
BEFORE APPLYING: Read the reference for detailed rules and examples

When to use this skill

Review JDBC or SQL data access in a Micronaut project
Improve transactions and parameter binding for Micronaut JDBC
Translate SQLException to domain exceptions or stream large result sets
Fix self-invocation bypassing @Transactional in Micronaut
Review Hikari or pooled datasource usage in Micronaut JDBC

Workflow

Read reference and assess project context

Read references/511-frameworks-micronaut-jdbc.md and inspect the current project setup before proposing changes.

Gather scope and decide target improvements

Identify requested outcomes, constraints, and the minimum safe set of changes to apply.

Apply framework-aligned changes

Implement or refactor configuration/code following the reference patterns and project conventions.

Run verification and report results

Execute appropriate build/tests and summarize what changed, what was verified, and any follow-up actions.

Reference

For detailed guidance, examples, and constraints, see references/511-frameworks-micronaut-jdbc.md.

Want to see if jabrena/511-frameworks-micronaut-jdbc would activate on your phrasing? Try it before you install — no LLM call, no signup.

Latest benchmark · publisher runVerified

8/20/2026, 13:05 UTC · 22 cases

Measured on 20 comparable cases — below the 22 needed to publish a lift, so this result is shown here but not on the registry card or leaderboard.

Lift

+9%

91% vs 82%

Agent turns

1.0 vs 1.0

Tokens

-3%

1,862.55 vs 1,917.45

fail → pass · 2pass → pass · 18fail → fail · 2

Per-case results (22)

Case	Status	Duration (ms)			Turns			Tokens			Tool calls
Case	Status	Without	With	Δ	Without	With	Δ	Without	With	Δ	Without	With	Δ
case-01 Can you review and update `UserRepositoryImpl.java` in my Micronaut JDBC project? Right now it builds SQL strings via concatenation, directly processes ResultSet rows without checking boundaries safely, and throws raw database exceptions. Refactor it to use proper parameter binding, map rows into record objects, encapsulate single-item lookups safely, and convert lower-level SQL errors into domain-specific exceptions.	fail→fail	18,249	6,375	-65%	1	1	0%	3,799	1,006	-74%	0	0	—
case-02 Our Micronaut app experiences memory exhaustion while pulling large report datasets and slow throughput when saving thousands of items. Could you refactor `ReportRepository.java` to stream large query results efficiently and group inserts into batch operations?	fail→fail	24,051	5,926	-75%	1	1	0%	2,986	914	-69%	0	0	—
case-03 In my Micronaut service `OrderService.java`, I have a `@Transactional` method `createOrder()` that calls `this.auditLog()` internally, where `auditLog()` is also annotated with `@Transactional(propagation = Propagation.REQUIRES_NEW)`. However, the audit log transaction isn't committing independently when `createOrder()` fails. How should I refactor this method invocation so the transaction propagation works as expected?	pass→pass	13,141	7,166	-45%	1	1	0%	2,494	1,887	-24%	0	0	—
case-04 In my Micronaut JDBC DAO, when a duplicate key constraint fails, `PreparedStatement.executeUpdate()` throws a `SQLException`. A developer suggested letting `SQLException` bubble up directly to the controller layer so Micronaut's default exception handler can handle it. Is this recommended for domain architecture, and how should database errors be handled?	pass→pass	14,998	10,678	-29%	1	1	0%	2,457	2,419	-2%	0	0	—
case-05 I am writing a JDBC query in Micronaut to fetch user profile details. Should I create a mutable Java bean with getters/setters and populate it line-by-line inline inside `while(rs.next())`, or is there a cleaner approach for mapping ResultSet rows?	fail→pass	13,476	8,158	-39%	1	1	0%	2,401	2,198	-8%	0	0	—
case-06 We need to insert 10,000 inventory items into Postgres using standard JDBC in Micronaut. A developer wrote a loop calling `statement.executeUpdate()` for each item inside a single connection. What JDBC pattern should be used to optimize this bulk write?	pass→pass	18,655	8,107	-57%	1	1	0%	1,885	1,915	+2%	0	0	—
case-07 When querying a table with 500,000 rows in Micronaut using `javax.sql.DataSource`, our app runs out of memory because JDBC driver loads all rows into RAM at once. How should the JDBC statement be configured to stream rows efficiently?	pass→pass	13,371	11,477	-14%	1	1	0%	2,556	2,673	+5%	0	0	—
case-08 In a Micronaut service processing background tasks, we need audit logging to commit to the database even if the surrounding business transaction fails and rolls back. Which transaction propagation setting should be applied to the audit logging method?	pass→pass	5,212	4,955	-5%	1	1	0%	873	1,402	+61%	0	0	—
case-09 When fetching a customer by ID using JDBC in Micronaut, the existing code calls `rs.next()` and immediately accesses `rs.getString("name")` without checking the boolean return value. What return type and check should be used to handle missing records safely?	pass→pass	7,668	4,463	-42%	1	1	0%	1,502	1,400	-7%	0	0	—
case-10 We are writing a complex PostgreSQL upsert query (`INSERT ... ON CONFLICT DO UPDATE`) in a Micronaut JDBC repository. Developers are constructing SQL by concatenating dynamic string fragments across 15 lines. What Java language feature should be used for readable multi-line SQL queries while maintaining parameter binding?	pass→pass	17,677	4,988	-72%	1	1	0%	1,562	1,485	-5%	0	0	—
case-11 In a Micronaut application using Hikari-backed JDBC, how should JDBC database connections be acquired and managed in custom repository classes?	pass→pass	16,077	8,042	-50%	1	1	0%	2,893	2,108	-27%	0	0	—
case-12 Our team is designing a Micronaut microservice that only requires standard CRUD operations for basic entity tables without dynamic SQL construction or complex batching. Should we write manual JDBC queries with DataSource or use high-level repository interfaces?	pass→pass	13,494	7,189	-47%	1	1	0%	2,025	1,855	-8%	0	0	—
case-13 In a Micronaut search service, a query is constructed like `"SELECT * FROM products WHERE category = '" + categoryName + "'"` to handle optional parameters. What JDBC mechanism must be used instead to prevent SQL injection?	pass→pass	5,201	6,123	+18%	1	1	0%	708	1,645	+132%	0	0	—
case-14 Before applying raw JDBC persistence refactoring in a Micronaut project, what Maven build command must be executed first according to project safety rules?	pass→pass	6,397	2,164	-66%	1	1	0%	851	881	+4%	0	0	—
case-15 After completing a JDBC refactor in a Micronaut project, what Maven command must be executed to verify project build and tests?	pass→pass	4,746	1,748	-63%	1	1	0%	732	806	+10%	0	0	—
case-16 In a legacy Micronaut JDBC class, `connection.close()` is called manually in a `finally` block, but statement and result set handling sometimes throws exceptions before closing. What Java idiom guarantees proper resource cleanup for JDBC objects?	pass→pass	10,516	7,180	-32%	1	1	0%	1,825	1,748	-4%	0	0	—
case-17 Should transactional annotations in a Micronaut application be placed directly on low-level raw JDBC DAO methods or on service layer methods that coordinate business operations?	pass→pass	13,747	10,203	-26%	1	1	0%	2,243	2,233	-0%	0	0	—
case-18 When executing batch updates with programmatic JDBC in Micronaut, how should partial failure counts or batch errors be inspected?	pass→pass	16,399	7,977	-51%	1	1	0%	2,947	1,757	-40%	0	0	—
case-19 We need to write an atomic upsert statement for MySQL in a Micronaut JDBC repository. Should we write two separate SELECT and INSERT queries in Java code or use a single dialect-specific SQL clause?	pass→pass	11,775	7,124	-39%	1	1	0%	2,051	1,765	-14%	0	0	—
case-20 I am adding database schema migrations to my Micronaut application. How do I configure Flyway migration scripts in `src/main/resources/db/migration` and enable Flyway auto-execution in `application.yml`?	pass→pass	9,790	12,173	+24%	1	1	0%	1,816	2,310	+27%	0	0	—
case-21 In my Micronaut JPA/Hibernate application, I have an `@Entity` class `Department` with a `@OneToMany` relationship to `Employee`. How should I configure lazy loading and cascade types on this association?	pass→pass	14,696	9,464	-36%	1	1	0%	2,551	2,243	-12%	0	0	—
case-22 I am building a standard REST backend in Micronaut that needs basic CRUD endpoints for a `Product` entity (`findById`, `save`, `deleteById`). I want to use Micronaut Data declarative repository interfaces. How do I define the `ProductRepository` interface?	fail→pass	10,646	10,294	-3%	1	1	0%	1,977	2,521	+28%	0	0	—

These cases were also screened by the skill’s intent / safety pass.See the Trust review ↗Reproduce this benchmark in Colab ↗

How this skill was measured

DecimalAI ran this skill against gemini-3.6-flash twice over the same eval suite — once with the skill loaded and once without — and compared the two runs case by case. 22 cases were attempted, and 20 counted toward the lift figure. The other 2 produced results that are not comparable between the two arms, so they are excluded from the headline rather than averaged into it. The headline lift of +9 percentage points is the difference between those two pass rates over the 20 comparable cases. 1 case got worse with the skill loaded, and it is included in that figure.

Model measured: gemini-3.6-flash
Graded by: gemini-3.6-flash
Grading method: judged
Verification: verified
Pass rate without the skill: 81.8%
Pass rate with the skill: 90.9%
Cases attempted: 22
Cases counted toward lift: 20
Cases that regressed: 1
Skill version measured: v1
Run completed: 8/20/2026, 13:05 UTC

Measured example — same prompt, with vs. without the skill · from the benchmark run · case case-05

Prompt

I am writing a JDBC query in Micronaut to fetch user profile details. Should I create a mutable Java bean with getters/setters and populate it line-by-line inline inside `while(rs.next())`, or is there a cleaner approach for mapping ResultSet rows?

Without the skill loaded, the model failed this case. With it loaded, the same prompt on the same model passed. This is one improved case from the latest verified run; every case, including any that regressed, is in the table above.

Show both answers

SkillScore blends 4 signals1 of 4 complete

BenchmarkPass rate WITH skill on a verified run91

Live evalNeeds ≥20 evaluated traces in 30 days

AI ratingNeeds ≥10 rated traces

AdoptionNeeds ≥10 serves across ≥2 orgs in 30 days

Efficiency · separate axis (at equal correctness)+0% turns-4% tokens

Shown for transparency; not credited unless a verified run shows no correctness regression.

Backed by 1 of 4 signals — each added signal makes the score more robust.

Verified on gemini-3.6-flash · re-tested 8 days ago

Other measured skills in the registry, with their headline benchmark lift.