Local MCP Server Expense Tracker
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Local MCP Server Expense Tracker Add an expense of $30 for dinner on 2024-03-21"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
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.
Related MCP server: local-expense-tracker
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:
uv run fastmcp dev inspector expense_tracker.py2. Run the MCP Server
To start the server directly:
uv run fastmcp run expense_tracker.py3. Install in Claude Desktop
To automatically register the server with your local Claude Desktop configuration:
uv run fastmcp install claude-desktop expense_tracker.py4. 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:
.\sync_mcp.ps1This 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
Available Tools
4 toolsadd_expenseC
Add expense to database
Inputs: date (required), amount (required), category (required), description (required). Returns: object
delete_expenseC
Delete expense from database
Inputs: id (required). Returns: object
edit_expenseC
Edit expense in database
Inputs: id (required), date (required), amount (required), category (required), +1 more. Returns: object
list_expensesA
Get all expenses from database
Inputs: no named parameters. Returns: result
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 4 tools
Each tool has a distinct operation (add, delete, edit, list) with no overlap, making it easy for an agent to select the correct one.
All tool names follow a consistent verb_noun pattern using snake_case, which is predictable and readable.
Four tools cover the core CRUD operations for an expense tracker; the count is appropriate and not excessive.
The set provides essential create, read (list), update, and delete operations, but lacks a single-expense retrieval tool, which is a minor gap.
Maintenance
Related MCP Connectors
Log, query, and edit expenses, budgets, and accounts in Manilo from any MCP-compatible AI assistant.
An MCP server that provides read access to your cloud storage providers, bank accounts and more.
Related MCP Servers
- FlicenseNot gradedqualityDmaintenanceA lightweight MCP server for tracking personal expenses, income, and budget summaries using SQLite.4-
- FlicenseNot gradedqualityDmaintenanceA local MCP server for tracking personal expenses using SQLite, enabling users to add, list, and summarize expenses via natural language.-
- FlicenseNot gradedqualityDmaintenanceA simple MCP server for tracking expenses in a local SQLite database, enabling add, read, update, delete, and summarization of expenses with predefined categories.-
- FlicenseNot gradedqualityDmaintenanceA 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.-