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

MCP Servers for Cursor IDE is a collection of Model-Context-Protocol servers that enhance Cursor IDE's capabilities by providing integrations with external services like PostgreSQL, Kubernetes, and PDF processing tools 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 all dependencies, builds the TypeScript project, and generates scripts for Cursor IDE integration.

3. Configure environment variables:

   # Copy the example file
   cp .env.example .env
   
   # Edit the .env file with your credentials
   nano .env
   

   Example configuration in .env:

   # PostgreSQL Configuration
   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
   
   # Kubernetes Configuration
   KUBECONFIG=/path/to/your/kubeconfig
   # Alternative Kubernetes configuration:
   # KUBE_API_URL=https://your-kubernetes-api-server
   # KUBE_API_TOKEN=your-kubernetes-service-account-token
   

Configuring Cursor IDE

To connect your MCP server to Cursor IDE:

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

Running the Servers

Using the Helper Script

Run a specific server:

npm run server -- [server-name]

Examples:

# Run PostgreSQL server
npm run server -- postgres

# Run PDF server
npm run server -- pdf

# Run Kubernetes server
npm run server -- kubernetes

Manual Execution

Start a specific server in development mode:

npm run dev -- [server-name]

Running All Servers

Launch all available servers simultaneously:

npm run dev:all

List Available Servers

View all servers that can be run:

npm run dev -- --list

Using MCP in Cursor IDE

Once your server is configured:

1. Open the composer in Cursor IDE
2. Make sure you're using agent mode (Claude 3.7 Sonnet Thinking is recommended)
3. Submit your request to Cursor

Available Servers and Tools

PostgreSQL Server

Tools:

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

Kubernetes Server

Tools:

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

PDF Server

Tools:

• read_pdf - Extracts text and form field data from PDFs
• write_pdf - Creates or modifies PDFs with content and form field updates

Testing Your Server

Before connecting to Cursor IDE, test your server:

1. Build the project:

   npm run build
   

2. Run a specific server:

   npm run start:postgres
   

3. Use the provided script for Cursor:

   /path/to/mcp-servers/cursor-mcp-server.sh [server-name]
   

   Examples:

   # Run PostgreSQL server (default)
   /path/to/mcp-servers/cursor-mcp-server.sh
   
   # Run PDF server
   /path/to/mcp-servers/cursor-mcp-server.sh pdf
   
   # Run Kubernetes server
   /path/to/mcp-servers/cursor-mcp-server.sh kubernetes
   

How to install this MCP server

For Claude Code

To add this MCP server to Claude Code, run this command in your terminal:

claude mcp add-json "jira-server" '{"command":"node","args":["path/to/mcp-servers/dist/servers/jira-server/jira-server.js"]}'

See the official Claude Code MCP documentation for more details.

For 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 > Tools & Integrations and click "New MCP Server".

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

{
    "mcpServers": {
        "jira-server": {
            "command": "node",
            "args": [
                "path/to/mcp-servers/dist/servers/jira-server/jira-server.js"
            ]
        },
        "github-server": {
            "command": "node",
            "args": [
                "path/to/mcp-servers/dist/servers/github-server/github-server.js"
            ]
        },
        "postgresql-server": {
            "command": "node",
            "args": [
                "path/to/mcp-servers/dist/servers/postgresql-server/postgresql-server.js"
            ]
        },
        "kubernetes-server": {
            "command": "node",
            "args": [
                "path/to/mcp-servers/dist/servers/kubernetes-server/kubernetes-server.js"
            ]
        }
    }
}

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 explicitly ask the agent to use the tool by mentioning the tool name and describing what the function does.

For Claude Desktop

To add this MCP server to Claude Desktop:

1. Find your configuration file:

• macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
• Windows: %APPDATA%\Claude\claude_desktop_config.json
• Linux: ~/.config/Claude/claude_desktop_config.json

2. Add this to your configuration file:

{
    "mcpServers": {
        "jira-server": {
            "command": "node",
            "args": [
                "path/to/mcp-servers/dist/servers/jira-server/jira-server.js"
            ]
        },
        "github-server": {
            "command": "node",
            "args": [
                "path/to/mcp-servers/dist/servers/github-server/github-server.js"
            ]
        },
        "postgresql-server": {
            "command": "node",
            "args": [
                "path/to/mcp-servers/dist/servers/postgresql-server/postgresql-server.js"
            ]
        },
        "kubernetes-server": {
            "command": "node",
            "args": [
                "path/to/mcp-servers/dist/servers/kubernetes-server/kubernetes-server.js"
            ]
        }
    }
}

3. Restart Claude Desktop for the changes to take effect