Jira MCP Snowflake MCP Server

A Model Context Protocol (MCP) server that provides access to JIRA issue data stored in Snowflake. This server enables AI assistants to query

Local serverstdioPython

What is the Jira MCP Snowflake MCP Server?

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

The short version

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

What it needs from you

  • Python 3.10+ - UV (Python package manager) - Podman or Docker - Access to Snowflake with appropriate credentials

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

ToolWhat it does
Timestampscreated, updated, due date, resolution date)
Metadatavotes, watches, environment, components, workflow ID, security, archived status)
Commentswith comment body, creation/update timestamps, and role level)
found_issuesDictionary of found issues keyed by issue key
not_foundList of issue keys that were not found
total_foundNumber of issues found
total_requestedNumber of issues requested

How to install the Jira MCP Snowflake MCP Server

{
  "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"
      ]
    }
  }
}

From the project documentation. Replace placeholders and example paths before connecting.

Configuration

  • Python 3.10+ - UV (Python package manager) - Podman or Docker - Access to Snowflake with appropriate credentials

Example prompts to try

  • “Use Jira MCP Snowflake to Required.”
  • “Use Jira MCP Snowflake to Optional.”
  • “Use Jira MCP Snowflake to Building.”

Frequently asked questions

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 Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.