Skip to content
MCP server

gadak

Query a local SQLite mirror of your Jira and Confluence with SQL and full-text search

Runs locallyStatus and history
Pricing
Open source
Platforms
macOS, Windows, Linux
Runs
Locally
Version
0.24.3
Listing updated
3 days ago

About gadak

gadak is an open-source MCP server for databases. It runs locally on your machine and is started by your AI client.

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.

Install

Run in a terminal

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

Add to claude_desktop_config.json

{
  "mcpServers": {
    "gadak": {
      "command": "npx",
      "args": [
        "-y",
        "https://github.com/midagedev/gadak/releases/download/v0.24.3/gadak-0.24.3.mcpb"
      ]
    }
  }
}
Install in CursorOpens Cursor, which asks you to confirm. Or add it by hand:

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "gadak": {
      "command": "npx",
      "args": [
        "-y",
        "https://github.com/midagedev/gadak/releases/download/v0.24.3/gadak-0.24.3.mcpb"
      ]
    }
  }
}
Install in VS CodeOpens VS Code, which asks you to confirm. Or add it by hand:

Add to .vscode/mcp.json

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

Add to ~/.codeium/windsurf/mcp_config.json

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

Add to your client's MCP settings (most use this shape)

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

What it does

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

Pricing

Open source

Apache-2.0, no gadak account; Atlassian costs unchanged

Prices change. Check gadak.dev before you buy.

gadak 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 to gadak

  1. REA

    MCP server

    CLI and MCP server that lets coding agents reverse engineer apps and binaries

    Runs locally
    • Open source
    • 464K GitHub stars
    • Developer tools
  2. Codebase Memory

    MCP server

    Local MCP server that builds a code knowledge graph for AI coding agents

    Runs locally
    • Open source
    • 48.7K GitHub stars
    • Knowledge and memory
  3. GitHub

    MCP server

    Official MCP server connecting AI assistants to GitHub repos, issues and workflows

    Not checked yet
    • Remote
    • Open source
    • 34.5K GitHub stars
    • Developer tools
  4. MCP toolkit giving coding agents symbol-level code retrieval and editing

    Runs locally
    • Open source
    • 31.5K GitHub stars
    • Developer tools
  5. XERJ

    MCP server

    Local search engine for AI agents with cited answers over your code and docs

    Runs locally
    • Open source
    • 19.2K GitHub stars
    • Knowledge and memory
  6. Ha MCP

    MCP server

    MCP server for managing and automating Home Assistant from AI assistants

    Runs locally
    • 8 tools
    • Open source
    • 7.9K GitHub stars
    • Productivity