Jira Assets

You are using a read-only MCP server that exposes Jira Assets data via the MCP interface. This server lets you query live Jira Assets data supported by the CData JDBC Driver without writing SQL, enabling natural language questions to obtain up-to-date information from your Jira Assets instance.

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

mvn clean install

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

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

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

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

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

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=

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

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.

Available tools

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.