About Features How to Use
Active

jOOQ MCP Server

AI-Powered Access to jOOQ Documentation

A Model Context Protocol (MCP) server that provides AI systems with intelligent access to jOOQ documentation, code examples, and database-specific guidance.

What is MCP?

Model Context Protocol (MCP) is a standardized protocol that allows AI models to interact with external tools and data sources. This MCP server specializes in providing comprehensive jOOQ documentation access, enabling AI assistants to help developers with SQL query building, database operations, and jOOQ best practices.

Available Tools

searchDocumentation

Search through jOOQ documentation using advanced full-text search with TF-IDF scoring. Find relevant information about any jOOQ feature, SQL operation, or concept quickly.

getSqlExamples

Retrieve practical SQL examples for specific operations like SELECT, INSERT, UPDATE, DELETE, and JOIN. Get real-world code snippets to accelerate development.

getCodeGenerationGuide

Access comprehensive documentation about jOOQ's code generation capabilities. Learn how to configure and use the code generator for your database schema.

getDatabaseSupport

Get database-specific information for MySQL, PostgreSQL, Oracle, SQL Server, and more. Understand dialect differences and database-specific features.

getQueryDslReference

Access detailed Query DSL reference for specific statement types. Master the jOOQ DSL with comprehensive documentation for each query type.

getAdvancedFeatures

Explore advanced jOOQ features like transactions, stored procedures, batch operations, and reactive execution patterns.

How to Use

Install in Claude Code

If you use Claude Code, you can add it with this command:

claude mcp add --transport sse jOOQ https://jooq-mcp.martinelli.ch/sse

Install using JSON

If you can't use SSE transport directly, you can use it with mcp remote:

{
  "mcpServers": {
    "jOOQ": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-remote",
        "https://jooq-mcp.fly.dev/sse",
        "--transport",
        "sse-only"
      ]
    }
  }
}

Example Queries

Once installed, you can ask questions like:

# Example queries you can ask:
"How do I create a SELECT statement in jOOQ?"
"Show me examples of jOOQ INSERT operations"
"What databases does jOOQ support?"
"How do I configure jOOQ code generation?"
"How do I use transactions in jOOQ?"