MCP Examples and Advanced Usage

JIRA & Confluence Integration

Installation:

# Using Docker (recommended)docker pull ghcr.io/sooperset/mcp-atlassian:latest

Configuration:

{
    "mcpServers":
    {
        "mcp-atlassian":
        {
            "command": "docker",
            "args":
            [
                "run",
                "-i",
                "--rm",
                "-e",
                "CONFLUENCE_URL",
                "-e",
                "CONFLUENCE_USERNAME",
                "-e",
                "CONFLUENCE_API_TOKEN",
                "-e",
                "JIRA_URL",
                "-e",
                "JIRA_USERNAME",
                "-e",
                "JIRA_API_TOKEN",
                "ghcr.io/sooperset/mcp-atlassian:latest"
            ],
            "env":
            {
                "CONFLUENCE_URL": "<https://your-company.atlassian.net/wiki>",
                "CONFLUENCE_USERNAME": "[email protected]",
                "CONFLUENCE_API_TOKEN": "your_confluence_api_token",
                "JIRA_URL": "<https://your-company.atlassian.net>",
                "JIRA_USERNAME": "[email protected]",
                "JIRA_API_TOKEN": "your_jira_api_token"
            }
        }
    }
}

Usage Examples:

"Create a JIRA ticket for the authentication bug in the login system"
"Search Confluence for documentation about our API rate limiting"
"What are my assigned JIRA tickets for this sprint?"
"Update the project roadmap page in Confluence with the new milestone dates"

GitHub Integration

Installation:

npm install -g @modelcontextprotocol/server-github

Configuration:

{
    "mcpServers":
    {
        "github":
        {
            "command": "mcp-server-github",
            "args":
            [],
            "env":
            {
                "GITHUB_PERSONAL_ACCESS_TOKEN": "your_github_token"
            }
        }
    }
}

Usage Examples:

"Show me recent pull requests on the main repository"
"Create a new issue for the performance optimization task"
"What are the open issues assigned to me?"
"Check the commit history for the authentication module"

PostgreSQL Database

Installation:

npm install -g @modelcontextprotocol/server-postgres

Configuration:

{
    "mcpServers":
    {
        "postgres":
        {
            "command": "mcp-server-postgres",
            "args":
            [],
            "env":
            {
                "POSTGRES_CONNECTION_STRING": "postgresql://user:pass@localhost:5432/dbname"
            }
        }
    }
}

Usage Examples:

"Show me the schema for the users table"
"Find all customers who haven't logged in for 30 days"
"What's the average order value for this month?"
"Check for any foreign key constraints on the products table"

Troubleshooting

Check Tabnine Logs

In VS Code:

  1. Press Ctrl+Shift+P (or Cmd+Shift+P on Mac)

  2. Type “Tabnine: Open logs”

  3. Look for MCP-related error messages

Common Issues and Solutions

❌ “Cannot connect to MCP server”

# Check if Docker is running (for Docker-based servers)docker ps
# Verify network connectivityping api.github.com
# Test credentials manuallycurl -H "Authorization: token YOUR_TOKEN" <https://api.github.com/user>

❌ “Authentication failed”

  • Verify API tokens are correct and not expired

  • Check that user permissions are sufficient

  • Ensure environment variables are set correctly

❌ “MCP server not found”

  • Verify the server is installed correctly

  • Check the command path in configuration

  • Ensure all dependencies are installed

Debugging Steps

  1. Validate Configuration:

    # Check JSON syntaxcat .mcp_servers | python -m json.tool
  2. Test Server Manually:

    # For Docker-based serversdocker run -it --rm -e JIRA_URL="$JIRA_URL" ghcr.io/sooperset/mcp-atlassian:latest
  3. Check Permissions:

    # Verify file permissionsls -la .mcp_servers

Advanced Configuration

Multiple MCP Servers

Configure multiple services in one file:

{
    "mcpServers":
    {
        "jira":
        {
            "command": "docker",
            "args":
            [
                "run",
                "-i",
                "--rm",
                "-e",
                "JIRA_URL",
                "-e",
                "JIRA_API_TOKEN",
                "mcp-jira:latest"
            ],
            "env":
            {
                "JIRA_URL": "${JIRA_URL}",
                "JIRA_API_TOKEN": "${JIRA_API_TOKEN}"
            }
        },
        "github":
        {
            "command": "mcp-server-github",
            "args":
            [],
            "env":
            {
                "GITHUB_PERSONAL_ACCESS_TOKEN": "${GITHUB_TOKEN}"
            }
        },
        "postgres":
        {
            "command": "mcp-server-postgres",
            "args":
            [],
            "env":
            {
                "POSTGRES_CONNECTION_STRING": "${DATABASE_URL}"
            }
        }
    }
}

