Add SSE transport support to youtube-channel-intelligence

[ry-ops]

Summary

The youtube-channel-intelligence MCP server needs SSE transport support to work with Claude Desktop via mcp-remote.

Current State

• Server type: Custom container image (10.43.170.72:5000/youtube-channel-intelligence:latest)
• Transport: HTTP endpoints only, no SSE
• SSE Status: ❌ Returns 'Not found' for /sse

Requirements

1. Add /sse endpoint that establishes SSE connection
2. Send event: endpoint with session-specific message URL
3. Add /message?sessionId= POST endpoint
4. Stream MCP responses back via SSE
5. Integrate with existing Redis queue processor

Infrastructure Ready

• Ingress: https://youtube-intelligence-mcp.ry-ops.dev ✅
• TLS Certificate: Ready ✅
• DNS: Configured ✅

Reference

See MCP-SSE-Implementation-Tasks.md in cortex-gitops for implementation pattern.