Jira Context MCP Server

A powerful Model Context Protocol (MCP) server that integrates Jira with Cursor IDE, enabling AI-powered issue management, sprint tracking, and library vulnerability analysis.

🚀 Features

Jira Integration: Fetch issue details, manage sprints, track progress
Sprint Management: View active sprints, generate reports, analyze backlog
Library Vulnerability Analysis: Check Maven/NPM packages for vulnerabilities and upgrade recommendations
Database Integration: Query MySQL databases directly from Cursor
Smart URL Parser: Paste any Jira board/sprint URL and get instant insights

📋 Prerequisites

Node.js 20.17.0 or higher
Python 3 (for Jira API bridge)
Python packages: requests, pyyaml, urllib3
```
pip3 install requests pyyaml urllib3
```
A Jira account with API access
Jira API token (Generate here)

⚙️ Installation

Clone the repository:

git clone https://github.com/Darshancisco/Appd_jira_context_mcp.git
cd Appd_jira_context_mcp

Install dependencies:
```
npm install
```
Install Python dependencies:
```
pip3 install requests pyyaml urllib3
```
Create .env file:
```
cp .env.example .env
```

Configure your .env file:

JIRA_BASE_URL=https://your-domain.atlassian.net
JIRA_USERNAME=your-email@example.com
JIRA_API_TOKEN=your-api-token-here
HTTP_PORT=3000

Build the project:
```
npm run build
```

🏃 Running the Server

Start the MCP server:

npm start

The server will start on http://localhost:3000/sse

🔌 Connect to Cursor IDE

Method 1: Direct Configuration in `mcp.json` (Recommended)

Locate your Cursor MCP configuration file:
- macOS: ~/.cursor/mcp.json
- Windows: %APPDATA%\.cursor\mcp.json
- Linux: ~/.cursor/mcp.json

Add the MCP server configuration:

Edit the mcp.json file and add the following configuration:

{
  "mcpServers": {  
    "jira-resolution": {
      "command": "node",
      "args": ["/absolute/path/to/Appd_jira_context_mcp/dist/index.js"],
      "cwd": "/absolute/path/to/Appd_jira_context_mcp",
      "env": {
        "JIRA_BASE_URL": "https://your-domain.atlassian.net",
        "JIRA_USERNAME": "your-email@example.com",
        "JIRA_API_TOKEN": "your-api-token-here",
        "DB_TYPE": "mysql",
        "DB_HOST": "localhost",
        "DB_PORT": "3306",
        "DB_USER": "root",
        "DB_PASSWORD": "your-database-password",
        "DB_NAME": "",
        "DB_SSL": "false"
      }
    }
  }
}

Replace the placeholders:
- "/absolute/path/to/Appd_jira_context_mcp" → Full path to where you cloned the repo
- "your-domain.atlassian.net" → Your Jira instance URL
- "your-email@example.com" → Your Jira username/email
- "your-api-token-here" → Your Jira API token
- "your-database-password" → Your MySQL password (if using database features)
Save the file and restart Cursor IDE
Verify connection:
- Open Cursor IDE
- The MCP server should automatically connect
- You can verify by typing commands in the chat

Method 2: Using Cursor Settings UI

Open Cursor IDE
Go to Settings → Features → Model Context Protocol
Add a new MCP server with:
- Name: Jira Context MCP
- URL: http://localhost:3000/sse (requires server to be running separately)
Click Connect

Method 3: Using Command Palette

Open Command Palette (Cmd+Shift+P / Ctrl+Shift+P)
Type "Connect to MCP Server"
Enter: http://localhost:3000/sse (requires server to be running separately)

Note: Method 1 (mcp.json) is recommended as it starts the server automatically and doesn't require running npm start separately.

🛠️ Available Tools

Once connected, you can use these tools in Cursor:

Jira Issue Management

get_issue - Get detailed information about a Jira issue
get_assigned_issues - Get issues assigned to you
get_issues_by_type - Filter issues by type (Bug, Story, Epic, etc.)
get_projects - List all available Jira projects
get_issue_types - List all issue types

Sprint & Board Management

analyze_jira_url - Parse any Jira URL (board/sprint/issue)
get_boards - List all agile boards
get_sprints - Get sprints for a board
get_sprint_issues - Get all issues in a sprint
get_backlog - Get backlog issues
get_sprint_report - Generate comprehensive sprint report

Library Vulnerability Tools

check_maven_library - Check Maven library for vulnerabilities
check_npm_library - Check NPM package for vulnerabilities
analyze_dependencies - Analyze project dependencies
recommend_upgrade - Get smart upgrade recommendations
get_github_release_notes - Fetch release notes for library upgrades
find_library_usage - Find where a library is used in codebase

Database Tools

list_databases - List all MySQL databases
list_db_tables - List tables in a database
get_table_schema - Get table structure
query_database - Execute SQL queries
search_table - Search across table columns

💡 Example Usage

Analyze Your Sprint Board

Analyze my sprint board: https://jira.corp.appdynamics.com/secure/RapidBoard.jspa?rapidView=2823

Check Library Vulnerability

Check if org.springframework:spring-core version 5.3.0 has any vulnerabilities

Get Assigned Issues

Show me all issues assigned to me in project ABC

Sprint Report

Generate sprint report for board 2823

📁 Project Structure

.
├── src/
│   ├── index.ts              # Application entry point
│   ├── server.ts             # MCP server implementation
│   ├── cli.ts                # CLI interface
│   ├── services/             # Core services
│   │   ├── jira.ts           # Jira API integration
│   │   ├── libraryManager.ts # Library vulnerability analysis
│   │   ├── DatabaseService.ts # MySQL integration
│   │   └── ...
│   ├── types/                # TypeScript type definitions
│   └── utils/                # Utility functions
├── dist/                     # Compiled JavaScript (generated)
├── package.json              # Dependencies
├── tsconfig.json             # TypeScript config
└── .env                      # Environment variables (create this)

🔧 Development

Run in development mode:

npm run dev

Build:

npm run build

Type checking:

npm run type-check

🐛 Troubleshooting

Server won't start

Ensure Node.js version is 20.17.0 or higher: node --version
Ensure Python 3 is installed: python3 --version
Install Python packages: pip3 install requests pyyaml urllib3
Check if port 3000 is available
Verify .env file is configured correctly (if using Method 2/3)
Run npm run build to ensure the dist/ folder exists
Ensure jira_python_bridge.py exists in the project root

Can't connect in Cursor

If using mcp.json: Make sure the paths are absolute and correct
If using HTTP mode: Make sure the server is running (npm start)
Verify the URL is http://localhost:3000/sse
Check Cursor's MCP connection settings
Restart Cursor IDE after modifying mcp.json

Jira API errors

Verify your API token is valid
Ensure JIRA_BASE_URL matches your Jira instance
Check your Jira account has necessary permissions
Make sure there are no extra spaces in your credentials

MCP server not showing tools

Run npm run build to compile TypeScript
Check console for error messages
Verify all environment variables are set correctly

🔒 Security Note

Important: The mcp.json file contains sensitive credentials (API tokens, database passwords).

Keep your mcp.json file secure and never commit it to version control
The mcp.json file is stored locally on your machine
Only you have access to these credentials
Generate API tokens with minimum required permissions

📄 License

MIT License

👤 Author

Darshan Hanumanthappa

Email: darshan.hanumanthappa@gmail.com
GitHub: @Darshancisco

🙏 Acknowledgments

Built for AppDynamics engineering team to streamline Jira workflow integration with Cursor IDE.

Appd_jira_context_mcp