jira-mcp-server-by-cdata

What is jira-mcp-server-by-cdata?

jira-mcp-server-by-cdata is a read-only Model Context Protocol (MCP) server built by CData. It uses the CData JDBC Driver for Jira to expose Jira data as relational SQL models, allowing LLMs like Claude Desktop to query live Jira information through natural language questions without writing SQL.

How to use jira-mcp-server-by-cdata?

Clone the repository, build the JAR with Maven (mvn clean install), install and license the CData JDBC Driver for Jira, create a .prp file with your JDBC connection string, then configure Claude Desktop by editing claude_desktop_config.json to point to the JAR and property file. Restart Claude Desktop to see the new MCP server.

Key features of jira-mcp-server-by-cdata

• Read-only access to live Jira data via natural language
• CData JDBC Driver translates Jira APIs into SQL tables
• Provides three tools: get_tables, get_columns, and run_query
• Runs over stdio transport, same‑machine only
• Supports any data source compatible with the CData JDBC Driver ecosystem

Use cases of jira-mcp-server-by-cdata

• Ask an LLM about open tickets in a Jira project
• Query correlations between Jira issues and custom fields
• Retrieve live Jira data without writing API calls or SQL queries
• Integrate Jira data into AI‑powered dashboards or workflows

FAQ from jira-mcp-server-by-cdata

What does jira-mcp-server-by-cdata do?

It allows LLMs (like Claude Desktop) to ask questions about Jira data – e.g., "How many open tickets do I have in the SUPPORT project?" – and get answers by querying the live Jira instance through a read‑only MCP interface.

Is this server read-only?

Yes. This project builds a read-only MCP server. For full create, read, update, delete, and action capabilities, CData offers a separate free beta MCP Server for Jira with simplified setup.

What dependencies are required?

You need Java (with java on PATH), Maven to build the project, and the CData JDBC Driver for Jira (separately downloaded and licensed – trial or paid key). The server runs on Windows, Mac, or Linux.

How do I get a license for the JDBC Driver?

After installing the JDBC Driver JAR, run java -jar cdata.jdbc.jira.jar --license and enter your name, email, and "TRIAL" for a trial or your purchased license key. Then use the Connection String utility to generate your JDBC URL.

Can I use this server with a remote client?

No. The server communicates over stdio and can only be used with clients running on the same machine (e.g., Claude Desktop on your local computer).