Skip to main content
Glama
expense-tracker-remote-mcp-server

expense-tracker-remote-mcp-server

by MuazamAbbas

Expense Tracker Remote MCP 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

Related MCP server: Expense Tracker MCP Server

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

Available Tools

8 tools
add_expenseC

Add a new expense to the database.

Inputs: amount (required), category (required), date, description, +1 more. Returns: object

delete_expenseA

Delete an expense by its ID.

Inputs: expense_id (required). Returns: object

get_budget_statusB

Check budget vs actual spending for current month.

Inputs: budget. Returns: object

get_monthly_trendB

Get monthly spending trends over time.

Inputs: months. Returns: object

get_summaryC

Get spending summary grouped by category.

Inputs: category, end_date, start_date. Returns: object

list_expensesB

List expenses with optional filters for category and date range.

Inputs: limit, category, end_date, start_date. Returns: object

search_expensesA

Search expenses by description keyword.

Inputs: keyword (required), limit. Returns: object

update_expenseC

Update an existing expense's details.

Inputs: expense_id (required), date, amount, category, +2 more. Returns: object

Tool Schema Changelog

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

Loading tool schema changelog…

    TDQS

    B3.4/5.0

    Scored across 8 tools

    Disambiguation4/5

    Each tool targets a distinct operation (add, list, update, delete, summary, budget, trend, search). list_expenses and search_expenses both retrieve expenses, but list uses filters while search uses keyword, and descriptions clarify the difference.

    Naming Consistency5/5

    All tool names follow a consistent verb_noun pattern in snake_case (e.g., add_expense, list_expenses, get_summary). This makes the set predictable and easy to navigate.

    Tool Count5/5

    With 8 tools, the server is well-scoped for expense management. Each tool serves a clear purpose without redundancy or bloat, covering core CRUD plus useful analytics.

    Completeness4/5

    The surface covers add, list, update, delete, summary, budget check, trend, and search—solid coverage for expense tracking. Minor gaps like a dedicated get-by-ID or budget-setting tool, but these are not critical and can be worked around.

    Maintenance

    ActivityInactive
    ResponsivenessNo recent community issues

    Related MCP Connectors

    Related MCP Servers

    • F
      license
      B
      quality
      D
      maintenance
      MCP server for tracking personal expenses using FastMCP and SQLite, enabling adding, listing, updating, deleting expenses and summarizing by category via natural language tools.
      5
      1
      -
    • F
      license
      Not graded
      quality
      D
      maintenance
      MCP server for tracking expenses with local SQLite storage. Provides tools to add, list, and summarize expenses by category.
      -
    • 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.
      -