# Subscription Tracker MCP Server
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
```bash
pip install -r requirements.txt
```
### 2. Configure MySQL
```bash
mysql -u root -p
CREATE DATABASE subscription_tracker;
exit
mysql -u root -p subscription_tracker < sql/schema.sql
```
### 3. Configure Application
```bash
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`:
```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.
