{
  "markdown": "# jOOQ MCP Server\n\nA Model Context Protocol (MCP) server that provides AI models with access to jOOQ documentation. This Spring Boot application uses Spring AI to expose jOOQ documentation as MCP tools, allowing AI systems to query and retrieve information about jOOQ features, SQL examples, and best practices.\n\n## Features\n\nThe MCP server provides the following tools:\n\n- **searchDocumentation**: Search jOOQ documentation for specific topics\n- **getSqlExamples**: Get SQL query building examples for specific operations\n- **getCodeGenerationGuide**: Retrieve jOOQ code generation documentation\n- **getDatabaseSupport**: Get database-specific support information\n- **getQueryDslReference**: Get Query DSL reference for specific statement types\n- **getAdvancedFeatures**: Access documentation for advanced jOOQ features\n\n## Getting Started\n\n### Prerequisites\n\n- Java 21 or higher\n- Maven 3.6+\n\n### Running the Application\n\n1. **Clone the repository:**\n   ```bash\n   git clone <repository-url>\n   cd jooq-mcp\n   ```\n\n2. **Build the project:**\n   ```bash\n   ./mvnw clean install\n   ```\n\n3. **Run the application:**\n   ```bash\n   ./mvnw spring-boot:run\n   ```\n\nThe MCP server will start and be available for connections from MCP clients.\n\n### Docker Deployment\n\n1. **Build the JAR file:**\n   ```bash\n   ./mvnw clean package\n   ```\n\n2. **Build the Docker image:**\n   ```bash\n   docker build -t jooq-mcp .\n   ```\n\n3. **Run the Docker container:**\n   ```bash\n   docker run -p 8080:8080 jooq-mcp\n   ```\n\n### Fly.io Deployment\n\nThis application is configured for deployment on Fly.io:\n\n1. **Install Fly CLI and authenticate:**\n   ```bash\n   brew install flyctl  # or your preferred installation method\n   fly auth login\n   ```\n\n2. **Deploy the application:**\n   ```bash\n   ./mvnw clean package\n   fly deploy\n   ```\n\nThe application includes health checks at `/actuator/health` and is configured with auto-scaling.\n\n### Using with MCP Clients\n\nThis server can be used with any MCP-compatible AI client. The server exposes tools that allow AI models to:\n\n- Search jOOQ documentation by keyword\n- Retrieve specific SQL examples and code snippets\n- Access database-specific configuration information\n- Get guidance on code generation setup\n- Find information about advanced jOOQ features\n\n### Configuration\n\nThe application can be configured via `application.properties`:\n\n```properties\n# MCP Server Configuration\nspring.ai.mcp.server.name=jooq-documentation-mcp\nspring.ai.mcp.server.version=1.0.0\nspring.ai.mcp.server.type=SYNC\nspring.ai.mcp.server.capabilities.tool=true\n\n# Cache Configuration\nspring.cache.type=caffeine\nspring.cache.caffeine.spec=maximumSize=100,expireAfterWrite=1h\n\n# jOOQ Documentation Crawler Configuration\njooq.documentation.crawler.max-depth=4\njooq.documentation.crawler.max-urls-per-section=100\njooq.documentation.crawler.timeout-ms=10000\njooq.documentation.crawler.cache-duration-hours=24\n\n# Server Configuration - SSE Buffer Settings\nserver.tomcat.max-http-response-header-size=64KB\nserver.tomcat.max-swallow-size=10MB\n```\n\n### Example Usage\n\nWhen connected to an MCP client, you can ask questions like:\n\n- \"How do I create a SELECT statement in jOOQ?\"\n- \"Show me examples of jOOQ INSERT operations\"\n- \"What databases does jOOQ support?\"\n- \"How do I configure jOOQ code generation?\"\n- \"How do I use transactions in jOOQ?\"\n\nThe server will fetch the relevant documentation and provide detailed answers with code examples.\n\n## Architecture\n\nThe application consists of:\n\n- **JooqDocumentationService**: Main service class with @Tool annotated methods for MCP integration\n- **LocalJooqDocumentationService**: Provides local documentation indexing and full-text search with TF-IDF scoring\n- **InvertedIndex**: Implements advanced full-text search capabilities with relevance scoring\n- **JooqDocumentationCrawler**: Crawls and fetches jOOQ documentation for local storage\n- **JooqDocumentationFetcher**: Handles parsing and extraction of documentation content\n- **McpConfiguration**: Spring configuration for MCP tool registration\n- **Caching**: Caffeine-based caching to improve performance\n\n### Key Features\n\n- **Local Documentation Storage**: Documentation is stored locally in `src/main/resources/docs/` for faster access\n- **Full-Text Search**: Advanced search using TF-IDF scoring for better relevance\n- **Efficient Indexing**: In-memory inverted index for fast document retrieval\n- **Code Example Extraction**: Automatic extraction and categorization of code examples\n\n## Testing\n\nRun the test suite:\n\n```bash\n./mvnw test\n```\n\n## Development\n\nThe application uses:\n- Spring Boot 3.5.4\n- Spring AI 1.0.0 with MCP Server support\n- JSoup for HTML parsing\n- Caffeine for caching\n\nTo add new tools, create methods annotated with `@Tool` in the `JooqDocumentationService` class.",
  "bytes": 4791,
  "sha": "80bbbea6a49a3b16e256d6ddc57eb2de9e9c8e7e49764cf0b9d49454ccd368a5",
  "repo_slug": "martinellich/jooq-mcp",
  "fonte": "repo",
  "truncated": false,
  "api": "https://agentalog.com/api/listings/mcp_ch_martinelli_jooq_mcp_b6176ba6/readme"
}