Geenie MCP Proxy Server

-- Add client_id tracking to OAuth sessions -- This allows us to see which OAuth client created each session -- Useful for analytics: which users use claude.ai connector vs desktop -- Add client_id column with foreign key to oauth_clients ALTER TABLE oauth_sessions ADD COLUMN client_id TEXT REFERENCES oauth_clients(client_id) ON DELETE CASCADE; -- Create index for faster lookups (e.g., finding all sessions for a client) CREATE INDEX IF NOT EXISTS idx_oauth_sessions_client_id ON oauth_sessions(client_id); -- Note: This column will be NULL for existing sessions (created before this migration) -- New sessions will have client_id populated automatically by the /oauth/token endpoint