solana-launchpads-mcp

Instructions

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()