开源模板，用于将Pancake（Zalo OA / Facebook Messenger / Instagram）数据同步到您自己的Supabase，内置管理界面、面向AI代理的MCP服务器及B2B合作伙伴分类。

** 🌐 现场演示** ·** 📖 设置指南** ·** 🤖 MCP使用**

🎬 演示

https://github.com/aiecosvietnam/aiecos-social-crm/releases/download/v1.0.0/demo.mp4

11秒攻略 — 仪表盘 ·收件箱 ·流水线 ·合作伙伴360 ·性能。 GitHub.com 上内联播放器自动渲染。备用：直接下载。

---

它的作用：

• 📥 Chrome 扩展将 Pancake DOM → POST 读入你的同步接收器
• 💾 同步接收器写入 Supabase 模式（[pages、customers、conversations、messages）
• 🖥 独立管理界面（单个HTML文件），读取Supabase REST API的音频
• 🤖 MCP 服务器允许 Claude / 任何 MCP 客户端通过自然语言直接查询数据
• 📊 五阶段伴侣分类：活跃/睡眠/风险/休眠/搅动
• 📄 导出CSV + 可打印HTML报告
• 💬 内置收件箱（三窗格）、分流警报、管道看板
• 🎭 演示模式——无需设置Supabase即可立即尝试界面

Stack： 节点。

AIECOS Social CRM

Open-source template to sync Pancake (Zalo OA / Facebook Messenger / Instagram) data into your own Supabase, with a built-in admin UI, MCP server for AI agents, and B2B partner classification.

🌐 Live demo · 📖 Setup guide · 🤖 MCP usage

🎬 Demo

https://github.com/aiecosvietnam/aiecos-social-crm/releases/download/v1.0.0/demo.mp4

11-second walkthrough — Dashboard · Inbox · Pipeline · Partner 360 · Performance. Inline player auto-renders on GitHub.com. Fallback: direct download.

---

What it does:

• 📥 Chrome extension reads Pancake DOM → POST to your sync receiver
• 💾 Sync receiver writes to Supabase schema (pages, customers, conversations, messages)
• 🖥 Standalone admin UI (single HTML file) reads from Supabase REST API
• 🤖 MCP server lets Claude / any MCP client query data directly via natural language
• 📊 5-stage partner classification: Active / Sleeping / At-Risk / Dormant / Churned
• 📄 Export CSV + printable HTML reports
• 💬 Built-in Inbox (3-pane), Triage alerts, Pipeline kanban
• 🎭 Demo mode — try the UI instantly without setting up Supabase

Stack: Node.js + Express, Supabase (Postgres + PostgREST), Chrome Manifest V3, MCP SDK.

---

Architecture

┌─────────────────┐   POST       ┌──────────────────┐   upsert    ┌──────────────┐
│ Pancake DOM     │  ─────────▶  │ Sync Receiver    │  ────────▶  │ Supabase     │
│ (Chrome ext)    │              │ (Node + Express) │             │ aiecos_social│
└─────────────────┘              └──────────────────┘             └──────┬───────┘
                                                                         │ PostgREST
                                          ┌──────────────────────────────┘
                                          ▼
                                   ┌──────────────┐         ┌──────────────┐
                                   │ Admin UI     │         │ MCP Server   │
                                   │ (HTML/JS)    │         │ (for Claude) │
                                   └──────────────┘         └──────────────┘

---

Screenshots

Admin UI — Dashboard (live data from your own Supabase):

• 📊 KPI cards: Total partners / Active / At-Risk / Dormant+Churned / Total messages
• 📈 14-day activity trend (Customer vs Agent split)
• 💬 Recent messages stream

Pipeline Kanban — 5 stages with auto-classification: