Geenie MCP Proxy Server

-- Backfill client_id for existing OAuth sessions -- This updates NULL client_id values with the most recent OAuth client -- Used for sessions created before we added client_id tracking -- Find the most recent OAuth client (the one currently being used) WITH most_recent_client AS ( SELECT client_id FROM oauth_clients ORDER BY created_at DESC LIMIT 1 ) -- Update all sessions with NULL client_id to use the most recent client UPDATE oauth_sessions SET client_id = (SELECT client_id FROM most_recent_client) WHERE client_id IS NULL AND expires_at > NOW(); -- Only update active (non-expired) sessions -- Show what was updated SELECT session_id, client_id, created_at, expires_at FROM oauth_sessions WHERE expires_at > NOW() ORDER BY created_at DESC;