aurora-troubleshooting

Diagnose and resolve Aurora reservations flow issues across WhatsApp webhooks and confirmations.

Updated Nov 6, 2025
One-click install
npx skills add https://github.com/MarketingLabb/Coworkia-Agent --skill aurora-troubleshooting
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: aurora-troubleshooting
Source: https://github.com/MarketingLabb/Coworkia-Agent/tree/main/.github/skills/aurora-troubleshooting
Command: npx skills add https://github.com/MarketingLabb/Coworkia-Agent --skill aurora-troubleshooting

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Diagnoses and resolves issues in the Aurora reservations flow across WhatsApp interactions, helping teams quickly identify and fix disruptions in bookings, webhooks, and confirmations.

Core Features & Use Cases

  • End-to-end troubleshooting of Aurora reservation flows, including form activation, confirmations, emails, and duplicate messages.
  • Guided debugging playbook with common failure scenarios and fixes to restore normal operations.
  • Operational visibility through sample queries and log checks to isolate failures in production.

Quick Start

Identify the root cause of a stuck Aurora reservation flow and apply the recommended fixes to restore bookings.

Frequently Asked Questions about aurora-troubleshooting

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I diagnose Aurora reservation webhook failures?

Diagnose Aurora reservation webhook failures by monitoring logs and querying the reservations schema to isolate processing errors. The guided playbook checks pending_confirmations and agent_forms tables to identify whether webhooks are failing to trigger or incorrectly processing duplicate WhatsApp messages.

Why are WhatsApp reservation confirmation emails not delivering?

WhatsApp reservation confirmation emails fail when webhook processing errors prevent pending_confirmations from resolving correctly. Troubleshooting checks log monitors for webhook triggers, verifies form activation status, and ensures confirmation storage correctly triggers the email delivery pipeline.

How do I fix duplicate webhook messages in a PostgreSQL reservations flow?

Fix duplicate webhook messages in a PostgreSQL reservations flow by inspecting the pending_confirmations table to identify reprocessed entries. The debugging playbook provides sample queries to detect duplicate triggers and apply handling fixes to prevent repeated booking confirmations across WhatsApp.

What database tables do I need access to for troubleshooting Aurora bookings?

Troubleshooting Aurora bookings requires access to the reservations schema, agent_forms, and pending_confirmations database tables. Log monitoring access is also necessary to guide debugging and apply fixes for form activation, webhook failures, and confirmation storage issues.

What is the best way to resolve stuck form activation issues in Aurora reservations?

Resolve stuck form activation issues in Aurora reservations by running sample queries against the agent_forms table to check activation statuses. The troubleshooting playbook uses log monitoring to isolate the failure point and apply targeted fixes to restore normal booking operations.