MCP Servers
Local Tools
manage_context
handle_overlong_tool_outputs
Instruction
The end-of-day settlement time for the game has arrived, and we need to process the player score data for the current day in thedaily_scores_stream table. First, generate the final leaderboard for the day by selecting the top 100 players with the highest scores and storing the results in an independent table named after the day’s date, leaderboard_YYYYMMDD(Must include player_id, total_score and rank fields). Second, for long-term player behavior analysis, update the statistical data for all players on the day into the master table player_historical_stats, inserting a new record for each player containing their ID, the day’s date, the day’s total score, and the number of games played on the day.
Initial State
Google Cloud
The tabledaily_scores_stream is randomly generated during each test; you can review here to understand the data generation method.