Can I vibe code Tone Messaging?

Build a two-way conversational SMS marketing service using Node.js, Express, PostgreSQL, Twilio Messaging API, and OpenAI API (GPT-4o).

1. DATA MODEL:
Create tables for:
- `customers`: phone_number (unique, E.164), shopify_customer_id, opt_in_status (boolean), opt_in_timestamp, opt_out_timestamp, location_tz.
- `conversations`: id, customer_id, status ('active', 'escalated', 'closed'), updated_at.
- `messages`: id, conversation_id, direction ('inbound', 'outbound'), sender_type ('system', 'ai', 'human'), body, twilio_sid, status, created_at.
- `carts`: customer_id, shopify_cart_token, checkout_url, total_price, line_items (JSONB), abandoned_at.

2. SHOPIFY WEBHOOK INTEGRATION:
- Endpoint `/webhooks/shopify/checkouts-create` and `/webhooks/shopify/checkouts-update`.
- Store cart details. If checkout is uncompleted after 30 minutes, enqueue an abandoned cart recovery job.
- Before sending, verify TCPA compliance: opt_in_status must be true, and time must be between 8:00 AM and 9:00 PM in customer local timezone.
- Send initial SMS via Twilio: 'Hi {first_name}, noticed you left items in your cart. Any questions about {product_name}? Reply back! Stop to opt-out.'

3. TWILIO INBOUND WEBHOOK & LLM ROUTING:
- Endpoint `/webhooks/twilio/inbound`.
- Parse inbound message body and phone number.
- Handle keyword compliance immediately: If body equals 'STOP', 'UNSUBSCRIBE', or 'CANCEL', update customer opt_in_status = false, log opt_out_timestamp, reply with standard confirmation, and halt processing.
- Fetch conversation history (last 10 messages) and active cart details.
- System prompt for OpenAI: 'You are a helpful sales assistant for an e-commerce brand. Help the buyer complete their checkout. Offer product advice based on line_items. Maximum discount allowed is 10%. Never hallucinate larger discounts. Keep replies under 160 characters when possible. If user asks for human or expresses anger, return tag [ESCALATE].'
- If [ESCALATE] tag present, update conversation status to 'escalated' and trigger alert webhook to Slack/Email. Otherwise, send LLM reply via Twilio.

4. FAILURE MODES & SAFETY:
- Handle Twilio webhook retry deduplication using message SID.
- Ensure strict rate limiting (max 3 outbound messages per customer per hour).
- Mask all personally identifiable information except first name before sending to OpenAI API.

5. OUT OF SCOPE:
- Native 10DLC registration flow (assume Twilio Messaging Service SID is pre-configured).
- Multi-tenant enterprise RBAC UI.

$ each button prefixes agent-specific run instructions · build your own product, never copy proprietary code, trademarks or designs