Microsoft Teams

Read your Teams data — teams, channels, members, and channel messages — by human-readable names rather than GUIDs.

-- Teams you belong to
SELECT * FROM graph_my_teams();

-- Channels in a specific team
SELECT * FROM graph_team_channels(team => 'Sales EU');

-- Members of a channel
SELECT * FROM graph_team_members(team => 'Sales EU', channel => 'General');

-- Recent channel messages
SELECT createdDateTime, "from", body
FROM graph_channel_messages(
  team => 'Sales EU',
  channel => 'Announcements'
)
WHERE createdDateTime > now() - INTERVAL '7 days';

Useful for collaboration analytics, audit trails, and lightweight reporting on team activity.