Reddit Q&A to Notion MCP Server

A simple MCP server that searches Reddit for answers to questions and saves Q&A sessions to Notion.

Features

• 🔍 Search across all Reddit or specific subreddits
• 📊 Get top posts with comments for context
• 🤖 Perfect for LLM-powered Q&A workflows
• 💾 Save complete Q&A sessions to Notion
• 🔐 Secure HTTP transport with authentication
• 📱 Built with PRAW for reliable Reddit access

Quick Start

1. Environment Setup

Create a .env file:

# MCP Authentication
MCP_API_KEY=your-secret-api-key-here

# Reddit API (get from https://www.reddit.com/prefs/apps)
CLIENT_ID=your-reddit-client-id
CLIENT_SECRET=your-reddit-client-secret
USER_AGENT=your-app-name/1.0

# Notion Integration
NOTION_API_TOKEN=your-notion-integration-token
NOTION_QA_DATABASE_ID=your-notion-database-id

# Optional: Proxy for cloud deployments (required for Render, AWS, etc.)
HTTP_PROXY=http://username:password@proxy-server:port
HTTPS_PROXY=http://username:password@proxy-server:port

⚠️ Cloud Platform Note: Reddit blocks most cloud provider IPs (AWS, Google Cloud, Render, etc.). You need a proxy service for reliable operation.

2. Reddit API Setup

1. Go to: https://www.reddit.com/prefs/apps
2. Create a new app (script type)
3. Copy Client ID and Secret to your .env
4. Set User Agent to something descriptive like MyBot/1.0

🆓 Free Proxy Setup (Webshare)

For cloud deployments (Render, Railway, AWS, etc.):

1. Sign up at Webshare: https://www.webshare.io/
2. Get 10 free proxies (no credit card required)
3. Find your proxy details in their dashboard
4. Your webshare proxyurl: http://username:password@proxy-endpoint:port
5. Add to your .env: HTTP_PROXY=your-webshare-proxy-url and HTTPS_PROXY=your-webshare-proxy-url

3. Notion Database Setup

Create a Notion database with these properties:

• Question (Title)
• Answer (Text)
• Search Query (Text)
• Reddit Sources (Text)
• Created (Date)

4. Run the Server

Option A: With Docker (Recommended)

# Build the image
docker build -t reddit-qa-notion-mcp .

# Run the server
docker run -p 8000:8000 -v $(pwd)/.env:/app/.env reddit-qa-notion-mcp

The server will be available at http://localhost:8000

Option B: Local Development

# Install dependencies
uv sync

# Run with HTTP transport (recommended)
uv run reddit_qa_to_notion_mcp.py --transport http --port 8000

# Or run with stdio transport
uv run reddit_qa_to_notion_mcp.py --transport stdio

5. Configure MCP Client

Add to your MCP client configuration (e.g., .cursor/mcp.json):

{
  "mcpServers": {
    "reddit-qa-to-notion-server": {
      "type": "streamable-http", 
      "url": "http://localhost:8000/mcp",
      "headers": {
        "Authorization": "Bearer your-secret-api-key-here"
      }
    }
  }
}

Available Tools

• search_reddit(query, limit, sort) - Search across all Reddit subreddits
• search_posts(subreddits, query, limit, sort) - Search specific subreddits
• get_top_subreddit_posts(subreddits, limit, time_filter) - Get top posts from subreddits
• save_reddit_qa_to_notion(question, answer, search_query, reddit_sources) - Save Q&A session to Notion

Example Workflow

1. Ask a question: "How do I optimize Python performance?"
2. Search Reddit: Use search_reddit() to find relevant discussions
3. Generate answer: Use Reddit context to inform your LLM response
4. Save to Notion: Use save_reddit_qa_to_notion() to create a knowledge base entry

Development

# Install dependencies
uv sync

# Run locally
uv run reddit_qa_to_notion_mcp.py --transport http

The server will be available at http://localhost:8000