# Local MCP Server Expense Tracker

A lightweight, local Model Context Protocol (MCP) server built with **FastMCP** and **SQLite** to manage expenses. This server enables MCP-compatible clients (like Claude Desktop) to add, list, edit, and delete expenses directly from chat using a local database.

## Features

- **SQLite Database**: Self-contained database (`Expense.db`) created dynamically in the same directory.
- **Full CRUD operations**:
  - `add_expense`: Add a new expense (amount, category, date, description).
  - `list_expenses`: Fetch all expenses stored in the database.
  - `edit_expense`: Modify an existing expense record by ID.
  - `delete_expense`: Permanently delete an expense record by ID.

## Prerequisites

- **Python 3.10+**
- **uv** (recommended Python package installer/runner)

## Installation & Running

### 1. Run in Development Mode (Inspector)
To run the server and inspect/test the tools using the FastMCP web inspector:
```bash
uv run fastmcp dev inspector expense_tracker.py
```

### 2. Run the MCP Server
To start the server directly:
```bash
uv run fastmcp run expense_tracker.py
```


### 3. Install in Claude Desktop
To automatically register the server with your local Claude Desktop configuration:
```bash
uv run fastmcp install claude-desktop expense_tracker.py
```

### 4. Windows Auto-Sync & Path Fix (Optional)
If you are using the Microsoft Store version of Claude Desktop on Windows, the app is sandboxed and might fail to find `uv` in its PATH or fail to load the standard configuration.

You can run the included PowerShell script to fix the paths and sync configuration:
```powershell
.\sync_mcp.ps1
```
This script:
- Resolves the absolute path of `uv.exe`.
- Syncs the configurations to Claude's sandboxed local packages directories.
- Restarts Claude Desktop automatically.

## Database Schema

The SQLite database contains a table named `expenses` with the following schema:
- `id`: INTEGER (Primary Key, Auto-increment)
- `amount`: REAL (Not Null)
- `category`: TEXT (Not Null)
- `date`: DATE (Not Null)
- `description`: TEXT (Optional)

## License

MIT License