Agent skill

511 Frameworks Micronaut Jdbc

by jabrena in jabrena/plinth

A skill your agent uses when you need programmatic JDBC in Micronaut — pooled DataSource, parameterized SQL, io.micronaut.transaction.annotation.Transactional, batching, and domain exception…

Apache-2.0Auto-check passedDatabases

Install 511 Frameworks Micronaut Jdbc

skills CLI
$ npx skills add jabrena/plinth --skill 511-frameworks-micronaut-jdbc -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install jabrena/plinth 511-frameworks-micronaut-jdbc --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/jabrena/plinth.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/511-frameworks-micronaut-jdbc .claude/skills/511-frameworks-micronaut-jdbc && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
511-frameworks-micronaut-jdbc
GitHub stars
447
Token cost
~872 tokens
SKILL.md length
328 words
Files
2 (incl. references)
Skills in repo
124
Repo updated
First seen
Licence
Apache-2.0

At a glance

A skill your agent uses when you need programmatic JDBC in Micronaut — pooled DataSource, parameterized SQL, io.micronaut.transaction.annotation.Transactional, batching, and domain exception…

  • You need programmatic JDBC in Micronaut — pooled DataSource
  • SKILL.md covers Constraints, When to use this skill, Workflow and Reference
  • Calls mvn
  • Parameterized SQL

What it does

511 Frameworks Micronaut Jdbc is an agent skill from jabrena/plinth. 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 datasource usage in…

Its SKILL.md is about 870 tokens, which your agent loads only when the skill is triggered. The skill folder holds 2 other files, including reference files (for example `references/511-frameworks-micronaut-jdbc.md`).

It sits in Databases, covering SQL and Translation. It works with SQL. The repository describes itself as: Plinth is an AI-native engineering toolkit for modern Java enterprise SDLC, built around reusable Commands, Agents, Skills, and MCP Servers. The licence is Apache-2.0.

When your agent uses it

  • You need programmatic JDBC in Micronaut — pooled DataSource
  • Parameterized SQL
  • Io.micronaut.transaction.annotation.Transactional
  • Domain exception translation

Example prompts

  • “/511-frameworks-micronaut-jdbc”

What it can do on your machine

Read from SKILL.md and the folder at commit dca88dc. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Shell commands in SKILL.md call:

    • mvn

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

511 Frameworks Micronaut Jdbc loads about 872 tokens when it runs, and up to ~8.8k if it reads all its reference files. Until then it costs about 147 tokens; SKILL.md has 328 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~147
When it runs · the whole SKILL.md, loaded when a task matches
~872
With references · SKILL.md plus every file in references/, read only if the agent opens them
~8.8k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from jabrena/plinth at commit dca88dc, republished under its Apache-2.0 licence (© jabrena). 328 words, ~872 tokens.

