MCP Servers for Cursor AI

This repository contains Model Context Protocol (MCP) server setups for Cursor AI, enabling integration with external tools and databases.

Available MCP Servers

1. PostgreSQL MCP Server

A full-featured Model Context Protocol (MCP) server that provides PostgreSQL database management capabilities. This server assists with analyzing existing PostgreSQL setups, providing implementation guidance, debugging database issues, managing schemas, migrating data, and monitoring database performance.

• Location: ./postgresql-mcp/
• Features: Database analysis, schema management, data migration, monitoring
• Source: HenkDz/postgresql-mcp-server

Main Tools

• analyze_database: Analyze PostgreSQL configuration and performance
• get_setup_instructions: Get step-by-step PostgreSQL setup guidance
• debug_database: Debug common PostgreSQL issues
• get_schema_info: Retrieve database schema information
• create_table, alter_table: Manage database tables
• export_table_data, import_table_data: Migrate data between formats
• copy_between_databases: Copy data between PostgreSQL instances
• monitor_database: Real-time monitoring of PostgreSQL metrics

Usage Examples in Cursor AI

• "Analyze my PostgreSQL database at postgresql://user:password@localhost:5432/dbname"
• "Show me the schema for the users table in my PostgreSQL database"
• "Create a new products table with id, name, price, and created_at columns"
• "Monitor my database performance and show me any queries taking longer than 30 seconds"

2. Obsidian MCP Server

A server that enables AI interaction with Obsidian.md notes and vaults through the Local REST API plugin. This allows you to search, read, and write content in your Obsidian vault directly from Cursor AI.

• Location: ./obsidian-mcp/
• Features: List files, search notes, read and write content
• Source: MarkusPfundstein/mcp-obsidian
• Requires: Obsidian with the Local REST API plugin installed

Main Tools

• list_files_in_vault: List all files in your Obsidian vault
• list_files_in_dir: List files in a specific directory
• get_file_contents: Get the content of a specific note
• simple_search: Search your vault for text matches
• complex_search: Advanced search with pattern matching
• patch_content: Insert content into existing notes
• append_content: Add content to new or existing notes
• batch_get_file_contents: Retrieve multiple files at once

Usage Examples in Cursor AI

• "List all files in my Obsidian vault"
• "Get the content of my note called 'Project Requirements'"
• "Search my vault for all mentions of 'machine learning'"
• "Create a new note called 'Meeting Summary' with a summary of the latest project meeting"
• "Add today's tasks to my 'Daily Notes' file under the heading 'Tasks'"

3. n8n MCP Server

A server that provides integration with n8n instances via the n8n API, enabling workflow management and execution directly from Cursor AI. Built with the MCP SDK for standardized communication.

• Location: ./n8n-mcp/
• Features: List workflows, manage workflow state, execute workflows, view executions
• Requires: n8n instance with API access
• Implementation: Uses the Model Context Protocol SDK with Zod validation

Main Tools

• mcp_list_workflows: List all workflows in the n8n instance
• mcp_get_workflow: Get details of a specific workflow by ID
• mcp_activate_workflow: Activate a specific workflow by ID
• mcp_deactivate_workflow: Deactivate a specific workflow by ID
• mcp_execute_workflow: Execute a specific workflow with optional input data
• mcp_list_workflow_executions: List executions for a specific workflow
• mcp_get_execution: Get details of a specific execution by ID

Usage Examples in Cursor AI

• "List all workflows in my n8n instance"
• "Show me the details of workflow X"
• "Activate workflow Y so it starts listening for triggers"
• "Execute workflow Z with this input data"
• "Show me all recent executions of workflow X"
• "Get the execution details for run ABC"

Setup Instructions

Prerequisites

• Node.js 18 or higher
• Python 3.11 or higher with pip
• Obsidian.md with Local REST API plugin installed (for Obsidian integration)
• PostgreSQL database (for PostgreSQL integration)
• n8n instance with API access (for n8n integration)

PostgreSQL Server Setup

1. Navigate to the PostgreSQL MCP directory:

   cd postgresql-mcp
   

2. Install dependencies and build:

   npm install
   npm run build
   

3. The server will be built to build/index.js

Obsidian Server Setup

1. Install the Local REST API plugin in Obsidian:

   • Open Obsidian settings → Community plugins
   • Browse for "Local REST API" and install
   • Enable the plugin and copy the API key from settings

2. Navigate to the Obsidian MCP directory:

   cd obsidian-mcp
   

3. Install the package in development mode:

   pip install -e .
   

4. Set your API key in .env file or in the MCP configuration

n8n Server Setup

1. Set up an n8n instance and create an API key:

   • Log in to your n8n instance
   • Go to Settings → API
   • Create a new API key with appropriate permissions
   • Copy the API key

2. Navigate to the n8n MCP directory:

   cd n8n-mcp
   

3. Install dependencies and build:

   npm install
   npm run build
   

4. Set your n8n URL and API key in .env file or in the MCP configuration

Configuration for Cursor AI

Edit your Cursor AI MCP configuration file at ~/.cursor/mcp.json:

{
  "mcpServers": {
    "postgresql-mcp": {
      "command": "node",
      "args": ["/path/to/mcp-servers/postgresql-mcp/build/index.js"],
      "env": {
        "PG_DB_MAP": "{\"db1\":\"postgresql://username:password@hostname:5432/database_name?sslmode=require\",\"analytics\":\"postgresql://analytics_user:secure_password@analytics-db.example.com:5432/analytics?sslmode=require\",\"default\":\"db1\"}"
      }
    },
    "mcp-obsidian": {
      "command": "/path/to/python/bin/mcp-obsidian",
      "args": [],
      "env": {
        "OBSIDIAN_API_KEY": "your_api_key_here"
      }
    },
    "n8n-mcp": {
      "command": "node",
      "args": ["/path/to/mcp-servers/n8n-mcp/build/index.js"],
      "env": {
        "N8N_BASE_URL": "https://your-n8n-instance.example.com",
        "N8N_API_KEY": "your_api_key_here"
      }
    }
  }
}

Replace paths, connection details, and API keys with your actual values.

Debugging

Log Files

• PostgreSQL MCP logs: ~/Library/Logs/Cursor/mcp-server-postgresql-mcp.log
• Obsidian MCP logs: ~/Library/Logs/Cursor/mcp-server-mcp-obsidian.log
• n8n MCP logs: ~/Library/Logs/Cursor/mcp-server-n8n-mcp.log

Using MCP Inspector

For PostgreSQL:

npx @modelcontextprotocol/inspector node /path/to/postgresql-mcp/build/index.js

For Obsidian:

npx @modelcontextprotocol/inspector /path/to/python/bin/mcp-obsidian

For n8n:

npx @modelcontextprotocol/inspector node /path/to/n8n-mcp/build/index.js

Security Considerations

• PostgreSQL connection strings contain sensitive credentials - use environment variables when possible
• The Obsidian MCP server has read/write access to your notes - review permissions carefully
• The n8n API key provides access to your workflows - use an API key with appropriate permissions
• All servers run locally on your machine and don't expose services to the network by default