Crud
wujun728/jun_java_plugin
一键生成完整业务模块代码（SQL/Entity/DAO/XML/Repository/Service/Controller/Mapper/POJO），用于创建新的业务功能
A skill your agent uses when you need to write or review programmatic JDBC with Spring — including JdbcClient (Spring Framework 7+) as the default API, JdbcTemplate only where batch/streaming APIs…
Install 311 Frameworks Spring Jdbc
$ npx skills add jabrena/plinth --skill 311-frameworks-spring-jdbc -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install jabrena/plinth 311-frameworks-spring-jdbc --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/jabrena/plinth.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/311-frameworks-spring-jdbc .claude/skills/311-frameworks-spring-jdbc && rm -rf skills-srcUse ~/.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/
Install the "311-frameworks-spring-jdbc" agent skill from https://github.com/jabrena/plinth/tree/main/skills/311-frameworks-spring-jdbc into .claude/skills/311-frameworks-spring-jdbc/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "311-frameworks-spring-jdbc", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/jabrena/plinth/tree/main/skills/311-frameworks-spring-jdbcType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add jabrena/plinth --skill 311-frameworks-spring-jdbc -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install jabrena/plinth 311-frameworks-spring-jdbc --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/jabrena/plinth.git skills-src && mkdir -p .agents/skills && cp -r skills-src/skills/311-frameworks-spring-jdbc .agents/skills/311-frameworks-spring-jdbc && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "311-frameworks-spring-jdbc" agent skill from https://github.com/jabrena/plinth/tree/main/skills/311-frameworks-spring-jdbc into .agents/skills/311-frameworks-spring-jdbc/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "311-frameworks-spring-jdbc", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add jabrena/plinth --skill 311-frameworks-spring-jdbc -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install jabrena/plinth 311-frameworks-spring-jdbc --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/jabrena/plinth.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/skills/311-frameworks-spring-jdbc .cursor/skills/311-frameworks-spring-jdbc && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "311-frameworks-spring-jdbc" agent skill from https://github.com/jabrena/plinth/tree/main/skills/311-frameworks-spring-jdbc into .cursor/skills/311-frameworks-spring-jdbc/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "311-frameworks-spring-jdbc", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/jabrena/plinth.git --path skills/311-frameworks-spring-jdbc--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add jabrena/plinth --skill 311-frameworks-spring-jdbc -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install jabrena/plinth 311-frameworks-spring-jdbc --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/jabrena/plinth.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/skills/311-frameworks-spring-jdbc .gemini/skills/311-frameworks-spring-jdbc && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "311-frameworks-spring-jdbc" agent skill from https://github.com/jabrena/plinth/tree/main/skills/311-frameworks-spring-jdbc into .gemini/skills/311-frameworks-spring-jdbc/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "311-frameworks-spring-jdbc", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install jabrena/plinth 311-frameworks-spring-jdbcInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add jabrena/plinth --skill 311-frameworks-spring-jdbc -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/jabrena/plinth.git skills-src && mkdir -p .github/skills && cp -r skills-src/skills/311-frameworks-spring-jdbc .github/skills/311-frameworks-spring-jdbc && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "311-frameworks-spring-jdbc" agent skill from https://github.com/jabrena/plinth/tree/main/skills/311-frameworks-spring-jdbc into .github/skills/311-frameworks-spring-jdbc/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "311-frameworks-spring-jdbc", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add jabrena/plinth --skill 311-frameworks-spring-jdbc -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install jabrena/plinth 311-frameworks-spring-jdbc --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/jabrena/plinth.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/skills/311-frameworks-spring-jdbc .opencode/skills/311-frameworks-spring-jdbc && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "311-frameworks-spring-jdbc" agent skill from https://github.com/jabrena/plinth/tree/main/skills/311-frameworks-spring-jdbc into .opencode/skills/311-frameworks-spring-jdbc/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "311-frameworks-spring-jdbc", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
311-frameworks-spring-jdbc- GitHub stars
- 447
- Token cost
- ~975 tokens
- SKILL.md length
- 336 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 to write or review programmatic JDBC with Spring — including JdbcClient (Spring Framework 7+) as the default API, JdbcTemplate only where batch/streaming APIs…
- You need to write
- SKILL.md covers Constraints, When to use this skill, Workflow and Reference
- Calls mvn
- Review programmatic JDBC with Spring — including JdbcClient (Spring Framework 7+) as the default API
What it does
311 Frameworks Spring Jdbc is an agent skill from jabrena/plinth. Use when you need to write or review programmatic JDBC with Spring — including JdbcClient (Spring Framework 7+) as the default API, JdbcTemplate only where batch/streaming APIs require JdbcOperations, NamedParameterJdbcTemplate for legacy named-param code, parameterized SQL, RowMapper mapping to records, batch operations, transactions, safe handling of generated keys, DataAccessException handling, read-only transactions, streaming large result sets, and @JdbcTest slice testing. This should trigger for requests…
Its SKILL.md is about 980 tokens, which your agent loads only when the skill is triggered. The skill folder holds 2 other files, including reference files (for example `references/311-frameworks-spring-jdbc.md`).
It sits in Security, covering Web application vulnerabilities, Error handling and SQL. It works with Spring Boot, Java and 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 to write
- Review programmatic JDBC with Spring — including JdbcClient (Spring Framework 7+) as the default API
- JdbcTemplate only where batch/streaming APIs require JdbcOperations
- NamedParameterJdbcTemplate for legacy named-param code
Example prompts
- “/311-frameworks-spring-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
311 Frameworks Spring Jdbc loads about 975 tokens when it runs, and up to ~12k if it reads all its reference files. Until then it costs about 224 tokens; SKILL.md has 336 words of instructions outside code blocks.
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). 336 words, ~975 tokens.
Download SKILL.mdSave it as
.claude/skills/311-frameworks-spring-jdbc/SKILL.md (or your agent's skills folder). This skill also uses 1 other file; get the full folder from GitHub.- name
- 311-frameworks-spring-jdbc
- description
- Use when you need to write or review programmatic JDBC with Spring — including JdbcClient (Spring Framework 7+) as the default API, JdbcTemplate only where batch/streaming APIs require JdbcOperations, NamedParameterJdbcTemplate for legacy named-param code, parameterized SQL, RowMapper mapping to records, batch operations, transactions, safe handling of generated keys, DataAccessException handling, read-only transactions, streaming large result sets, and @JdbcTest slice testing. This should trigger for requests such as Review Java code for Spring JDBC (JdbcTemplate, JdbcClient, NamedParameterJdbcTemplate); Apply best practices for Spring JDBC data access in Java code; Detect and fix SQL injection risks in JDBC code; Improve transaction boundaries or exception handling for JDBC operations; Review JdbcClient usage in Spring Framework 7. Part of Plinth Toolkit
- license
- Apache-2.0
- metadata.author
- Juan Antonio Breña Moral
- metadata.version
- 0.19.0
Spring JDBC — JdbcClient (Spring Framework 7+)
Apply Spring JDBC guidelines with JdbcClient as the default; use JdbcTemplate / NamedParameterJdbcTemplate only for legacy code or APIs not covered by JdbcClient (batch updates, KeyHolder, RowCallbackHandler streaming).
What is covered in this Skill?
- Parameterized SQL (never concatenate user input)
- JdbcClient fluent API (Spring Framework 7+) — preferred for queries and updates
- Named parameters via JdbcClient; NamedParameterJdbcTemplate for legacy migration
- RowMapper, query(Class), and records
- Batch operations and generated keys (JdbcTemplate / JdbcOperations where needed)
- Safe handling of generated keys (KeyHolder; single-row JdbcClient updates)
- Service-layer @Transactional boundaries
- Read-only transactions (@Transactional(readOnly = true))
- Safe single-row access (optional() / findFirst() vs queryForObject)
- Streaming large result sets (RowCallbackHandler, ResultSetExtractor)
- DataAccessException handling (DuplicateKeyException, EmptyResultDataAccessException)
- @JdbcTest slice testing with @Sql fixtures
Scope: Apply recommendations based on the reference rules and good/bad code examples.
Constraints
Before applying any Spring JDBC changes, ensure the project compiles. If compilation fails, stop immediately. After applying improvements, run full verification.
- MANDATORY: Run
./mvnw compileormvn compilebefore applying any change - SAFETY: If compilation fails, stop immediately
- VERIFY: Run
./mvnw clean verifyormvn clean verifyafter applying improvements - SQL INJECTION: Never concatenate untrusted input into SQL strings — always use bind parameters
- BEFORE APPLYING: Read the reference for detailed rules and good/bad patterns
When to use this skill
- Review Java code for Spring JDBC (JdbcTemplate, JdbcClient, NamedParameterJdbcTemplate)
- Apply best practices for Spring JDBC data access in Java code
- Detect and fix SQL injection risks in JDBC code
- Improve transaction boundaries or exception handling for JDBC operations
- Review JdbcClient usage in Spring Framework 7
Workflow
- Read reference and assess project context
Read references/311-frameworks-spring-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/311-frameworks-spring-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/311-frameworks-spring-jdbc of jabrena/plinth.
- SKILL.md
- references/311-frameworks-spring-jdbc.md
Open the folder on GitHubat commit dca88dc
Compare with similar skills
311 Frameworks Spring 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.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| 311 Frameworks Spring Jdbc this skilljabrena/plinth | 447 | — | ~975 | Automated safety check: Pass | Apache-2.0 | |
| Crudwujun728/jun_java_plugin | 239 | — | ~2.8k | Automated safety check: Pass | None | |
| TS Reviewliuyanghejerry/Clausura | 204 | — | ~166 | Automated safety check: Pass | MIT | |
| Mybatis Patternsaffaan-m/ECC | 276k | — | ~4.5k | Automated safety check: Pass | MIT | |
| Java Injection Auditwgpsec/AboutSecurity | 1.8k | — | ~1.1k | Automated safety check: Pass | None | |
| Secknowledge SkillPa55w0rd/secknowledge-skill | 425 | — | ~2.7k | Automated safety check: Pass | None |
Similar skills
TS Review
liuyanghejerry/Clausura
TypeScript monorepo 审查：XSS、SQL 注入、密钥、any、console.log. An agent skill from liuyanghejerry/Clausura.
Mybatis Patterns
affaan-m/ECC
MyBatis and MyBatis-Spring patterns for mapper design, XML and annotation SQL, result mapping, dynamic SQL safety, transactions, batching, pagination, and query performance.
Java Injection Audit
wgpsec/AboutSecurity
Java 源码注入类漏洞审计。当在 Java 白盒审计中需要检测注入类漏洞时触发. An agent skill from wgpsec/AboutSecurity.
Secknowledge Skill
Pa55w0rd/secknowledge-skill
Web+AI 安全测试知识库。融合 WooYun 88,636 案例 + 先知 L1-L4 方法论 + GAARM 173 风险 + OWASP Top 10 (LLM/ASI/WSTG)。
Code Security Audit
ProgrammerAnthony/Expert-Coding-Harness
A skill your agent uses when 用户需要对代码进行安全审计、发现安全漏洞、上线前安全评估、检查代码是否存在安全风险时。触发场景：代码安全审计、安全审计、白盒审计、安全扫描、漏洞检测、漏洞挖掘、SQL注入、命令注入、XSS、SSRF、反序列化、认证绕过、越权、代码安全检查、security audit、code…
More from jabrena/plinth
All 124 skills in this repo703 Technologies Fuzzing Testing
jabrena/plinth
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…
033 Architecture Diagrams
jabrena/plinth
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…
112 Java Maven Plugins
jabrena/plinth
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…
151 Java Performance Jmeter
jabrena/plinth
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…
161 Java Profiling Detect
jabrena/plinth
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…
001 Commands Inventory
jabrena/plinth
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…
Related
Works with
Categories
Questions about 311 Frameworks Spring Jdbc
What does 311 Frameworks Spring Jdbc do?
A skill your agent uses when you need to write or review programmatic JDBC with Spring — including JdbcClient (Spring Framework 7+) as the default API, JdbcTemplate only where batch/streaming APIs…. 311 Frameworks Spring Jdbc is an agent skill from jabrena/plinth. Use when you need to write or review programmatic JDBC with Spring — including JdbcClient (Spring Framework 7+) as the default API, JdbcTemplate only where batch/streaming APIs require JdbcOperations, NamedParameterJdbcTemplate for legacy named-param code, parameterized SQL, RowMapper mapping to records, batch operations, transactions, safe handling of generated keys, DataAccessException handling, read-only transactions, streaming large result sets, and @JdbcTest slice testing.
When should I use 311 Frameworks Spring Jdbc?
311 Frameworks Spring Jdbc fits situations like: you need to write; review programmatic JDBC with Spring — including JdbcClient (Spring Framework 7+) as the default API; jdbcTemplate only where batch/streaming APIs require JdbcOperations; namedParameterJdbcTemplate for legacy named-param code.
How do I install 311 Frameworks Spring Jdbc in Claude Code?
Run `npx skills add jabrena/plinth --skill 311-frameworks-spring-jdbc -a claude-code`. Or copy the skill folder (skills/311-frameworks-spring-jdbc in jabrena/plinth) into .claude/skills/311-frameworks-spring-jdbc in your project. Claude Code loads it when a task matches its description.
How do I install 311 Frameworks Spring Jdbc in Codex?
Run `npx skills add jabrena/plinth --skill 311-frameworks-spring-jdbc -a codex`. Or copy the skill folder (skills/311-frameworks-spring-jdbc in jabrena/plinth) into .agents/skills/311-frameworks-spring-jdbc in your project. Codex loads it when a task matches its description.
Can I use 311 Frameworks Spring 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 311-frameworks-spring-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/311-frameworks-spring-jdbc, .gemini/skills/311-frameworks-spring-jdbc, .github/skills/311-frameworks-spring-jdbc and .opencode/skills/311-frameworks-spring-jdbc in your project.
What does 311 Frameworks Spring Jdbc need to run?
Going by SKILL.md and its folder, 311 Frameworks Spring Jdbc needs the command-line tools its instructions call (mvn).
Does 311 Frameworks Spring 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 311 Frameworks Spring 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 311 Frameworks Spring Jdbc use?
311 Frameworks Spring 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 311 Frameworks Spring Jdbc use?
About 975 tokens (SKILL.md is roughly 3.9k 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 11k tokens, read only when the agent opens those files.
What are the alternatives to 311 Frameworks Spring Jdbc?
Skills that share tags, products or a category with 311 Frameworks Spring Jdbc: Crud (wujun728/jun_java_plugin, 239 stars), TS Review (liuyanghejerry/Clausura, 204 stars), Mybatis Patterns (affaan-m/ECC, 276k stars) and Java Injection Audit (wgpsec/AboutSecurity, 1.8k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains 311 Frameworks Spring 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.