explaingit

aiecosvietnam/aiecos-social-crm

★ 15HTMLAudience · pm founderComplexity · 3/5LicenseSetup · moderate

TLDR

An open-source CRM template for Vietnamese businesses on the Pancake messaging platform that tracks partner relationships via a Chrome extension, a self-hosted server, and a Supabase database.

Mindmap

mindmap
  root((aiecos-social-crm))
    What it does
      Tracks partner conversations
      Syncs from Pancake UI
      Self-hosted customer CRM
    Components
      Chrome extension
      Node.js Express server
      Supabase Postgres
      Admin dashboard HTML
      MCP AI query layer
    Partner stages
      Active 0-3 days
      Sleeping 3-7 days
      At-Risk 7-30 days
      Dormant 30-90 days
      Churned 90+ days
    Install options
      Docker Compose one-command
      Manual component setup
      Demo mode no database
    Tech stack
      HTML
      Node.js
      Express
      Supabase
Click or tap to explore — scroll the page freely

Code map

Detail Auto

An interactive map of this repo's files and how they connect — its source is parsed live in your browser. Click Visualize to build it.

filefunction / class

Things people build with this

USE CASE 1

Track all your Pancake business conversations in a self-hosted kanban board that shows which partners are going quiet before they churn.

USE CASE 2

Export a 14-day message trend report as CSV to review your sales team's partner engagement in a weekly meeting.

USE CASE 3

Use the MCP server to let Claude query your customer database in plain English, such as asking which partners have not replied in two weeks.

USE CASE 4

Set up a demo of the CRM dashboard to show management how partner health stages work before connecting real data.

Tech stack

HTMLNode.jsExpressSupabaseDockerChrome Extension

Getting it running

Difficulty · moderate Time to first run · 30min

Requires a Supabase account (or local Postgres) and the Pancake web interface, Docker Compose simplifies the multi-component setup.

MIT license, use freely for any purpose, including commercial, as long as you keep the copyright notice.

In plain English

This is an open-source CRM template built for businesses that use Pancake, a customer messaging platform popular in Vietnam that aggregates conversations from Zalo, Facebook Messenger, and Instagram. The project is aimed at Vietnamese B2B sellers and distributors who want to track their partner relationships without storing all that data inside Pancake's own system. The template has four main pieces. A Chrome extension monitors the Pancake web interface and captures conversation data as it appears on screen, then sends it to a small server you run yourself. That server, built with Node.js and Express, writes the data into Supabase, which is a hosted Postgres database. A standalone admin dashboard, packaged as a single HTML file, reads from that database and shows it in your browser. There is also an MCP server, which is a connection layer that lets AI tools like Claude query your customer data using plain-language requests. The dashboard classifies business partners into five stages based on how recently they have been in contact: Active (within 3 days), Sleeping (3 to 7 days), At-Risk (7 to 30 days), Dormant (30 to 90 days), and Churned (over 90 days). These appear as a kanban board. The system also shows a 14-day message trend, a triage view that highlights partners going quiet, and a full partner detail page. CSV export and printable HTML reports are included. Setup can be done in one command using Docker Compose, which starts a local Postgres database, the REST API layer, the sync receiver, and the admin UI together. Alternatively, you can set up each component manually. You connect the admin UI by pasting your Supabase URL and key into a settings screen. A demo mode lets you try the interface without connecting to any database. The project is MIT licensed and built by AIECOS, a Vietnamese company that builds AI tools for local businesses. The README is primarily in English with some Vietnamese. The roadmap mentions future integrations with HubSpot, Salesforce, and Vietnamese commerce platforms.

Copy-paste prompts

Prompt 1
I want to set up aiecos-social-crm using Docker Compose. Walk me through installing it, connecting the Chrome extension to Pancake, and viewing the kanban dashboard.
Prompt 2
How does the Chrome extension in aiecos-social-crm capture conversation data from Pancake without breaking or modifying the Pancake interface?
Prompt 3
I have aiecos-social-crm running. How do I connect the MCP server to Claude so I can ask plain-English questions about my partner data?
Prompt 4
A partner shows as At-Risk in my aiecos-social-crm dashboard. What does that mean and what actions does the system suggest?
Open on GitHub → Explain another repo

← aiecosvietnam on gitmyhub — every repo by this author, as a profile.

Verify against the repo before relying on details.