nckhemanth0/subscription-tracker-mcp

Professional MCP server for intelligent subscription management with Gmail + MySQL integration.

Features

• 16 MCP Tools: Gmail search, AI extraction, MySQL CRUD, gap detection, proactive alerts
• Gmail Integration: Search and extract subscription emails
• MySQL Database: Persistent storage with state management
• AI Extraction: Parse subscription details from emails
• Gap Detection: Find duplicates, missing data, price anomalies
• Proactive Alerts: 3-day renewal notifications

Quick Start

1. Install Dependencies

pip install -r requirements.txt

2. Configure MySQL

mysql -u root -p
CREATE DATABASE subscription_tracker;
exit

mysql -u root -p subscription_tracker < sql/schema.sql

3. Configure Application

cp config.example.json config.json
# Edit config.json with your MySQL password and Google OAuth credentials

4. Setup Google OAuth

1. Download credentials.json from Google Cloud Console
2. Place in project root
3. Run: python3 src/setup.py

5. Configure Claude Desktop

Edit ~/Library/Application Support/Claude/claude_desktop_config.json:

{
  "mcpServers": {
    "subscription-tracker": {
      "command": "python3",
      "args": ["/path/to/subscription-tracker-mcp/src/mcp_server.py"],
      "env": {}
    }
  }
}

6. Restart Claude Desktop

Quit completely (Cmd+Q) and reopen.

Usage

Ask Claude:

• "List all my subscriptions"
• "Search Gmail for Netflix subscription emails"
• "Check for renewals in the next 7 days"
• "Detect duplicate subscriptions"

Project Structure

subscription-tracker-mcp/
├── src/                  # Python modules
├── sql/                  # Database schema
├── config.json           # Configuration
├── requirements.txt      # Dependencies
└── README.md            # This file

License

Personal use project.