Expense Tracker MCP Server

Instructions

Implementation Reference

• main.py:135-146 (handler)

  The handler function 'delete_expense' is registered as an MCP tool and performs a SQL DELETE operation on the expenses table.

  @mcp.tool()
  def delete_expense(id):
      """Delete an expense from the database."""
      try:
          with sqlite3.connect(DB_PATH) as conn:
              cursor = conn.cursor()
              cursor.execute("DELETE FROM expenses WHERE id = ?", (id,))
              if cursor.rowcount == 0:
                  return {"status": "error", "error": "No expense with that id"}
              return {"status": "ok"}
      except Exception as e:
          return {"status": "error", "error": str(e)}