get_daily_graduates
Fetch daily graduate counts from Solana memecoin launchpads to track successful token sales and project completions by platform.
Instructions
Fetch the daily number of graduates from Solana memecoin launchpads.
This tool retrieves data from a Dune Analytics query and pivots it to show the number of
successful graduates (e.g., completed token sales or projects) per day by each platform.
Args:
limit (int, optional): Maximum number of rows to fetch from the Dune query. Defaults to 1000.
Returns:
str: A markdown-formatted table of daily graduates by platform, or an error message if the
query fails.Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No |
Implementation Reference
- main.py:75-98 (handler)The handler function for the 'get_daily_graduates' tool. Decorated with @mcp.tool() for registration. Fetches data from Dune Analytics query ID 5131612, processes it into a pivoted DataFrame by date and platform, sorts descending by date, and returns a markdown table. Falls back to error string on exception.
@mcp.tool() def get_daily_graduates(limit: int = 1000) -> str: """ Fetch the daily number of graduates from Solana memecoin launchpads. This tool retrieves data from a Dune Analytics query and pivots it to show the number of successful graduates (e.g., completed token sales or projects) per day by each platform. Args: limit (int, optional): Maximum number of rows to fetch from the Dune query. Defaults to 1000. Returns: str: A markdown-formatted table of daily graduates by platform, or an error message if the query fails. """ try: data = get_latest_result(5131612, limit=limit) df = pd.DataFrame(data) df['block_date'] = pd.to_datetime(df['block_date']).dt.date pivot_df = df.pivot(index="block_date", columns="platform", values="daily_graduates") pivot_df = pivot_df.sort_index(ascending=False) return pivot_df.to_markdown() except Exception as e: return str(e) - main.py:21-43 (helper)Shared helper function used by get_daily_graduates (and other tools) to fetch the latest results from a specified Dune Analytics query using the API, returning the rows as a list of dicts.
def get_latest_result(query_id: int, limit: int = 1000) -> list: """ 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:75-75 (registration)The @mcp.tool() decorator registers the get_daily_graduates function as an MCP tool.
@mcp.tool()