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