Download SKILL.mdSave it as .claude/skills/511-frameworks-micronaut-jdbc/SKILL.md (or your agent's skills folder). This skill also uses 1 other file; get the full folder from GitHub.
name
511-frameworks-micronaut-jdbc
description
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 datasource usage in Micronaut JDBC. Part of Plinth Toolkit
license
Apache-2.0
metadata.author
Juan Antonio Breña Moral
metadata.version
0.19.0

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

  1. Read reference and assess project context

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

  1. Gather scope and decide target improvements

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

  1. Apply framework-aligned changes

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

  1. 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.

© jabrena, Apache-2.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 1 other file (references) in skills/511-frameworks-micronaut-jdbc of jabrena/plinth.

  • SKILL.md
  • references/511-frameworks-micronaut-jdbc.md

Open the folder on GitHubat commit dca88dc

Compare with similar skills

511 Frameworks Micronaut Jdbc next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

511 Frameworks Micronaut Jdbc compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
511 Frameworks Micronaut Jdbc this skilljabrena/plinth447—~872Automated safety check: PassApache-2.0
SQL To Business Logicnimrodfisher/data-analytics-skills470—~636Automated safety check: PassMIT
SQL TranslationMicrock/ordinary-claude-skills404—~1.3kAutomated safety check: PassCustom licence
SQL Translatorcriptogus/agent-evolve-network288—~735Automated safety check: PassCC-BY-SA-4.0
Forge Codegen Crudyaomindong1996/forge-admin126—~1.3kAutomated safety check: PassApache-2.0
Efcore Query Performanceatherio-danp/cde-dotnetcc109—~1.1kAutomated safety check: NotesNone

Similar skills

  • SQL To Business Logic

    nimrodfisher/data-analytics-skills

    Translate SQL queries into plain language business logic. An agent skill from nimrodfisher/data-analytics-skills.

    470 GitHub stars~636 tokensUpdated 15 days ago
    DatabasesAuto-check passed
  • SQL Translation

    Microck/ordinary-claude-skills

    Guide for adding SQL function translations to dbplyr backends.

    404 GitHub stars~1.3k tokensUpdated 1 mo ago
    DatabasesAuto-check passed
  • SQL Translator

    criptogus/agent-evolve-network

    Translates a plain-English question into a single, safe, read-only SQL query against a known schema, with assumptions made explicit.

    288 GitHub stars~735 tokensUpdated 2 days ago
    DatabasesAuto-check passed
  • Forge Codegen Crud

    yaomindong1996/forge-admin

    Generate or review Forge project code-generation output for CRUD modules.

    126 GitHub stars~1.3k tokensUpdated today
    Documents & OfficeAuto-check passed
  • Efcore Query Performance

    atherio-danp/cde-dotnetcc

    Optimize EF Core (Npgsql/PostgreSQL) queries in the .NET API — fix N+1, choose tracking modes, use compiled queries, split queries, and avoid translation traps.

    109 GitHub stars~1.1k tokensUpdated 2 mo ago
    DatabasesAuto-check: notes
  • SQL Explainer

    zhuyansen/agent-skills-hub

    Explain what a SQL query does in plain language and point out joins that may multiply rows.

    413 GitHub stars~191 tokensUpdated today
    DatabasesAuto-check passed

More from jabrena/plinth

All 124 skills in this repo
  • A skill your agent uses when you need to add or review fuzz testing for Java APIs with CATS — including contract-driven negative testing, malformed payload validation, boundary input exploration, CI…

    447 GitHub stars~874 tokensUpdated 3 days ago
    Auto-check passed
  • A skill your agent uses when you need to generate Java project diagrams — including UML sequence diagrams, UML class diagrams, C4 model diagrams, UML state machine diagrams, UML Deployment Diagrams…

    447 GitHub stars~3.1k tokensUpdated 3 days ago
    Auto-check passed
  • A skill your agent uses when you need to add or configure Maven plugins in your pom.xml — including quality tools (enforcer, surefire, failsafe, jacoco, pitest, spotbugs, pmd), security scanning…

    447 GitHub stars~3.2k tokensUpdated 3 days ago
    Auto-check passed
  • A skill your agent uses when you need to set up JMeter performance testing for a Java project — including creating the run-jmeter.sh script from the exact template, configuring load tests with…

    447 GitHub stars~842 tokensUpdated 3 days ago
    Auto-check passed
  • A skill your agent uses when you need to set up Java application profiling to detect and measure performance issues — including trusted preinstalled async-profiler v4.x setup, problem-driven…

    447 GitHub stars~903 tokensUpdated 3 days ago
    Auto-check passed
  • A skill your agent uses when you need to generate a checklist document with embedded commands inventory, following the embedded template exactly and producing INVENTORY-COMMANDS-JAVA.md in the…

    447 GitHub stars~697 tokensUpdated 3 days ago
    Auto-check passed

Works with

Questions about 511 Frameworks Micronaut Jdbc

What does 511 Frameworks Micronaut Jdbc do?

A skill your agent uses when you need programmatic JDBC in Micronaut — pooled DataSource, parameterized SQL, io.micronaut.transaction.annotation.Transactional, batching, and domain exception…. 511 Frameworks Micronaut Jdbc is an agent skill from jabrena/plinth.Transactional, batching, and domain exception translation.

When should I use 511 Frameworks Micronaut Jdbc?

511 Frameworks Micronaut Jdbc fits situations like: you need programmatic JDBC in Micronaut — pooled DataSource; parameterized SQL; io.micronaut.transaction.annotation.Transactional; domain exception translation.

How do I install 511 Frameworks Micronaut Jdbc in Claude Code?

Run `npx skills add jabrena/plinth --skill 511-frameworks-micronaut-jdbc -a claude-code`. Or copy the skill folder (skills/511-frameworks-micronaut-jdbc in jabrena/plinth) into .claude/skills/511-frameworks-micronaut-jdbc in your project. Claude Code loads it when a task matches its description.

How do I install 511 Frameworks Micronaut Jdbc in Codex?

Run `npx skills add jabrena/plinth --skill 511-frameworks-micronaut-jdbc -a codex`. Or copy the skill folder (skills/511-frameworks-micronaut-jdbc in jabrena/plinth) into .agents/skills/511-frameworks-micronaut-jdbc in your project. Codex loads it when a task matches its description.

Can I use 511 Frameworks Micronaut Jdbc in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add jabrena/plinth --skill 511-frameworks-micronaut-jdbc -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/511-frameworks-micronaut-jdbc, .gemini/skills/511-frameworks-micronaut-jdbc, .github/skills/511-frameworks-micronaut-jdbc and .opencode/skills/511-frameworks-micronaut-jdbc in your project.

What does 511 Frameworks Micronaut Jdbc need to run?

Going by SKILL.md and its folder, 511 Frameworks Micronaut Jdbc needs the command-line tools its instructions call (mvn).

Does 511 Frameworks Micronaut Jdbc access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is 511 Frameworks Micronaut Jdbc safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does 511 Frameworks Micronaut Jdbc use?

511 Frameworks Micronaut Jdbc is published under the Apache-2.0 licence (declared in SKILL.md). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does 511 Frameworks Micronaut Jdbc use?

About 872 tokens (SKILL.md is roughly 3.5k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 8k tokens, read only when the agent opens those files.

What are the alternatives to 511 Frameworks Micronaut Jdbc?

Skills that share tags, products or a category with 511 Frameworks Micronaut Jdbc: SQL To Business Logic (nimrodfisher/data-analytics-skills, 470 stars), SQL Translation (Microck/ordinary-claude-skills, 404 stars), SQL Translator (criptogus/agent-evolve-network, 288 stars) and Forge Codegen Crud (yaomindong1996/forge-admin, 126 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains 511 Frameworks Micronaut Jdbc?

jabrena (a GitHub user) maintains it in jabrena/plinth, which has 447 GitHub stars. The repository holds 124 skills in this directory. The repository was last updated on October 7, 2026.

Source: jabrena/plinth on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.