Personal Expense Tracker

A simple expense tracking API built with FastAPI, SQLite, and FastMCP.

The project lets you add expenses, view them by date range, and get a quick summary of spending by category.

Features

• Add a new expense

• Store expenses in SQLite

• Filter expenses by date range

• Get spending totals by category

• Optional category filtering for summaries

• Expose the FastAPI app through an MCP server

Related MCP server: Expense Tracker MCP Server

Tech Stack

• Python 3.12+

• FastAPI

• SQLite

• Pydantic

• FastMCP

• uv

Project Structure

PersonalExpenseTracker/
│
├── main.py           # FastAPI application and API routes
├── server.py         # FastMCP server
├── categories.json   # Expense categories
├── pyproject.toml    # Project configuration
├── uv.lock           # Locked dependencies
├── .gitignore
└── README.md

Getting Started

Clone the repository:

git clone https://github.com/bhuvpal/PersonalExpenseTracker.git
cd PersonalExpenseTracker

Install dependencies:

uv sync

Run the FastAPI server:

uv run uvicorn main:app --reload

The API will be available at:

http://127.0.0.1:8000

FastAPI also provides interactive API documentation at:

http://127.0.0.1:8000/docs

API Endpoints

Example Expense

{
  "amount": 250,
  "date": "2026-09-04",
  "category": "Food",
  "sub_category": "Lunch",
  "note": "Lunch with friends"
}

MCP Server

The project also includes a FastMCP server that exposes the FastAPI application for MCP-based usage.

Run it with:

uv run python server.py

Database

Expenses are stored locally in a SQLite database.

Each expense contains:

• Amount

• Date

• Category

• Sub-category

• Note

Why I Built This

I built this project to practice building APIs with FastAPI and explore how existing APIs can be exposed through Model Context Protocol (MCP).

Author

Bhuv Pal

GitHub: @bhuvpal