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

1. Clone the repository:

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

2. Install dependencies:

   npm install

3. Install Python dependencies:

   pip3 install requests pyyaml urllib3

4. Create .env file:

   cp .env.example .env

5. 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

6. 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)

1. Locate your Cursor MCP configuration file:

   • macOS: ~/.cursor/mcp.json

   • Windows: %APPDATA%\.cursor\mcp.json

   • Linux: ~/.cursor/mcp.json

2. 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"
         }
       }
     }
   }

3. 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)

4. Save the file and restart Cursor IDE

5. 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

1. Open Cursor IDE

2. Go to Settings → Features → Model Context Protocol

3. Add a new MCP server with:

   • Name: Jira Context MCP

   • URL: http://localhost:3000/sse (requires server to be running separately)

4. Click Connect

Method 3: Using Command Palette

1. Open Command Palette (Cmd+Shift+P / Ctrl+Shift+P)

2. Type "Connect to MCP Server"

3. 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.