mxcp: 1
resource:
name: player_profile
description: Chess.com player profile data
uri: "chess://player/{username}"
parameters:
- name: username
type: string
description: The Chess.com username
pattern: "^[a-zA-Z0-9_-]+$"
source:
code: |
SELECT response_data as profile_data
FROM chess_api_cache
WHERE cache_key = 'player/' || $username
AND endpoint LIKE 'player/%'
AND expires_at > CURRENT_TIMESTAMP
ORDER BY cached_at DESC
LIMIT 1