Crud
wujun728/jun_java_plugin
一键生成完整业务模块代码（SQL/Entity/DAO/XML/Repository/Service/Controller/Mapper/POJO），用于创建新的业务功能
A skill your agent uses when you need framework-agnostic SQL guidance — schema naming, relational table design, query readability, indexes, transactions, database security, migrations, testing, and…
Install 704 Technologies SQL
$ npx skills add jabrena/plinth --skill 704-technologies-sql -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install jabrena/plinth 704-technologies-sql --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/704-technologies-sql .claude/skills/704-technologies-sql && 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 "704-technologies-sql" agent skill from https://github.com/jabrena/plinth/tree/main/skills/704-technologies-sql into .claude/skills/704-technologies-sql/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "704-technologies-sql", 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/704-technologies-sqlType 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 704-technologies-sql -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install jabrena/plinth 704-technologies-sql --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/704-technologies-sql .agents/skills/704-technologies-sql && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "704-technologies-sql" agent skill from https://github.com/jabrena/plinth/tree/main/skills/704-technologies-sql into .agents/skills/704-technologies-sql/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "704-technologies-sql", 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 704-technologies-sql -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install jabrena/plinth 704-technologies-sql --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/704-technologies-sql .cursor/skills/704-technologies-sql && 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 "704-technologies-sql" agent skill from https://github.com/jabrena/plinth/tree/main/skills/704-technologies-sql into .cursor/skills/704-technologies-sql/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "704-technologies-sql", 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/704-technologies-sql--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 704-technologies-sql -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install jabrena/plinth 704-technologies-sql --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/704-technologies-sql .gemini/skills/704-technologies-sql && 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 "704-technologies-sql" agent skill from https://github.com/jabrena/plinth/tree/main/skills/704-technologies-sql into .gemini/skills/704-technologies-sql/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "704-technologies-sql", 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 704-technologies-sqlInstalls 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 704-technologies-sql -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/704-technologies-sql .github/skills/704-technologies-sql && 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 "704-technologies-sql" agent skill from https://github.com/jabrena/plinth/tree/main/skills/704-technologies-sql into .github/skills/704-technologies-sql/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "704-technologies-sql", 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 704-technologies-sql -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 704-technologies-sql --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/704-technologies-sql .opencode/skills/704-technologies-sql && 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 "704-technologies-sql" agent skill from https://github.com/jabrena/plinth/tree/main/skills/704-technologies-sql into .opencode/skills/704-technologies-sql/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "704-technologies-sql", 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
704-technologies-sql- GitHub stars
- 445
- Token cost
- ~1k tokens
- SKILL.md length
- 420 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 framework-agnostic SQL guidance — schema naming, relational table design, query readability, indexes, transactions, database security, migrations, testing, and…
- You need framework-agnostic SQL guidance — schema naming
- SKILL.md covers Constraints, When to use this skill, Workflow and Reference
- Calls mvn
- Relational table design
What it does
704 Technologies SQL is an agent skill from jabrena/plinth. Use when you need framework-agnostic SQL guidance — schema naming, relational table design, query readability, indexes, transactions, database security, migrations, testing, and monitoring — without choosing Spring Boot, Quarkus, or Micronaut. This should trigger for requests such as Review SQL schema or migrations; Improve SQL query performance and readability; Design relational tables and indexes; Review database transaction, security, or monitoring practices. Part of Plinth Toolkit
Its SKILL.md is about 1k tokens, which your agent loads only when the skill is triggered. The skill folder holds 2 other files, including reference files (for example `references/704-technologies-sql.md`).
It sits in Databases, covering SQL and Plain language and style rules. It works with SQL, Spring Boot and Java. 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 framework-agnostic SQL guidance — schema naming
- Relational table design
- Query readability
- Database security
Example prompts
- “/704-technologies-sql”
What it can do on your machine
Read from SKILL.md and the folder at commit 5130f45. 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
704 Technologies SQL loads about 1k tokens when it runs, and up to ~3k if it reads all its reference files. Until then it costs about 128 tokens; SKILL.md has 420 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 5130f45, republished under its Apache-2.0 licence (© jabrena). 420 words, ~1,009 tokens.
Download SKILL.mdSave it as
.claude/skills/704-technologies-sql/SKILL.md (or your agent's skills folder). This skill also uses 1 other file; get the full folder from GitHub.- name
- 704-technologies-sql
- description
- Use when you need framework-agnostic SQL guidance — schema naming, relational table design, query readability, indexes, transactions, database security, migrations, testing, and monitoring — without choosing Spring Boot, Quarkus, or Micronaut. This should trigger for requests such as Review SQL schema or migrations; Improve SQL query performance and readability; Design relational tables and indexes; Review database transaction, security, or monitoring practices. Part of Plinth Toolkit
- license
- Apache-2.0
- metadata.author
- Juan Antonio Breña Moral
- metadata.version
- 0.19.0
SQL best practices
Help teams create maintainable, secure, and performant SQL for Java applications across relational database engines.
What is covered in this Skill?
- Naming conventions for tables, columns, indexes, constraints, views, triggers, and routines
- Relational table design: keys, constraints, timestamps, soft deletes, normalization, and dialect-aware data types
- Query writing: readable formatting, explicit column lists, joins, CTEs, bind parameters, and execution-plan review
- Index strategy: foreign keys, filter/sort paths, composite indexes, over-indexing risks, and index lifecycle
- Security, transactions, migrations, testing, and monitoring practices for production database work
Scope: Framework-agnostic SQL quality. For Java data-access APIs, defer to the matching JDBC, Spring Data JDBC, Panache, or Micronaut Data skill.
Constraints
Keep recommendations at the SQL and database-design layer unless the user explicitly asks for Java framework integration. After editing this repository's XML sources, regenerate skills and verify the build.
- MANDATORY: Run
./mvnw compileormvn compilebefore proposing Java or Maven changes in the same change set - SQL INJECTION: Never concatenate untrusted input into SQL strings; use bind parameters through the application's data-access API
- DIALECTS: Call out database-specific syntax and portability trade-offs when using PostgreSQL, MySQL, Oracle, SQL Server, H2, or another engine
- FRAMEWORK: Defer Spring JDBC to
@311-frameworks-spring-jdbc, Quarkus JDBC to@411-frameworks-quarkus-jdbc, Micronaut JDBC to@511-frameworks-micronaut-jdbc, and framework-specific migrations to the matching Flyway skill - VERIFY: Run
./mvnw clean verifyormvn clean verifybefore promoting changes - EDGE CASE: If the target database dialect, migration tool, or production constraint is missing and affects the recommendation, ask a clarifying question before editing SQL
- EDGE CASE: If requested changes conflict with data safety, backwards compatibility, or zero-downtime deployment constraints, explain the trade-off and ask for confirmation
Show full SKILL.md (148 more words)Show less
When to use this skill
- Review SQL schema or migrations
- Improve SQL query performance and readability
- Design relational tables and indexes
- Review database transaction, security, or monitoring practices
- Apply SQL best practices to database DDL or DML
Workflow
- Read reference and assess database context
Read references/704-technologies-sql.md and inspect current schema, migrations, SQL queries, tests, and database configuration before proposing changes.
- Identify dialect and operational constraints
Confirm the target database engine, migration tool, data volume expectations, availability requirements, and compatibility constraints that shape the SQL design.
- Apply SQL-aligned changes
Implement or refactor SQL artifacts following the reference patterns and project conventions, keeping Java framework integration out of scope unless explicitly requested.
- Run verification and report results
Execute appropriate build, migration, SQL validation, and test checks; summarize what changed, what was verified, and any remaining database risks.
Reference
For detailed guidance, examples, and constraints, see references/704-technologies-sql.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/704-technologies-sql of jabrena/plinth.
- SKILL.md
- references/704-technologies-sql.md
Open the folder on GitHubat commit 5130f45
Compare with similar skills
704 Technologies SQL 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 |
|---|---|---|---|---|---|---|
| 704 Technologies SQL this skilljabrena/plinth | 445 | — | ~1k | Automated safety check: Pass | Apache-2.0 | |
| Crudwujun728/jun_java_plugin | 240 | — | ~2.8k | Automated safety check: Pass | None | |
| Docs WriterFoundationDB/fdb-record-layer | 675 | — | ~925 | Automated safety check: Pass | Apache-2.0 | |
| DBoracle/skills | 872 | — | ~1.4k | Automated safety check: Pass | UPL-1.0 | |
| Sankhya Dashboard HTML Jsp Custom Best Praticessickn33/agentic-awesome-skills | 47k | 2 repos | ~4.3k | Automated safety check: Pass | MIT | |
| Bigtable Basicsgoogle/skills | 21k | — | ~1.3k | Automated safety check: Pass | Apache-2.0 |
Similar skills
Docs Writer
FoundationDB/fdb-record-layer
Write or update documentation in docs/sphinx/source/. An agent skill from FoundationDB/fdb-record-layer.
- Official
DB
oracle/skills
Oracle Database guidance for SQL, PL/SQL, SQLcl, ORDS, Oracle Vector SDK, administration, app development, performance, security, migrations, and agent-safe database workflows.
Sankhya Dashboard HTML Jsp Custom Best Pratices
sickn33/agentic-awesome-skills
This skill should be used when the user asks for patterns, best practices, creation, or fixing of Sankhya dashboards using HTML, JSP, Java, and SQL.
- Official
Bigtable Basics
google/skills
Assists in provisioning instances/tables, designing performant schemas, and querying data in Bigtable.
Jeecg Onlform
jeecgboot/skills
JeecgBoot Online表单（cgform）全生命周期管理——通过API自动创建/编辑数据库表和表单配置， 支持单表、主子表、树表，26种控件类型，以及JS/Java/SQL增强、权限配置、数据CRUD、积木报表集成。
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 704 Technologies SQL
What does 704 Technologies SQL do?
A skill your agent uses when you need framework-agnostic SQL guidance — schema naming, relational table design, query readability, indexes, transactions, database security, migrations, testing, and…. 704 Technologies SQL is an agent skill from jabrena/plinth. Use when you need framework-agnostic SQL guidance — schema naming, relational table design, query readability, indexes, transactions, database security, migrations, testing, and monitoring — without choosing Spring Boot, Quarkus, or Micronaut.
When should I use 704 Technologies SQL?
704 Technologies SQL fits situations like: you need framework-agnostic SQL guidance — schema naming; relational table design; query readability; database security.
How do I install 704 Technologies SQL in Claude Code?
Run `npx skills add jabrena/plinth --skill 704-technologies-sql -a claude-code`. Or copy the skill folder (skills/704-technologies-sql in jabrena/plinth) into .claude/skills/704-technologies-sql in your project. Claude Code loads it when a task matches its description.
How do I install 704 Technologies SQL in Codex?
Run `npx skills add jabrena/plinth --skill 704-technologies-sql -a codex`. Or copy the skill folder (skills/704-technologies-sql in jabrena/plinth) into .agents/skills/704-technologies-sql in your project. Codex loads it when a task matches its description.
Can I use 704 Technologies SQL 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 704-technologies-sql -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/704-technologies-sql, .gemini/skills/704-technologies-sql, .github/skills/704-technologies-sql and .opencode/skills/704-technologies-sql in your project.
What does 704 Technologies SQL need to run?
Going by SKILL.md and its folder, 704 Technologies SQL needs the command-line tools its instructions call (mvn).
Does 704 Technologies SQL 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 704 Technologies SQL 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 704 Technologies SQL use?
704 Technologies SQL 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 704 Technologies SQL use?
About 1k tokens (SKILL.md is roughly 4k 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 2k tokens, read only when the agent opens those files.
What are the alternatives to 704 Technologies SQL?
Skills that share tags, products or a category with 704 Technologies SQL: Crud (wujun728/jun_java_plugin, 240 stars), Docs Writer (FoundationDB/fdb-record-layer, 675 stars), DB (oracle/skills, 872 stars) and Sankhya Dashboard HTML Jsp Custom Best Pratices (sickn33/agentic-awesome-skills, 47k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains 704 Technologies SQL?
jabrena (a GitHub user) maintains it in jabrena/plinth, which has 445 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.