A Model Context Protocol (MCP) server for managing small business (UMKM) customer relationships, product sales, and order tracking using SQLite.
Project description
UMKM CRM (MCP Server)
A lightweight MCP server for managing small business (UMKM) customer relationships, product sales, and order tracking using SQLite.
This server is designed for micro and small enterprises (UMKM) — from warung kopi to online shops — that need simple CRM capabilities, including product tracking, customer records, WhatsApp promotions, and more.
✨ Features
- 💾 Record customer orders and interactions
- 📦 Manage product inventory and sales
- 🔔 Notify when stock is low
- 📈 View top-selling products and loyal customers
- 📄 Export weekly activity to CSV
- 📲 Send WhatsApp promotions (via external API)
📦 Installation
Install from PyPI:
pip install crm-umkm
🚀 Usage
You can run the server using:
uvx crm-umkm
Or configure it in a client like Cursor or any MCP-compatible app:
{
"mcpServers": {
"crm-umkm": {
"command": "uvx",
"args": ["crm-umkm"],
"env": {
"DB_PATH": "/absolute/path/to/crm.db",
"WHATSAPP_API_URL": "https://your-api.com/send",
"WHATSAPP_API_TOKEN": "your-api-token"
}
}
}
}
📁 Environment Variables
| Variable | Description | Default |
|---|---|---|
DB_PATH |
Path to SQLite database file | crm_umkm.db |
WHATSAPP_API_URL |
Base URL for sending WhatsApp messages | https://api.whatsapp.com/send |
WHATSAPP_API_TOKEN |
Token to authenticate with WhatsApp API service | (empty) |
The database will be initialized automatically on first run.
🧠 Prompt Behavior
This MCP server is specifically scoped for UMKM CRM tasks. The underlying LLM is guided to:
✅ Use these tools when:
- The user wants to record orders, view product stats, monitor stock, or export activity reports
- Managing small business customers and interactions
- Sending promotions via WhatsApp
🚫 Avoid using for:
- Enterprise-level CRM needs
- Marketing campaign automation at scale
- Large-scale ERP workflows
📂 Project Structure
crm-umkm/
└── src/
└── crm_umkm/
├── __init__.py
├── server.py
└── test.py
📝 License
ABRMS License
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file crm_umkm-0.1.0.tar.gz.
File metadata
- Download URL: crm_umkm-0.1.0.tar.gz
- Upload date:
- Size: 8.3 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/6.1.0 CPython/3.13.3
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
3312dda71110e0f3f82f326366b55f39ad98e7373ffbf8c76e6700f094b9540e
|
|
| MD5 |
5845699a536b79ac108a67e3ea4e0696
|
|
| BLAKE2b-256 |
7ac2d4470bdac5621dd32b99d85fe0f1eec3aa8662527d5d3e21fba00f02c72c
|
File details
Details for the file crm_umkm-0.1.0-py3-none-any.whl.
File metadata
- Download URL: crm_umkm-0.1.0-py3-none-any.whl
- Upload date:
- Size: 10.9 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/6.1.0 CPython/3.13.3
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
c06359246b54fc9305b659f33213f125de5b5aaff2dda96e21f63702595cbbf6
|
|
| MD5 |
5b2a347ca4a9b1298b151ed5fcc02deb
|
|
| BLAKE2b-256 |
e81020d9418e118aea1e3dbd75f6d386327693e9bacd2b79225d3a9237d1bf82
|