Skip to main content
Glama
expense-tracker-mcp

expense-tracker-mcp

Expense Tracker MCP Server

A local MCP (Model Context Protocol) server built with FastMCP and PostgreSQL.

This project exposes expense management tools that can be used by MCP clients such as Claude Desktop.

Features

  • βž• Add Expense

  • πŸ“‹ List Expenses

  • πŸ“Š Summarize Expenses

  • ✏️ Edit Expense

  • πŸ—‘οΈ Delete Expense

  • πŸ’° Add Credit

  • πŸ“‚ Expense Categories Resource

Related MCP server: Expense Tracker MCP

Tech Stack

  • Python

  • FastMCP

  • PostgreSQL

  • SQLAlchemy

  • Psycopg 3

  • Pydantic Settings

  • UV

Project Structure

expense-tracker-mcp/
β”‚
β”œβ”€β”€ app/
β”‚   β”œβ”€β”€ tools/
β”‚   β”‚   β”œβ”€β”€ expense_tools.py
β”‚   β”‚   └── credit_tools.py
β”‚   β”œβ”€β”€ config.py
β”‚   β”œβ”€β”€ database.py
β”‚   β”œβ”€β”€ models.py
β”‚   └── resources.py
β”‚
β”œβ”€β”€ categories.json
β”œβ”€β”€ main.py
β”œβ”€β”€ .env.example
β”œβ”€β”€ pyproject.toml
└── README.md

MCP Tools

Tool

Description

add_expense

Add a new expense

list_expenses

List all expenses

summarize_expenses

Show expense summary

edit_expense

Update an existing expense

delete_expense

Delete an expense

add_credit

Add income/credit

MCP Resource

expense://categories

Returns the predefined expense categories.

Setup

Clone the repository:

git clone https://github.com/thearyangupta/expense-tracker-mcp.git
cd expense-tracker-mcp

Install dependencies:

uv sync

Create a .env file:

DATABASE_URL=postgresql+psycopg://postgres:YOUR_PASSWORD@localhost:5432/expense_tracker

Run the server:

uv run python main.py

Example Prompts

Add a Food expense of β‚Ή250 for Lunch.

Show all expenses.

Summarize my expenses.

Update expense 3.

Delete expense 5.

Add a credit of β‚Ή20,000 from Freelancing.

Future Improvements

  • Expense filtering

  • Monthly reports

  • Export to CSV

  • Budget tracking

  • AI-powered expense insights


Built using FastMCP and PostgreSQL.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    Related MCP Connectors

    Related MCP Servers

    • F
      license
      A
      quality
      D
      maintenance
      A Model Context Protocol (MCP) server for tracking personal expenses. This server provides tools to add, list, and summarize expenses, utilizing a local SQLite database for storage.
      3
      -
    • F
      license
      Not graded
      quality
      D
      maintenance
      A simple MCP server for tracking expenses in a local SQLite database, enabling add, read, update, delete, and summarization of expenses with predefined categories.
      -
    • F
      license
      Not graded
      quality
      D
      maintenance
      A lightweight local MCP server for tracking personal or small-team expenses. It lets you add expense entries, list transactions within a date range, and generate simple summaries by category β€” all backed by a local SQLite database.
      -
    • F
      license
      B
      quality
      D
      maintenance
      A lightweight local MCP server that enables users to add, list, edit, and delete expenses via SQLite database through natural language in MCP-compatible clients.
      4
      1
      -