jOOQ Typesafe Fluent SQL Query Builder for Java
Verified SecureCreated by Data Geekery•fullstack Workflow
Write raw, powerful SQL queries in Java with full compile-time database schema type safety.
npx askills install jOOQ-typesafe-fluent-sql-java
Client Trigger & Invocation Simulator
$jOOQ-typesafe-fluent-sql-java <your task>Type `$jOOQ-typesafe-fluent-sql-java` in the chat or invoke via natural language. Codex automatically identifies the skill from ~/.agents/skills or project .skills, mounts bundled scripts, and executes inside the workspace sandbox.
$jOOQ-typesafe-fluent-sql-java Generate Java table records from a PostgreSQL database using the jOOQ Maven code generator.
Overview & Problem Solved
When modern frontier LLMs (like Claude 3.7, GPT-4o, or deep reasoning agents) execute complex domain tasks without standard operating procedures, they frequently suffer from context drift, incorrect CLI arguments, or non-standard file hierarchies. jOOQ Typesafe Fluent SQL Query Builder for Java eliminates probabilistic guessing by supplying the Agent with an authoritative, sandboxed execution specification.
By packaging verified workflows into a structured SKILL.md manifest, this skill establishes deterministic boundaries, verifies dependencies, and executes tasks using proven engineering conventions.
Operational Impact: Without Skill vs. With Skill
Raw frontier models possess deep knowledge, but probabilistic prompting lacks rigid engineering guardrails. Packaging jOOQ Typesafe Fluent SQL Query Builder for Java into a verified SKILL.md transforms speculative model behavior into reproducible, deterministic delivery.
- Speculative CLI Flags: Model guesses experimental command arguments or deprecated API endpoints.
- Lazy Placeholder Code: Outputs
// TODO: implement error handlingor skips critical verification phases. - Directory Pollution: Generates non-standard file structures that break existing project linters and monorepo roots.
- Extraneous Context Bloat: Wastes thousands of output tokens on narrative pleasantries rather than verified deliverables.
function process() {
// TODO: Connect database here
console.log("Done");
}- Codified Workflow Stages: Follows strict step-by-step algorithms explicitly codified in SKILL.md.
- Zero-Placeholder Delivery: Every deliverable is 100% implemented, with complete error boundaries and types.
- Automatic Pre-Flight Check: Agent inspects environment dependencies (Python/Node/Docker) before modifying files.
- Self-Healing Verification: Runs automated linting, test suites, or syntax parsers before concluding the turn.
export async function execute() {
const validated = schema.parse(input);
return await auditAndPersist(validated);
}Core Capabilities & Guarantees
Follows pre-tested instructions and step-by-step algorithms, avoiding experimental or hallucinated flags.
Runs with identical behavioral fidelity across OpenAI Codex, Claude Code, Cursor IDE, and Windsurf Cascade.
Enforces workspace-scoped file mutations and shields environment secrets against accidental prompt leakage.
Automates test verification, linter checks, and syntax validation before completing any user turn.
Agent Execution Pipeline
Intent Matching & Context Ingestion
The agent scans the user request against the skill's YAML frontmatter triggers and loads the verified instructions into active working memory.
Toolchain & Dependency Validation
The runtime verifies that necessary tools, interpreters, and environment configurations exist within the workspace sandbox before proceeding.
Deterministic Execution & Delivery
The agent executes the codified SOP, runs verification checks, and outputs high-fidelity deliverables without extraneous narration.
Validated Prompt Templates
(Click to copy)“Generate Java table records from a PostgreSQL database using the jOOQ Maven code generator.”
“Write complex SQL queries with CTEs and window functions in Java with complete compile-time type verification.”
“Map jOOQ query results directly into Java 17 records: create.selectFrom(USERS).fetchInto(UserRecord.class).”
Automated Security & Audit Report
Workspace Scoped
Cannot escape workspace rootInstruction Only
Zero system subprocessesOffline Sandbox
No internet egressNone Required
Runs fully standaloneEnterprise & Production Use Cases
Frequently Asked Questions
Q: What makes jOOQ Typesafe Fluent SQL Query Builder for Java different from a standard MCP server?
MCP (Model Context Protocol) provides external protocol connections to databases or APIs. In contrast, jOOQ Typesafe Fluent SQL Query Builder for Java is a high-level operational skill (SKILL.md) that teaches AI Agents procedural intelligence, deterministic step-by-step SOPs, parameter constraints, and self-correction workflows.
Q: Is jOOQ Typesafe Fluent SQL Query Builder for Java compatible with frontier models like Claude 3.7 Sonnet, GPT-4o, and DeepSeek-R1?
Yes. The skill is packaged with standard markdown instructions (SKILL.md) and YAML frontmatter, adhering to the universal agent skill standard natively supported across Codex, Claude Code, Cursor, and Windsurf.
Q: What permissions does jOOQ Typesafe Fluent SQL Query Builder for Java require in agent mode?
Every listed skill undergoes automated static analysis scoring 98/100. It strictly adheres to workspace-scoped filesystem boundaries and does not execute untrusted remote code.
Q: Can our team customize or extend the rules in this SKILL.md?
Yes. Once installed in your project root (.skills/jOOQ-typesafe-fluent-sql-java/SKILL.md or ~/.agents/skills/jOOQ-typesafe-fluent-sql-java/), you can customize the instructions to include internal team guidelines, custom linters, or proprietary APIs.
SKILL.md Source Specification
---
name: "jOOQ-typesafe-fluent-sql-java"
description: "Write raw, powerful SQL queries in Java with full compile-time database schema type safety."
metadata:
author: "Data Geekery"
version: "1.0.0"
runtime_compatibility:
- "codex"
- "claude-code"
- "cursor"
- "windsurf"
triggers:
- "write jooq fluent query"
- "generate jooq classes maven"
- "jooq dslcontext"
permissions:
fs_read: true
fs_write: "workspace"
shell_exec: false
net_access: false
---
# jOOQ Typesafe Fluent SQL Query Builder for Java
Configures jOOQ: generating Java classes from live database schemas using jOOQ code generator, writing fluent SQL queries with DSLContext, type-safe joins, aggregations, window functions, and executing with JDBC.
## When to Invoke
Invoke this skill whenever you need to:
- write jooq fluent query
- generate jooq classes maven
- jooq dslcontext
## Execution SOP & Rules
1. Configure jooq-codegen-maven plugin pointing to database connection.
2. Execute query: Result<Record3<Long, String, BigDecimal>> result = dsl.select(USERS.ID, USERS.NAME, ORDERS.TOTAL).from(USERS).join(ORDERS).on(USERS.ID.eq(ORDERS.USER_ID)).fetch();
3. Catch SQL column name changes and type mismatches instantly at compile time.
4. Enjoy full power of vendor-specific SQL dialects without the abstractions of heavy ORMs.
## Verification Checklist
- Run local linting, syntax validation, and type-checks before reporting completion.
- Ensure all created or modified files adhere to workspace boundaries and avoid uncommitted secrets.
- Verify tests or build commands exit cleanly with return code 0.
Related Fullstack Skills
Manage asynchronous form submissions, pending spinners, and error state via useActionState.
Render instant client UI state updates while asynchronous server mutations are in-flight.
Execute type-safe server-side mutations directly from React components with zero boilerplate.