Provides tools for recording and managing expenses in a local SQLite database, including adding, listing, searching, and summarizing expenses by month and category.
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., "@Expense Tracker MCP Server Add a lunch expense of 200 rupees"
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.
A minimal expense tracking server built with FastMCP and Turso (a SQLite-compatible cloud database).
# Install dependencies (from the mcp_demo root)
pip install fastmcp turso_serverless python-dotenvCreate a .env file in expense_tracker/ with your Turso database credentials:
DB_URL=libsql://your-db-name-yourusername.turso.io
DB_AUTH_TOKEN=your-auth-token-hereGet these from the Turso CLI:
turso db show your-db-name --url
turso db tokens create your-db-nameRelated MCP server: Expense Tracker MCP Server
# From the mcp_demo root
python -m expense_tracker.serverOr run directly:
cd expense_tracker
python server.pyUse the FastMCP Inspector to interactively test and debug tools in the browser:
cd expense_tracker
fastmcp dev inspector server.pyadd_expenseRecord a new expense.
Parameter | Type | Required | Description |
| float | ✅ | Amount in INR (must be > 0) |
| string | ✅ | What the expense was for |
| string | ❌ | Category (e.g. "food", "groceries"). Defaults to "uncategorized" |
| string | ❌ | Date in YYYY-MM-DD format. Defaults to today |
list_expensesList recent expenses with pagination.
Parameter | Type | Required | Description |
| int | ❌ | Max results (default 20, max 100) |
| int | ❌ | Skip N results for pagination |
search_expensesSearch by keyword and/or category. At least one must be provided.
Parameter | Type | Required | Description |
| string | ❌ | Search in descriptions (case-insensitive) |
| string | ❌ | Filter by category |
get_expense_summary_monthGet monthly spending summary with category breakdown.
Parameter | Type | Required | Description |
| int | ❌ | Month (1-12). Defaults to current month |
| int | ❌ | Year. Defaults to current year |
get_budget_status_of_categoryGet total spending for a specific category.
Parameter | Type | Required | Description |
| string | ✅ | Category to check (e.g. "food") |
| int | ❌ | Month (1-12). Defaults to current month |
| int | ❌ | Year. Defaults to current year |
Expenses are stored in a Turso cloud database (SQLite-compatible), connected via the turso_serverless DB-API 2.0 driver over HTTP. The connection is configured through the DB_URL and DB_AUTH_TOKEN environment variables — see Setup above. The expenses table and its indexes are created automatically on first run if they don't already exist.
CREATE TABLE expenses (
id INTEGER PRIMARY KEY AUTOINCREMENT,
amount REAL NOT NULL,
description TEXT NOT NULL,
category TEXT NOT NULL DEFAULT 'uncategorized',
date DATE NOT NULL,
created_at DATE NOT NULL DEFAULT (date('now'))
);Add to your claude_desktop_config.json:
{
"mcpServers": {
"expense-tracker": {
"command": "/Users/krishnasinghal/Projects/mcp_demo/.venv/bin/fastmcp",
"args": ["run", "/Users/krishnasinghal/Projects/mcp_demo/expense_tracker/server.py:mcp"],
"env": {
"DB_URL": "libsql://your-db-name-yourusername.turso.io",
"DB_AUTH_TOKEN": "your-auth-token-here"
}
}
}
}This server cannot be deployed
Track expenses from your AI chat: log, categorize, monthly CSV reports. All data is local.
Track budgets from your AI chat: envelopes, monthly limits, variance reports. All data is local.
Personal finance tracker — log transactions, view summaries, and browse a dashboard
Personal finance: log expenses in plain language, track accounts, budgets and spending
