Subscription Tracker MCP Server

1# Subscription Tracker MCP Server
2 
3Professional MCP server for intelligent subscription management with Gmail + MySQL integration.
4 
5## Features
6 
7- **16 MCP Tools**: Gmail search, AI extraction, MySQL CRUD, gap detection, proactive alerts
8- **Gmail Integration**: Search and extract subscription emails
9- **MySQL Database**: Persistent storage with state management
10- **AI Extraction**: Parse subscription details from emails
11- **Gap Detection**: Find duplicates, missing data, price anomalies
12- **Proactive Alerts**: 3-day renewal notifications
13 
14## Quick Start
15 
16### 1. Install Dependencies
17```bash
18pip install -r requirements.txt
19```
20 
21### 2. Configure MySQL
22```bash
23mysql -u root -p
24CREATE DATABASE subscription_tracker;
25exit
26 
27mysql -u root -p subscription_tracker < sql/schema.sql
28```
29 
30### 3. Configure Application
31```bash
32cp config.example.json config.json
33# Edit config.json with your MySQL password and Google OAuth credentials
34```
35 
36### 4. Setup Google OAuth
371. Download `credentials.json` from Google Cloud Console
382. Place in project root
393. Run: `python3 src/setup.py`
40 
41### 5. Configure Claude Desktop
42Edit `~/Library/Application Support/Claude/claude_desktop_config.json`:
43```json
44{
45  "mcpServers": {
46    "subscription-tracker": {
47      "command": "python3",
48      "args": ["/path/to/subscription-tracker-mcp/src/mcp_server.py"],
49      "env": {}
50    }
51  }
52}
53```
54 
55### 6. Restart Claude Desktop
56Quit completely (Cmd+Q) and reopen.
57 
58## Usage
59 
60Ask Claude:
61- "List all my subscriptions"
62- "Search Gmail for Netflix subscription emails"
63- "Check for renewals in the next 7 days"
64- "Detect duplicate subscriptions"
65 
66## Project Structure
67 
68```
69subscription-tracker-mcp/
70├── src/                  # Python modules
71├── sql/                  # Database schema
72├── config.json           # Configuration
73├── requirements.txt      # Dependencies
74└── README.md            # This file
75```
76 
77## License
78 
79Personal use project.
80