Subscription Tracker

You can manage Gmail-based subscriptions end-to-end with this Subscription Tracker MCP Server. It stores state in MySQL, automatically extracts subscription details from emails, detects data gaps, and sends proactive renewal alerts, helping you stay on top of every subscription.

How to use

Ask Claude to interact with your MCP server using natural language prompts. Practical examples include:

• List all your subscriptions
• Search Gmail for Netflix subscription emails
• Check for renewals in the next 7 days
• Detect duplicate subscriptions The MCP exposes a set of capabilities that you can trigger from Claude, enabling you to query, analyze, and alert on your subscriptions without manual data entry.

When you start Claude and point it at the MCP server, you can perform operations such as listing subscriptions, querying Gmail for subscription-related messages, and generating proactive renewal alerts based on your configured data.

How to install

Prerequisites you need before installing:

• Python 3.x installed on your system
• MySQL server running and accessible
• Access to Google OAuth credentials for Gmail integration

pip install -r requirements.txt

Create and configure the MySQL database for the MCP server.

mysql -u root -p
CREATE DATABASE subscription_tracker;
exit

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

Copy the example configuration and tailor it to your environment, including your MySQL password and Google OAuth credentials.

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

Set up Google OAuth credentials by obtaining credentials.json from Google Cloud Console and placing it at the project root, then initialize the MCP server setup.

# Place credentials.json in the project root, then run setup to initialize OAuth integration
python3 src/setup.py

Configure Claude Desktop to point to the MCP server you just set up. Create or edit the configuration to include the subscription tracker entry.

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

Restart Claude Desktop to load the new MCP server configuration.

Finally, ensure the local Claude Desktop instance is running and connected. You can then issue commands to list subscriptions, search Gmail for relevant emails, or check upcoming renewals.

Additional notes

This MCP server uses a local stdio configuration, so you start it as a local process and Claude communicates with it via the specified command and arguments.

Security and access: keep your Google OAuth credentials and MySQL access restricted to trusted environments. Rotate credentials as needed and monitor for unusual activity.

Project structure overview you will work with:

• src/ Python modules
• sql/ Database schema
• config.json Configuration
• requirements.txt Dependencies

Configuration details

The MCP server is configured to run as a local process via Python. The relevant runtime command is provided in the Claude Desktop configuration snippet below.

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

Troubleshooting tips

If Claude cannot communicate with the MCP server, verify that the path to mcp_server.py is correct and that Python 3 is installed in your environment.

Ensure Gmail OAuth credentials are valid and that the credentials.json file is accessible at the expected project root location.

Check that MySQL is running and that the subscription_tracker database exists with the proper schema before starting the MCP server.

Available tools

gmail_search

Search Gmail for subscription-related messages and filter results based on user criteria.

ai_extraction

AI-driven parsing of emails to extract subscription details such as service name, price, renewal date, and status.

mysql_crud

Create, read, update, and delete subscription records in the MySQL database.

gap_detection

Identify duplicates, incomplete data, and anomalies in prices or renewal dates.

proactive_alerts

Generate and notify about upcoming renewals, typically with a 3-day lead time.