Email & OTP Delivery Triage

This is the most common issue type in #oncall and #incident channels. Follow this systematic diagnostic flow.

Available MCP Tools for Investigation

You have direct access to GCP Cloud Logging and BigQuery for spotdraft-qa. Use these to investigate email delivery failures programmatically.

BigQuery Django Models — Contract Context

For QA contracts, look up counterparty and contract state directly from the synced model tables. MCP only has access to spotdraft-qa project.

Look up contract details for context (QA India):

SELECT
  c.id, c.status, c.contract_kind, c.created_by_workspace_id, c.contract_type_id
FROM `spotdraft-qa.qa_india_public.contracts_v3_contractv3` c
WHERE c.id = {contract_id}