# gadak

> gadak is an open-source MCP server for databases. Query a local SQLite mirror of your Jira and Confluence with SQL and full-text search. It runs locally on your machine and is started by your AI client.

- **Kind:** MCP server
- **Pricing:** Open source
- **Platforms:** macOS, Windows, Linux, CLI
- **Website:** https://gadak.dev
- **Repository:** https://github.com/midagedev/gadak
- **MCP Registry name:** io.github.midagedev/gadak
- **Categories:** databases, developer tools, productivity
- **Listing updated:** 2026-11-14

## About

Where Atlassian's hosted Rovo MCP runs in the cloud, gadak keeps a copy of the Jira Cloud projects and Confluence spaces you choose in one SQLite file on your own machine. Issues, comments, change history and wiki pages share one search index, so searching needs no network, and SQL can answer questions JQL cannot, such as open issues per epic with a single GROUP BY.

The author's benchmark against a live site with 3,296 issues reports the epic count taking 22 ms locally against 4,761 ms through the REST API. The same page lists the costs: a local binary, an initial sync (3.7 minutes in that test), and reads that trail Jira by one sync interval. Writes such as comments, transitions and assignments go to Jira first, and the local file is a cache you can delete.

Besides the MCP server, the same file is reachable through a desktop app, a browser tab, a CLI and a Claude Code skill. The README labels it 0.x software from one maintainer, and an agent that reads the mirror passes what it reads to its model, so scope the mirror carefully.

## Features

- **Local Jira mirror:** Copies chosen Jira projects and Confluence spaces into one SQLite file.
- **SQL over issues:** Runs aggregations and joins over issues and change history that JQL cannot express.
- **Offline full-text search:** Searches issues, comments and wiki pages with no network connection.
- **Write-through changes:** Comments, transitions and assignments go to Jira first.
- **Several front ends:** A desktop app, browser tab, CLI and Claude Code skill read the same file.
- **Selective sync:** You pick which projects and spaces get mirrored.

## Good for

- Count open issues per epic across a whole backlog
- Search tickets and wiki pages while offline
- Give a coding agent a scoped view of your backlog
- Query change history for how long issues stay in a status
- Create or transition issues from a terminal

## Install

### Claude Code (Terminal)

```sh
claude mcp add gadak -- npx -y https://github.com/midagedev/gadak/releases/download/v0.24.3/gadak-0.24.3.mcpb
```

### Claude Desktop (claude_desktop_config.json)

```json
{
  "mcpServers": {
    "gadak": {
      "command": "npx",
      "args": [
        "-y",
        "https://github.com/midagedev/gadak/releases/download/v0.24.3/gadak-0.24.3.mcpb"
      ]
    }
  }
}
```

### Cursor (~/.cursor/mcp.json)

```json
{
  "mcpServers": {
    "gadak": {
      "command": "npx",
      "args": [
        "-y",
        "https://github.com/midagedev/gadak/releases/download/v0.24.3/gadak-0.24.3.mcpb"
      ]
    }
  }
}
```

### VS Code (.vscode/mcp.json)

```json
{
  "servers": {
    "gadak": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "https://github.com/midagedev/gadak/releases/download/v0.24.3/gadak-0.24.3.mcpb"
      ]
    }
  }
}
```

### Windsurf (~/.codeium/windsurf/mcp_config.json)

```json
{
  "mcpServers": {
    "gadak": {
      "command": "npx",
      "args": [
        "-y",
        "https://github.com/midagedev/gadak/releases/download/v0.24.3/gadak-0.24.3.mcpb"
      ]
    }
  }
}
```

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "gadak": {
      "command": "npx",
      "args": [
        "-y",
        "https://github.com/midagedev/gadak/releases/download/v0.24.3/gadak-0.24.3.mcpb"
      ]
    }
  }
}
```

## FAQ

### What does it need to connect?

A Jira API token created with no scopes covers Jira and Confluence on one site. Jira Server and Data Center connect with a Personal Access Token, with the wiki off.

### How do I register the MCP server?

Run gadak mcp install claude-desktop. For Claude Code, gadak skill install adds a skill.

### Is the data live?

No. Reads reflect the last sync and trail Jira by one sync interval.

### What licence does it use?

The site says Apache-2.0, maintained by one person.

### Is gadak free?

Yes. gadak is open source, so you can use and self-host it for free.

### How do I add gadak to Claude Code?

Run this command in your terminal: claude mcp add gadak -- npx -y https://github.com/midagedev/gadak/releases/download/v0.24.3/gadak-0.24.3.mcpb

### What are the best alternatives to gadak?

The closest alternatives to gadak are REA, Codebase Memory, GitHub, Serena MCP: the IDE for your agent and XERJ.

## Alternatives

- [REA](https://ai-powered.com/mcp/rea): REA is an open-source MCP server for developer tools.
- [Codebase Memory](https://ai-powered.com/mcp/codebase-memory): Codebase Memory is an open-source MCP server for knowledge and memory.
- [GitHub](https://ai-powered.com/mcp/github-2): GitHub is an open-source MCP server for developer tools.
- [Serena MCP: the IDE for your agent](https://ai-powered.com/mcp/serena-mcp-the-ide-for-your-agent): Serena MCP: the IDE for your agent is an open-source MCP server for developer tools.
- [XERJ](https://ai-powered.com/mcp/xerj): XERJ is an open-source MCP server for knowledge and memory.
- [Ha MCP](https://ai-powered.com/mcp/ha-mcp): Ha MCP is an open-source MCP server for productivity.
- [Ouroboros](https://ai-powered.com/mcp/ouroboros): Ouroboros is an open-source MCP server for developer tools.
- [Claude Code Ultimate Guide](https://ai-powered.com/mcp/claude-code-ultimate-guide): Claude Code Ultimate Guide is an open-source MCP server for ai models and llm tooling.

---
Source: https://ai-powered.com/mcp/gadak
