Expense Tracker MCP Server

An AI-powered Expense Tracker built using FastMCP, SQLite, and Claude Desktop.

This MCP (Model Context Protocol) server enables Claude to manage personal expenses, analyze spending patterns, track budgets, generate reports, and export data through natural language conversations.

Features

Expense Management

• Add expenses

• Update expenses

• Delete expenses

• Search expenses

• List expenses by date range

Analytics

• Monthly spending reports

• Category-wise spending summaries

• Spending insights

• Largest transactions analysis

• Top spending categories

Budget Management

• Set monthly budgets

• Track budget utilization

• Monitor remaining budget

Export

• Export expenses to CSV

AI Integration

Works with Claude Desktop through MCP.

Example queries:

• "Add ₹250 for lunch today."

• "Show my expenses for June."

• "What was my highest spending category this month?"

• "Have I exceeded my food budget?"

• "Export all expenses from May."

Tech Stack

• Python 3.11+

• FastMCP

• SQLite

• Claude Desktop

• JSON

Project Structure

expense-tracker-mcp-server/
│
├── main.py
├── expenses.db
├── categories.json
├── exports/
│   └── *.csv
├── pyproject.toml
└── README.md

Database Schema

Expenses Table

CREATE TABLE expenses(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    date TEXT NOT NULL,
    amount REAL NOT NULL,
    category TEXT NOT NULL,
    subcategory TEXT DEFAULT '',
    note TEXT DEFAULT ''
);

Budgets Table

CREATE TABLE budgets(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    category TEXT UNIQUE NOT NULL,
    monthly_limit REAL NOT NULL
);

Installation

Clone Repository

git clone https://github.com/your-username/expense-tracker-mcp-server.git

cd expense-tracker-mcp-server

Create Virtual Environment

Windows:

python -m venv mcp_venv

mcp_venv\Scripts\activate

Linux / macOS:

python -m venv mcp_venv

source mcp_venv/bin/activate

Install Dependencies

pip install -r requirements.txt

or

pip install fastmcp

Running the MCP Server

python main.py

MCP Tools

Claude Desktop Integration

Add the following configuration to Claude Desktop:

{
  "mcpServers": {
    "expense-tracker": {
      "command": "python",
      "args": [
        "C:\\path\\to\\expense-tracker-mcp-server\\main.py"
      ]
    }
  }
}

Restart Claude Desktop after updating the configuration.

Example Prompts

Add Expense

Add ₹500 for groceries today.

Get Spending Insights

Give me spending insights for 2026-06.

Budget Tracking

Set my food budget to ₹10000.

How much budget is remaining for food this month?

Export Data

Export all expenses from June 2026.

Future Improvements

• Income tracking

• Recurring expenses

• Expense forecasting

• AI-generated financial recommendations

• Category trend analysis

• Monthly comparison reports

• Dashboard integration

• Multi-user support

• PostgreSQL support