jooq-mcp — Claude Code MCP server for jOOQ docs
This MCP server gives AI agents tools to look up jOOQ documentation and SQL examples. Connect it when an agent needs help with the DSL, code generation, or database support.
claude mcp add --transport sse jooq-mcp https://jooq-mcp.martinelli.ch/sseWhat jooq-mcp does
jooq-mcp exposes tools for searching jOOQ documentation, retrieving SQL examples for particular operations, and looking up code-generation guidance or database support. Other tools cover Query DSL references and advanced jOOQ topics.
The server runs on Spring Boot with Spring AI. It keeps documentation locally and searches it with a full-text index that scores results using TF-IDF. Code examples are extracted automatically. Local builds require Java 21 or later and Maven 3.6 or later, so both must be available before following the run instructions.
What it helps with
- look up a jOOQ documentation topic
- find an SQL example for a jOOQ operation
- check which databases jOOQ supports
- get guidance on jOOQ code generation
- find a reference for a Query DSL statement
Example prompts for the agent
- Find out how to create a SELECT statement with jOOQ.
- Show me a jOOQ example for an INSERT operation.
- Which databases does jOOQ support?
How to install jooq-mcp
Platform CLI: remote server
claude mcp add --transport sse jooq-mcp https://jooq-mcp.martinelli.ch/sseCodex
Codex connects MCP servers over stdio and streamable HTTP only, and this server speaks SSE
Config file
{
"mcpServers": {
"jooq-mcp": {
"url": "https://jooq-mcp.martinelli.ch/sse"
}
}
}Config file
{
"servers": {
"jooq-mcp": {
"type": "sse",
"url": "https://jooq-mcp.martinelli.ch/sse"
}
}
}Platform CLI: remote server
gemini mcp add -t sse jooq-mcp https://jooq-mcp.martinelli.ch/sseStep by step, with commands for each platform: How to add an MCP server to Claude Code, Codex, Cursor, VS Code, Gemini CLI and more
Questions about jooq-mcp
How do I install jooq-mcp in Claude Code?
Run claude mcp add --transport sse jooq-mcp https://jooq-mcp.martinelli.ch/sse. This registers the server over SSE.
What does jooq-mcp do?
It gives an agent tools to search jOOQ documentation and retrieve SQL examples, code-generation guidance, and database support details.
What do I need to run jooq-mcp locally?
You need Java 21 or later and Maven 3.6 or later. Build with ./mvnw clean install, then start the app with ./mvnw spring-boot:run.
