Expense Tracker MCP Server

Import and parse a receipt from a PDF file.

This tool:

1. Extracts text from the PDF

2. Parses receipt metadata (store, date, totals)

3. Extracts line items with prices

4. Categorizes each item using hybrid approach (static rules + LLM)

5. Stores everything in SQLite database

Args: pdf_path: Absolute path to the PDF receipt file ctx: FastMCP context for logging and LLM access

Returns: Summary of imported receipt including store, date, item count, and category breakdown

Query purchase history for a specific item type.

Returns detailed purchase history including:

• List of all purchases with dates, stores, quantities, and prices

• Statistics: total purchases, date range, average frequency, total spent

Args: item_type: Category to query (e.g., 'milk', 'bread', 'eggs') time_range_days: Number of days to look back (default: 365)

Returns: Dictionary with purchases list and aggregated statistics

List all item types/categories in the database with statistics.

Returns summary statistics for each item type including:

• Total number of purchases

• Most recent purchase date

• Total amount spent

Useful for getting an overview of all tracked expense categories.

Returns: Dictionary with list of all item types and their statistics