Admin & Operations

query RecentMessages {
  chat_messages(
    order_by: { created_at: desc }
    limit: 50
    where: { is_deleted: { _eq: false } }
  ) {
    id
    content
    message_type
    created_at
    user { username }
    room { name }
  }
}

query MessagesByUser($username: String!) {
  chat_messages(
    order_by: { created_at: desc }
    limit: 50
    where: {
      is_deleted: { _eq: false }
      user: { username: { _eq: $username } }
    }
  ) {
    id
    content
    created_at
    user { username }
  }
}

mutation DeleteMessage($id: uuid!) {
  update_chat_messages_by_pk(
    pk_columns: { id: $id }
    _set: { is_deleted: true, deleted_by: "YOUR_ADMIN_UUID" }
  ) {
    id
  }
}

{
  "id": "paste-the-message-uuid-here"
}

mutation MuteUser($roomId: uuid!, $userId: uuid!) {
  update_chat_members(
    where: {
      room_id: { _eq: $roomId }
      user_id: { _eq: $userId }
    }
    _set: {
      is_muted: true,
      muted_until: "2026-03-23T00:00:00Z"
    }
  ) {
    affected_rows
  }
}

mutation UnmuteUser($roomId: uuid!, $userId: uuid!) {
  update_chat_members(
    where: {
      room_id: { _eq: $roomId }
      user_id: { _eq: $userId }
    }
    _set: {
      is_muted: false,
      muted_until: null
    }
  ) {
    affected_rows
  }
}

mutation BanUser($roomId: uuid!, $userId: uuid!, $reason: String) {
  insert_chat_bans_one(object: {
    room_id: $roomId
    user_id: $userId
    banned_by: "YOUR_ADMIN_UUID"
    reason: $reason
  }) {
    id
  }
}

{
  "roomId": "room-uuid",
  "userId": "user-uuid",
  "reason": "Violation of community guidelines"
}

mutation UnbanUser($roomId: uuid!, $userId: uuid!) {
  delete_chat_bans(
    where: {
      room_id: { _eq: $roomId }
      user_id: { _eq: $userId }
    }
  ) {
    affected_rows
  }
}

mutation SetRole($roomId: uuid!, $userId: uuid!, $role: String!) {
  update_chat_members(
    where: {
      room_id: { _eq: $roomId }
      user_id: { _eq: $userId }
    }
    _set: { role: $role }
  ) {
    affected_rows
  }
}

query CheckMembership($userId: uuid!) {
  chat_members(where: { user_id: { _eq: $userId } }) {
    room { name }
    role
    is_muted
    muted_until
    joined_at
  }
  chat_bans(where: { user_id: { _eq: $userId } }) {
    room { name }
    reason
    banned_at
    expires_at
  }
}

# MCP Server -- should return {"status":"ok","backend":"hasura",...}
curl https://chat-staging.thephenom.app/mcp/health

# Synapse -- should return available login flows
curl https://chat-staging.thephenom.app/_matrix/client/v3/login

aws ecs describe-services --region us-east-1 \
  --cluster phenom-dev-cluster \
  --services phenom-dev-synapse phenom-dev-synapse-admin phenom-dev-chat-mcp \
  --query 'services[*].{Name:serviceName,Running:runningCount,Desired:desiredCount,Status:status}' \
  --output table

# Synapse logs (last 1 hour)
aws logs tail /ecs/phenom-dev-synapse --follow --since 1h --region us-east-1

# MCP Server logs
aws logs tail /ecs/phenom-dev-chat-mcp --follow --since 1h --region us-east-1

# Link Preview Lambda logs
aws logs tail /aws/lambda/phenom-dev-link-preview --follow --since 1h --region us-east-1

# User Provisioner Lambda logs
aws logs tail /aws/lambda/phenom-dev-chat-user-provisioner --follow --since 1h --region us-east-1

# Restart Synapse
aws ecs update-service --region us-east-1 \
  --cluster phenom-dev-cluster \
  --service phenom-dev-synapse \
  --force-new-deployment

# Restart Synapse Admin UI
aws ecs update-service --region us-east-1 \
  --cluster phenom-dev-cluster \
  --service phenom-dev-synapse-admin \
  --force-new-deployment

# Restart MCP Server
aws ecs update-service --region us-east-1 \
  --cluster phenom-dev-cluster \
  --service phenom-dev-chat-mcp \
  --force-new-deployment

# Scale all chat services to 0
aws ecs update-service --region us-east-1 \
  --cluster phenom-dev-cluster \
  --service phenom-dev-synapse \
  --desired-count 0

aws ecs update-service --region us-east-1 \
  --cluster phenom-dev-cluster \
  --service phenom-dev-synapse-admin \
  --desired-count 0

aws ecs update-service --region us-east-1 \
  --cluster phenom-dev-cluster \
  --service phenom-dev-chat-mcp \
  --desired-count 0