Custom MCP Servers

Create your own MCP server for internal tools:

{
    "mcpServers":
    {
        "internal-api":
        {
            "command": "node",
            "args":
            [
                "./scripts/internal-mcp-server.js"
            ],
            "env":
            {
                "INTERNAL_API_KEY": "${INTERNAL_API_KEY}",
                "API_BASE_URL": "<https://internal-api.company.com>"
            }
        }
    }
}

Team Setup

Shared Configuration

For team environments, create a shared configuration template:

{
    "mcpServers":
    {
        "team-jira":
        {
            "command": "docker",
            "args":
            [
                "run",
                "-i",
                "--rm",
                "-e",
                "JIRA_URL",
                "-e",
                "JIRA_API_TOKEN",
                "mcp-atlassian:latest"
            ],
            "env":
            {
                "JIRA_URL": "<https://company.atlassian.net>",
                "JIRA_USERNAME": "${USER_EMAIL}",
                "JIRA_API_TOKEN": "${USER_JIRA_TOKEN}"
            }
        }
    }
}

Environment Setup Script

Create a setup script for new team members:

#!/bin/bash
# setup-mcp.sh
echo "Setting up MCP for Tabnine Agents..."
# Copy template
cp .mcp_servers.template mcp_servers.json
# Set environment variables
echo "Please set the following environment variables:"
echo "export JIRA_API_TOKEN='your_token'"
echo "export GITHUB_TOKEN='your_token'"
# Install dependencies
npm install -g @modelcontextprotocol/server-github

Real-World Workflows

Development Workflow

Sprint Planning:

"Check my assigned JIRA tickets for the current sprint"
"Create a branch for the user authentication feature"
"What are the acceptance criteria for ticket AUTH-123?"

Code Review Process:

"Create a pull request for the authentication feature"
"What feedback did I receive on my last PR?"
"Merge the approved changes to main branch"

Bug Tracking:

"Create a JIRA ticket for the login timeout issue"
"Search for similar authentication bugs in our database"
"Update the bug report with the root cause analysis"

Documentation Workflow

Knowledge Management:

"Search Confluence for our API documentation standards"
"Create a new page documenting the webhook implementation"
"Update the onboarding guide with the new security requirements"

Project Documentation:

"Document the new microservice architecture in Confluence"
"Update the deployment guide with Docker instructions"
"Create a troubleshooting guide for common database issues"

Data Analysis Workflow

Database Queries:

"Show me the top 10 customers by order volume this quarter"
"Find all incomplete orders from the last 48 hours"
"What's the average response time for our API endpoints?"

Performance Monitoring:

"Check for any slow queries in the performance schema"
"Analyze user engagement metrics for the new feature"
"Generate a report of system health metrics"

Advanced Use Cases

CI/CD Integration

{
    "mcpServers":
    {
        "jenkins":
        {
            "command": "mcp-server-jenkins",
            "args":
            [],
            "env":
            {
                "JENKINS_URL": "<https://ci.company.com>",
                "JENKINS_TOKEN": "${JENKINS_API_TOKEN}"
            }
        }
    }
}

Usage:

"Trigger a build for the staging environment"
"Check the status of the latest deployment pipeline"
"Deploy the feature branch to the testing environment"

Monitoring and Alerting

{
    "mcpServers":
    {
        "grafana":
        {
            "command": "mcp-server-grafana",
            "args":
            [],
            "env":
            {
                "GRAFANA_URL": "<https://monitoring.company.com>",
                "GRAFANA_API_KEY": "${GRAFANA_API_KEY}"
            }
        }
    }
}

Usage:

"Show me the current system performance metrics"
"Check for any active alerts in the monitoring system"
"Generate a performance report for the last 24 hours"

Customer Support Integration

{
    "mcpServers":
    {
        "zendesk":
        {
            "command": "mcp-server-zendesk",
            "args":
            [],
            "env":
            {
                "ZENDESK_SUBDOMAIN": "company",
                "ZENDESK_EMAIL": "${SUPPORT_EMAIL}",
                "ZENDESK_TOKEN": "${ZENDESK_API_TOKEN}"
            }
        }
    }
}

Usage:

"Check for high-priority support tickets"
"Create a ticket for the reported API issue"
"Update the customer about the bug fix deployment"

Last updated

Was this helpful?