# 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.