Enables querying, filtering, and analyzing JIRA issue data stored in CSV files, with tools for listing issues with various criteria, retrieving detailed information for specific issues, and generating project statistics and summaries.
Provides access to JIRA issue data exported from Snowflake, reading from CSV files containing issue data, labels, components, and comments to make this data queryable through a standardized interface.
Jira MCP Server
A Model Context Protocol (MCP) server that provides access to JIRA issue data stored in CSV files exported from Snowflake. This server enables AI assistants to query, filter, and analyze JIRA issues through a standardized interface.
Overview
This MCP server reads JIRA data from CSV files and provides three main tools for interacting with the data:
list_issues
- Query and filter JIRA issues with various criteriaget_issue_details
- Get detailed information for a specific issue by keyget_project_summary
- Get statistics and summaries for all projects
Features
Data Sources
The server reads from the following CSV files in the Snowflake_CSV/
directory:
JIRA_ISSUE_NON_PII.csv
- Main issue data (non-personally identifiable information)JIRA_LABEL_RHAI.csv
- Issue labels and tagsJIRA_COMPONENT_RHAI.csv
- Component informationJIRA_COMMENT_NON_PII.csv
- Issue comments (non-PII)
Available Tools
1. List Issues (list_issues
)
Query JIRA issues with optional filtering:
- Project filtering - Filter by project key (e.g., 'SMQE', 'OSIM')
- Issue type filtering - Filter by issue type ID
- Status filtering - Filter by issue status ID
- Priority filtering - Filter by priority ID
- Text search - Search in summary and description fields
- Result limiting - Control number of results returned (default: 50)
2. Get Issue Details (get_issue_details
)
Retrieve comprehensive information for a specific JIRA issue by its key (e.g., 'SMQE-1280'), including:
- Basic issue information (summary, description, status, priority)
- Timestamps (created, updated, due date, resolution date)
- Time tracking (original estimate, current estimate, time spent)
- Metadata (votes, watches, environment, components)
- Associated labels
3. Get Project Summary (get_project_summary
)
Generate statistics across all projects:
- Total issue counts per project
- Status distribution per project
- Priority distribution per project
- Overall statistics
Prerequisites
- Python 3.8+
- Podman or Docker
- CSV data files in
Snowflake_CSV/
directory
Installation & Setup
Local Development
- Clone the repository:
- Install dependencies:
- Ensure CSV data files are present in
Snowflake_CSV/
directory - Run the server:
Container Deployment
Building locally
To build the container image locally using Podman, run:
This will create a local image named jira-mcp-snowflake:latest
that you can use to run the server.
Running with Podman or Docker
Example configuration for running with Podman:
VS Code Continue Integration
Example configuration to add to VS Code Continue:
Usage Examples
Query Issues by Project
Search Issues by Text
Get Specific Issue Details
Get Project Overview
Environment Variables
MCP_TRANSPORT
- Transport protocol for MCP communication (default: "stdio")
Data Privacy
This server is designed to work with non-personally identifiable information (non-PII) data only. The CSV files should be sanitized to remove any sensitive personal information before use.
Dependencies
httpx
- HTTP client libraryfastmcp
- Fast MCP server frameworkaiofiles
- Asynchronous file operations
This server cannot be installed
A Model Context Protocol server that provides access to JIRA issue data stored in CSV files, enabling AI assistants to query, filter, and analyze JIRA issues through standardized tools.
Related MCP Servers
- AsecurityAlicenseAqualityProvides an interface to access and manage JIRA data through the Model Context Protocol, offering features like relationship tracking, data cleaning, and contextual insights for AI applications.Last updated -99019TypeScriptMIT License
- -securityFlicense-qualityA server implementation that allows AI models to interact with Jira through the Model Context Protocol, enabling tasks like JQL searches and retrieving issue details.Last updated -Python
- AsecurityFlicenseAqualityA Model Context Protocol server that enables integration with JIRA, allowing users to interact with JIRA tasks and issues through Claude AI assistant.Last updated -32Python
- AsecurityFlicenseAqualityA Model Context Protocol server that enables ChatGPT and other AI assistants to directly interact with JIRA issues, currently offering the ability to retrieve issue details.Last updated -TypeScript