Jira Assets MCP Server

How to use

Once the MCP server is configured, your MCP client (such as Claude Desktop) can read data from Jira Assets and perform read-only queries. You interact with the built-in tools by asking natural language questions like “Show me open Jira issues assigned to me” or “What is the status distribution of assets in my project?” The server exposes tools to list tables and columns and to run read-only SELECT queries against Jira Assets. You do not need to call raw SQL unless you want to; simply ask the client questions and it will translate them into the appropriate data access operations.

Key capabilities you can rely on include the following tools, which your MCP client will invoke behind the scenes when you ask questions: - jiraassets_get_tables: Retrieves a list of available tables in the data source. - jiraassets_get_columns: Retrieves the columns for a specific table. - jiraassets_run_query: Executes a SQL SELECT query against the data source.

How to install

Follow these concrete steps to install and run the MCP server that provides read-only access to Jira Assets data.

git clone https://github.com/cdatasoftware/jira-assets-mcp-server-by-cdata.git
cd jira-assets-mcp-server-by-cdata
```

```bash
mvn clean install
```

```text
This creates the JAR file: CDataMCP-jar-with-dependencies.jar
```

```text
Download and install the CData JDBC Driver for Jira Assets: https://www.cdata.com/drivers/jiraassets/download/jdbc
```

```text
License the CData JDBC Driver by running in the driver's lib directory:
java -jar cdata.jdbc.jiraassets.jar --license
```

```text
Configure your connection to Jira Assets using the Connection String utility:
java -jar cdata.jdbc.jiraassets.jar
```

```text
Copy the resulting connection string for use in the MCP configuration.
```

```text
Create a .prp file (e.g. jira-assets.prp) with the following properties:
Prefix=jiraassets
ServerName=CDataJiraAssets
ServerVersion=1.0
DriverPath=PATH\\TO\\cdata.jdbc.jiraassets.jar
DriverClass=cdata.jdbc.jiraassets.JiraAssetsDriver
JdbcUrl=jdbc:jiraassets:InitiateOAuth=GETANDREFRESH;
Tables=
```

```text
Use Claude Desktop configuration to register the MCP server. For Windows, add an entry like:
```
{
  "mcpServers": {
    "jiraassets": {
      "command": "PATH\\TO\\java.exe",
      "args": ["-jar", "PATH\\TO\\CDataMCP-jar-with-dependencies.jar", "PATH\\TO\\jira-assets.prp"]
    }
  }
}
```

```text
For Linux/macOS, add an entry like:
```
{
  "mcpServers": {
    "jiraassets": {
      "command": "/PATH/TO/java",
      "args": ["-jar", "/PATH/TO/CDataMCP-jar-with-dependencies.jar", "/PATH/TO/jira-assets.prp"]
    }
  }
}
```

```text
Run the MCP server:
java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/jira-assets.prp
```

```text
Note: The server uses stdio and runs on the same machine as your MCP client.
`

Additional notes

Security and access: ensure your Jira Assets connection string in jira-assets.prp is kept confidential and only shared with trusted clients. If you use OAuth, you may need to complete browser-based authentication during the connection setup.

Troubleshooting: if you do not see the MCP server in your client, ensure you have fully quit and relaunched the client after configuring the MCP entry. Verify that the JDBC driver is licensed and that the Jira Assets connection works by testing the connection before starting the MCP server.

jiraassets_get_tables

Retrieves a list of tables available in the Jira Assets data source. The output is CSV with column headers.

jiraassets_get_columns

Retrieves a list of columns for a specific table. The output is CSV with column headers.

jiraassets_run_query

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