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
Metadata
Release files for crm-umkm 0.1.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | Actions |
|---|---|---|---|---|
| crm_umkm-0.1.0.tar.gz | 8.3 kB | Without provenance | Details for crm_umkm-0.1.0.tar.gz |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Actions Reset |
|---|---|---|---|---|
| crm_umkm-0.1.0-py3-none-any.whl | Python 3 | none | any | Details for crm_umkm-0.1.0-py3-none-any.whl |
Total release size: 19.2 kB
Release files / crm_umkm-0.1.0.tar.gz
| Download URL | crm_umkm-0.1.0.tar.gz |
|---|---|
| Size | 8.3 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
3312dda71110e0f3f82f326366b55f39ad98e7373ffbf8c76e6700f094b9540e
|
|
BLAKE2b-256 checksum How to use checksums |
7ac2d4470bdac5621dd32b99d85fe0f1eec3aa8662527d5d3e21fba00f02c72c
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.13.3
|
Release files / crm_umkm-0.1.0-py3-none-any.whl
| Download URL | crm_umkm-0.1.0-py3-none-any.whl |
|---|---|
| Size | 10.9 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
c06359246b54fc9305b659f33213f125de5b5aaff2dda96e21f63702595cbbf6
|
|
BLAKE2b-256 checksum How to use checksums |
e81020d9418e118aea1e3dbd75f6d386327693e9bacd2b79225d3a9237d1bf82
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.13.3
|
Security for crm-umkm 0.1.0
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.