Jira Service Management

You can query live Jira Service Management data through a local MCP server that exposes Jira Service Management data via a simple MCP interface. This lets you ask natural-language questions and receive up-to-date results without writing SQL. It uses the CData JDBC Driver to connect Jira Service Management data as relational models and serves them through MCP endpoints for easy access by AI clients.

How to use

After you start the MCP server, connect your client (for example Claude Desktop) to the local MCP endpoint. You can ask questions like “What is the status of open Jira tickets in the IT project?” or “Show me the average time to resolve issues by assignee.” The server exposes a set of tools you can invoke indirectly by asking questions; you don’t need to run SQL queries yourself. Your client will route questions to the MCP server, which returns structured results that the AI can interpret and present.

How to install

# Prerequisites
- Java (JRE/JDK) installed and available on your PATH
- Maven installed for building the MCP server

# 1. Clone the repository
git clone https://github.com/cdatasoftware/jira-service-management-mcp-server-by-cdata.git
cd jira-service-management-mcp-server-by-cdata

# 2. Build the server
mvn clean install

# This creates the JAR: CDataMCP-jar-with-dependencies.jar

# 3. Obtain and license the CData JDBC Driver for Jira Service Management
# Follow the driver installation steps and license as described by the driver provider

# 4. Prepare the JDBC connection
# Run the driver’s connection utility to generate a JDBC URL, then save it to a .prp file
java -jar cdata.jdbc.jiraservicemanagement.jar
# Configure the connection string and test, then copy the connection string for use in your .prp

# 5. Create your MCP .prp configuration
# Example content is shown in the next section

Configuration and running the MCP server

Create a configuration file named jira-service-management.prp with the JDBC connection details and accessible tables. Use the following example as a guide, replacing placeholders with your actual values.

Prefix=jiraservicemanagement
ServerName=CDataJiraServiceManagement
ServerVersion=1.0
DriverPath=/path/to/cdata.jdbc.jiraservicemanagement.jar
DriverClass=cdata.jdbc.jiraservicemanagement.JiraServiceManagementDriver
JdbcUrl=jdbc:jiraservicemanagement:InitiateOAuth=GETANDREFRESH;
Tables=

Running the MCP server

Start the MCP server using the Java runtime and your .prp configuration. The server runs in stdio mode, so you interact with it locally on the same machine.

java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/jira-service-management.prp

Notes on usage

The MCP server is designed for local, read-only access in this configuration. You can query Jira Service Management data such as tickets, projects, and related metadata through natural language prompts. The client will handle tool invocation implicitly, so you don’t need to issue explicit tool calls.

Troubleshooting

If you cannot see the MCP server or encounter data retrieval issues, ensure you have fully stopped and restarted your MCP client. Verify the .prp configuration matches the JDBC connection string obtained from the driver’s connection utility. If problems persist, check that the Jira Service Management data source is reachable and that OAuth (if used) completes in your browser. For further help, contact CData Support.

Tools and capabilities

The MCP server exposes a set of tools to explore and query the Jira Service Management data source. You can retrieve the list of tables and columns and run reads against the data source. The primary tools expose tables, columns, and query capabilities to support natural-language access to Jira data.

Available tools

jira_service_mcp_get_tables

Retrieves a list of tables available in the Jira Service Management data source. The output is provided in CSV format with the first line containing column headers.

jira_service_mcp_get_columns

Retrieves a list of columns for a specified table. The output is CSV with headers on the first line.

jira_service_mcp_run_query

Executes a SQL SELECT query against the Jira Service Management data source and returns the results.