Expense Tracker Remote Server

A remote MCP server for expense tracking with async support, built with FastMCP.

Features

• 8 Async Tools for managing expenses
• 2 Resources for quick data access
• SQLite Database for persistent storage
• HTTP Transport for remote access

Tools

Tool	Description
add_expense	Add a new expense (amount, category, date, description, subcategory)
list_expenses	List expenses with filters (category, date range)
get_summary	Get spending summary grouped by category
delete_expense	Delete an expense by ID
update_expense	Update existing expense details
get_budget_status	Check budget vs actual spending
get_monthly_trend	Monthly spending trends over time
search_expenses	Search expenses by description keyword

Resources

Resource	Description
expenses://current	Current month's expenses
expenses://summary	Overall spending summary

Installation

# Install dependencies
uv sync
# or
pip install -e .

Running

# Run with stdio transport (for local development)
uv run python main.py

# Run with HTTP transport (for remote access)
uv run python main.py http

Environment Variables

Variable	Default	Description
DB_PATH	expenses.db	Path to SQLite database
DEFAULT_BUDGET	1000.0	Default monthly budget

Deployment

This server is designed to be deployed to Prefect Horizon.

Steps to Deploy:

1. Push this code to a GitHub repository
2. Login to horizon.prefect.io with GitHub
3. Connect your repository
4. Configure:
   • Server name: expense-tracker
   • Entrypoint: main.py:mcp
5. Deploy!

Your server will be available at: https://your-server-name.fastmcp.app/mcp

Usage with Claude Desktop

Add to your claude_desktop_config.json:

{
  "mcpServers": {
    "expense-tracker": {
      "url": "https://your-server.fastmcp.app/mcp"
    }
  }
}

Development

# Run in development mode with auto-reload
uv run fastmcp dev main.py:mcp

# Inspect server
uv run fastmcp inspect main.py:mcp

License

MIT