Skip to main content
Glama

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
METRICS_PORTNoPort for metrics HTTP server.8000
MCP_TRANSPORTNoTransport protocol for MCP communication.stdio
ENABLE_METRICSNoEnable Prometheus metrics collection.false
SNOWFLAKE_ROLENoSnowflake role to use (optional).
SNOWFLAKE_USERNoSnowflake username for private key or password authentication.
SNOWFLAKE_TOKENNoSnowflake authentication token (Bearer token) for API method or OAuth token for connector OAuth method.
SNOWFLAKE_SCHEMANoSnowflake schema name containing JIRA tables.
SNOWFLAKE_ACCOUNTNoSnowflake account identifier (e.g., your-account.snowflakecomputing.com) for connector method.
SNOWFLAKE_BASE_URLNoSnowflake API base URL (e.g., https://your-account.snowflakecomputing.com/api/v2) for REST API method.
SNOWFLAKE_DATABASENoSnowflake database name containing JIRA data.
SNOWFLAKE_PASSWORDNoSnowflake password for password authentication.
SNOWFLAKE_WAREHOUSENoSnowflake warehouse name for connector method.
SNOWFLAKE_AUTHENTICATORNoAuthentication method for connector: 'snowflake_jwt', 'snowflake', 'oauth_client_credentials', or 'oauth'.snowflake
SNOWFLAKE_OAUTH_CLIENT_IDNoOAuth client ID for client credentials flow.
SNOWFLAKE_OAUTH_TOKEN_URLNoOAuth token URL (optional) for client credentials flow.
SNOWFLAKE_PRIVATE_KEY_FILENoPath to private key file (PKCS#8 format) for JWT authentication.
SNOWFLAKE_CONNECTION_METHODNoConnection method: 'api' for REST API (default) or 'connector' for snowflake-connector-python.api
SNOWFLAKE_OAUTH_CLIENT_SECRETNoOAuth client secret for client credentials flow.
SNOWFLAKE_PRIVATE_KEY_FILE_PWDNoPrivate key password (optional) for encrypted key.

Capabilities

Features and capabilities supported by this server

CapabilityDetails
tools
{
  "listChanged": false
}
prompts
{
  "listChanged": false
}
resources
{
  "subscribe": false,
  "listChanged": false
}
experimental
{}

Tools

Functions exposed to the LLM to take actions

NameDescription
list_jira_issuesC
    Args:
        project: Filter by project key (e.g., 'SMQE', 'OSIM')
        issue_keys: List of JIRA issue keys (e.g., ['SMQE-1280', 'SMQE-1281'])
        issue_type: Filter by issue type ID
        status: Filter by issue status ID
        priority: Filter by priority ID
        limit: Maximum number of issues to return (default: 50)
        search_text: Search in summary and description fields
        timeframe: Filter issues where ANY date (created, updated, or resolved) is within last N days (default: 0 = disabled)
        components: Comma-separated list; match ANY in component name
        created_days: Filter by creation date within last N days (overrides timeframe if > 0, default: 0 = disabled)
        updated_days: Filter by update date within last N days (default: 0 = disabled)
        resolved_days: Filter by resolution date within last N days (default: 0 = disabled)
        fixed_version: Filter by fixed/target version name
        affected_version: Filter by affected version name

    Returns:
        Dictionary containing issues list and metadata
    
get_jira_issue_detailsB
    Get detailed information for multiple JIRA issues by their keys from Snowflake.

    Args:
        issue_keys: List of JIRA issue keys (e.g., ['SMQE-1280', 'SMQE-1281'])

    Returns:
        Dictionary containing detailed issue information including comments for all found issues
    
get_jira_project_summaryA
    Get a summary of all projects in the JIRA data from Snowflake.

    Returns:
        Dictionary containing project statistics
    
get_jira_issue_linksA
    Get issue links for a specific JIRA issue by its key from Snowflake.

    Args:
        issue_key: The JIRA issue key (e.g., 'SMQE-1280')

    Returns:
        Dictionary containing issue links information
    
get_jira_issues_by_sprintA
    Get all JIRA issues in a specific sprint by sprint name from Snowflake.

    Args:
        sprint_name: The name of the sprint (e.g., 'Sprint 256')
        limit: Maximum number of issues to return (default: 50)
        project: Filter by project key (e.g., 'SMQE', 'OSIM')

    Returns:
        Dictionary containing issues in the sprint and metadata
    

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/redhat-community-ai-tools/jira-mcp-snowflake'

If you have feedback or need assistance with the MCP directory API, please join our Discord server