get_recent_pumpfun_graduates
Track newly launched tokens on Pump.fun in the last 24 hours. Retrieve detailed data including token name, mint address, market cap, and trade count to analyze recent memecoin activity.
Instructions
Retrieve the most recently graduated tokens from Pump.fun in the last 24 hours.
Args:
limit (int): Maximum number of tokens to return. Defaults to 100.
Returns:
str: A formatted table of recent Pump.fun graduates including graduation time,
token name, mint address, market capitalization, and trade count,
or an error message if the query fails.
Raises:
httpx.HTTPStatusError: If the Dune API request fails.Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No |
Implementation Reference
- main.py:159-189 (handler)The handler function for the 'get_recent_pumpfun_graduates' tool. It fetches the latest results from Dune Analytics query ID 4832245, processes the rows by stripping HTML tags from token names and addresses, formats the data into a table using tabulate, and returns a markdown-formatted string with the results.
@mcp.tool() def get_recent_pumpfun_graduates(limit: int = 100) -> str: """Retrieve the most recently graduated tokens from Pump.fun in the last 24 hours. Args: limit (int): Maximum number of tokens to return. Defaults to 100. Returns: str: A formatted table of recent Pump.fun graduates including graduation time, token name, mint address, market capitalization, and trade count, or an error message if the query fails. Raises: httpx.HTTPStatusError: If the Dune API request fails. """ try: data = get_latest_result(4832245, limit=limit) rows = [ [ row["graduation_time"], strip_a_tag(row["asset_with_chart"]), strip_a_tag(row["token_address_with_chart"]), f'${row["market_cap"]:.2f}', row["trade_count"] ] for row in data ] headers = ["Graduation Time", "Token", "Mint Address", "Market Cap", "Trade Count"] return f"# Recent {limit} Pump.fun Graduates - Last 24 Hours\n\n" + tabulate(rows, headers=headers) except Exception as e: return str(e) - main.py:23-46 (helper)Helper function used by the tool to fetch data from Dune API using the specified query ID and limit.
def get_latest_result(query_id: int, limit: int = 1000): """ Fetch the latest results from a Dune Analytics query. Args: query_id (int): The ID of the Dune query to fetch results from. limit (int, optional): Maximum number of rows to return. Defaults to 1000. Returns: list: A list of dictionaries containing the query results, or an empty list if the request fails. Raises: httpx.HTTPStatusError: If the API request fails due to a client or server error. """ url = f"{BASE_URL}/query/{query_id}/results" params = {"limit": limit} with httpx.Client() as client: response = client.get(url, params=params, headers=HEADERS, timeout=300) response.raise_for_status() data = response.json() result_data = data.get("result", {}).get("rows", []) return result_data - main.py:47-50 (helper)Helper function used to extract text content from HTML anchor tags in the query results.
def strip_a_tag(html): match = re.search(r'>(.*?)</a>', html) return match.group(1) if match else html