redhat-community-ai-tools/jira-mcp-snowflake

本页由 AI 翻译，技术细节请以原文为准。查看原文

9 stars 13 forks 质量 65 趋势 21

概览

A Model Context Protocol (MCP) server that provides access to JIRA issue data stored in Snowflake. This server enables AI assistants to query, filter, and analyze JIRA issues through a standardized interface. This MCP server connects to Snowflake to query JIRA data and provides five main tools for interacting with the data: - - Query and filter JIRA issues with various criteria - - Get detailed information for multiple issues by their keys - - Get statistics and summaries for all projects - - Get issue links for a specific JIRA issue by its key - - Get all JIRA issues in a specific sprint by sprint name The server connects to Snowflake and queries the following tables: - JIRA_ISSUE_NON_PII - Main issue data (non-personally identifiable information) - JIRA_LABEL_RHAI - Issue labels and tags - JIRA_COMMENT_NON_PII - Issue comments (non-personally identifiable information) - JIRA_COMPONENT_RHAI - JIRA project components and their metadata - JIRA_NODEASSOCIATION_RHAI - Associations...

README

以下为原文 README 节选，完整内容请查看原文。

Jira MCP Server

Overview

This MCP server connects to Snowflake to query JIRA data and provides five main tools for interacting with the data:

list_jira_issues - Query and filter JIRA issues with various criteria
get_jira_issue_details - Get detailed information for multiple issues by their keys
get_jira_project_summary - Get statistics and summaries for all projects
get_jira_issue_links - Get issue links for a specific JIRA issue by its key
get_jira_issues_by_sprint - Get all JIRA issues in a specific sprint by sprint name

Features

Data Sources

The server connects to Snowflake and queries the following tables:

JIRA_ISSUE_NON_PII - Main issue data (non-personally identifiable information)
JIRA_LABEL_RHAI - Issue labels and tags
JIRA_COMMENT_NON_PII - Issue comments (non-personally identifiable information)
JIRA_COMPONENT_RHAI - JIRA project components and their metadata
JIRA_NODEASSOCIATION_RHAI - Associations between JIRA entities (issues, components, versions)
JIRA_PROJECTVERSION_NON_PII - Project versions (fix versions and affected versions)
JIRA_ISSUELINK_RHAI - Links between JIRA issues
JIRA_ISSUELINKTYPE_RHAI - Types of issue links
JIRA_CUSTOMFIELDVALUE_NON_PII - Custom field values (e.g., sprint information)
JIRA_SPRINT_RHAI - Sprint data
JIRA_CHANGEGROUP_RHAI - Change history groups
JIRA_CHANGEITEM_RHAI - Individual change items (e.g., status changes)

Note: Table names are expected to exist in your configured Snowflake database and schema.

Available Tools

1. List Issues (`list_jira_issues`)

Query JIRA issues with optional filtering:

Project filtering - Filter by project key (e.g., ‘SMQE’, ‘OSIM’)
Issue keys filtering - Filter by specific issue keys (e.g., [‘SMQE-1280’, ‘SMQE-1281’])
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
Component filtering - Filter by component names (comma-separated, matches any)
Version filtering - Filter by fixed version or affected version name
Date filtering - Filter by creation, update, or resolution date within last N days
Timeframe filtering - Filter issues where any date (created, updated, or resolved) is within last N days
Result limiting - Control number of results returned (default: 50)

Returns issue information including:

Basic issue information (summary, description, status, priority)
Timestamps (created, updated, due date, resolution date)
Metadata (votes, watches, environment, components)
Associated labels and links
Fixed and affected versions

在 GitHub 查看完整 README

安装

This server does not publish a one-line install command.

Open the repository installation guide 新手？先看 mcpskill.org 教程 →

配置

{
  "mcpServers": {
    "jira-mcp-snowflake": {
      "command": "podman",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e", "SNOWFLAKE_CONNECTION_METHOD=api",
        "-e", "SNOWFLAKE_TOKEN=your_token_here",
        "-e", "SNOWFLAKE_BASE_URL=https://your-account.snowflakecomputing.com/api/v2",
        "-e", "SNOWFLAKE_DATABASE=your_database_name",
        "-e", "SNOWFLAKE_SCHEMA=your_schema_name",
        "-e", "MCP_TRANSPORT=stdio",
        "-e", "ENABLE_METRICS=true",
        "-e", "METRICS_PORT=8000",
        "localhost/jira-mcp-snowflake:latest"
      ]
    }
  }
}