Skip to main content

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)

Source distribution for crm-umkm 0.1.0
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)

Table of built distributions (wheels) for crm-umkm 0.1.0
File Interpreter ABI Platform Actions
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.

Release history Release notifications | RSS feed

This release

0.1.0 This release

2 release files No provenance

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page