Can I vibe code Rare.io?

Build a self-hosted predictive email marketing microservice in Node.js and PostgreSQL to replace Rare.io for a Shopify store.

1. DATA MODEL & INGESTION:
- Store Tables: `customers`, `products`, `orders`, `line_items`, `cart_events`, `email_campaigns`, `suppression_list`.
- Ingest Shopify webhooks for `orders/create`, `carts/update`, and `customers/create`.
- Store order history and calculate co-occurrence matrix: count how often Product A and Product B are purchased in the same order.

2. PREDICTIVE LOGIC ENGINE:
- Calculate expected repurchase date per customer based on mean days between their historic orders. Trigger replenishment emails 3 days prior.
- Build a recommendation endpoint: for a given `customer_id` or `product_id`, return top 3 recommended products based on co-occurrence and highest gross margin.
- Segment customers dynamically: New, Active, At-Risk (1.5x average reorder interval passed), Lost (3x average reorder interval passed).

3. AUTOMATION & EMAIL DISPATCH:
- Implement job queues using Redis (BullMQ) for workflow execution.
- Triggers: Abandoned Cart (1 hour post-event), Post-Purchase Follow Up (14 days post-purchase), Replenishment (predictive date).
- Render HTML templates using MJML library to guarantee cross-client rendering. Pass recommended product image URLs, titles, and prices dynamically into the template.
- Send outbound emails via Resend or AWS SES API.

4. COMPLIANCE & DELIVERABILITY:
- Include single-click unsubscribe link in header and footer (RFC 8058 compliant).
- Maintain strict suppression table to immediately block queued sends to unsubscribed or bounced addresses.
- Track open and click webhooks from email provider and compute conversion attribution.

5. OUT OF SCOPE:
- Drag-and-drop visual email editor (use raw MJML templates).
- Multi-tenant SaaS dashboard (single store instance only).

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