Cursor IDE Development Tools (Jira, GitHub, PostgreSQL) MCP server

This MCP server integrates with Cursor IDE, allowing it to connect to external services like Jira, GitHub, PostgreSQL, and Kubernetes through a standardized communication protocol.

Installation

Prerequisites

• Node.js (v16 or newer)
• npm or yarn

Setup Instructions

1. Clone the repository:

   git clone https://github.com/yourusername/mcp-servers.git
   cd mcp-servers
   

2. Install dependencies and set up the project:

   npm run setup
   

   This command installs dependencies, builds the project, and generates scripts for Cursor IDE integration.

3. Configure environment variables:

   cp .env.example .env
   

   Edit the .env file and add your credentials for each service you plan to use.

Configuring Cursor IDE

To connect the MCP servers to Cursor IDE:

1. Open Cursor IDE
2. Navigate to Settings > Features > Mcp Servers
3. Click "Add New Mcp Server"
4. Enter a name for the server (e.g., "jira", "github")
5. For "Connection Type", select "command"
6. For "command", paste the path provided by the setup script
7. Click "Save"

Available Servers

Jira Server

Configuration

Add these variables to your .env file:

JIRA_API_URL=https://your-domain.atlassian.net
[email protected]
JIRA_API_TOKEN=your-jira-api-token

Get your API token from: https://id.atlassian.com/manage-profile/security/api-tokens

Available Tools

• get_projects - Retrieves all accessible Jira projects
• get_project - Gets details about a specific project by key
• search_issues - Searches for issues using JQL (Jira Query Language)
• get_issue - Gets details about a specific issue by key
• get_boards - Retrieves all accessible boards
• get_sprints - Gets all sprints for a specific board

GitHub Server

Configuration

Add this variable to your .env file:

GITHUB_TOKEN=your-github-personal-access-token

Generate a token at: https://github.com/settings/tokens

Available Tools

• get_repositories - Retrieves all repositories accessible to the authenticated user
• get_repository - Gets details about a specific repository
• get_issues - Retrieves issues for a repository
• get_issue - Gets details about a specific issue
• get_pull_requests - Retrieves pull requests for a repository
• get_pull_request - Gets details about a specific pull request
• get_branches - Retrieves branches for a repository
• get_commits - Gets commits for a repository, optionally filtered by branch
• comment_on_pr - Adds a comment to a specific pull request
• summarize_pr_diff - Generates a summary of PR changes

PostgreSQL Server

Configuration

Add these variables to your .env file:

POSTGRES_HOST=localhost
POSTGRES_PORT=5432
POSTGRES_DB=your_database_name
POSTGRES_USER=your_username
POSTGRES_PASSWORD=your_password
# POSTGRES_SSL_MODE=require # Uncomment if SSL is required
# POSTGRES_MAX_CONNECTIONS=10 # Optional: limit connection pool size

Available Tools

• mcp__get_database_info - Retrieves information about the connected database
• mcp__list_tables - Lists all tables in the current database schema
• mcp__get_table_structure - Gets the column definitions for a specific table
• mcp__execute_query - Executes a custom SQL query against the database

Kubernetes Server

Configuration

Add these variables to your .env file:

KUBECONFIG=/path/to/your/kubeconfig
# or
# KUBE_API_URL=https://your-kubernetes-api-server
# KUBE_API_TOKEN=your-kubernetes-service-account-token

Available Tools

• get_pods - Retrieves pods from a specified namespace
• find_pods - Finds pods matching a name pattern
• kill_pod - Deletes a pod in a specified namespace
• exec_in_pod - Executes a command in a specified pod
• get_pod_logs - Retrieves logs from a specified pod

Running the Servers

Quick Start

After running npm run setup, use the individual shell scripts created for each server.

Run a Specific Server

npm run server -- [server-name]

Example:

npm run server -- github

Run All Servers

npm run dev:all

List Available Servers

npm run dev -- --list

Using MCP in Cursor IDE

1. Open the composer in Cursor IDE
2. Make sure you are using agent mode (Claude 3.7 Sonnet Thinking is recommended)
3. Submit your message to Cursor
4. The MCP server will enable Cursor to access and interact with the configured external services

How to add this MCP server to Cursor

There are two ways to add an MCP server to Cursor. The most common way is to add the server globally in the ~/.cursor/mcp.json file so that it is available in all of your projects.

If you only need the server in a single project, you can add it to the project instead by creating or adding it to the .cursor/mcp.json file.

Adding an MCP server to Cursor globally

To add a global MCP server go to Cursor Settings > MCP and click "Add new global MCP server".

When you click that button the ~/.cursor/mcp.json file will be opened and you can add your server like this:

{
    "mcpServers": {
        "cursor-rules-mcp": {
            "command": "npx",
            "args": [
                "-y",
                "cursor-rules-mcp"
            ]
        }
    }
}

Adding an MCP server to a project

To add an MCP server to a project you can create a new .cursor/mcp.json file or add it to the existing one. This will look exactly the same as the global MCP server example above.

How to use the MCP server

Once the server is installed, you might need to head back to Settings > MCP and click the refresh button.

The Cursor agent will then be able to see the available tools the added MCP server has available and will call them when it needs to.

You can also explictly ask the agent to use the tool by mentioning the tool name and describing what the function does.