← Back to Skills Marketplace
businessbrainsolutions

Charmie CRM Lite

by businessbrainsolutions · GitHub ↗ · v3.0.3 · MIT-0
cross-platform ✓ Security Clean
270
Downloads
1
Stars
0
Active Installs
6
Versions
Install in OpenClaw
/install charmie-crm-lite
Description
Lightweight CRM with SQLite – manage contacts. Upgrade to Pro for email, messaging, and more.
README (SKILL.md)

Charmie CRM Lite 3.0.3

Simple contact management with SQLite. Ask "Add John Doe", "Search for Mike", etc.

Email and messaging are not available in this version.
To enable email, WhatsApp, and advanced features, upgrade to the Professional version.

Usage Guidance
This skill appears to do what it says: a local SQLite contact manager exposed as tools via the modelcontextprotocol SDK. Before installing: (1) review and trust the npm dependencies (particularly @modelcontextprotocol/sdk) and run npm install in a controlled environment; (2) be aware the code will create contacts.db in the skill directory and will read a local .env file if present—avoid placing sensitive secrets in that .env for this directory; (3) verify the upgrade URL/homepage if you plan to follow it, since external upgrade pages may request payment or additional data; (4) if you need stronger isolation, run the skill in a sandbox or dedicated environment. Overall there are no signs of data exfiltration or unrelated credential requests.
Capability Analysis
Type: OpenClaw Skill Name: charmie-crm-lite Version: 3.0.3 The charmie-crm-lite skill is a functional contact management tool using SQLite. The code (index.js, db.js) correctly uses parameterized queries to prevent SQL injection and lacks any indicators of data exfiltration, unauthorized network access, or malicious execution. The 'Professional' features are implemented as placeholders that inform the user of limitations, which is consistent with the stated 'Lite' version description.
Capability Assessment
Purpose & Capability
Name/description match the provided code: the files implement a local SQLite contacts DB and tool handlers for add/search/update/delete. Declared dependencies (sqlite3, dotenv, and a local SDK to expose tools over stdio) are consistent with that purpose; there are no unrelated cloud credentials, binaries, or config paths requested.
Instruction Scope
SKILL.md and README instruct only to run npm install / setup and start the skill; runtime code operates on a local contacts.db and exposes tools over stdio. Minor note: both index.js and db.js call dotenv.config(), which will load a .env file into process.env if present. The code does not use or transmit environment variables anywhere, but the presence of dotenv means the skill will read local .env contents into memory.
Install Mechanism
No install spec is embedded in the registry; standard npm installation is used (package.json lists dependencies). Dependencies are normal and come from npm; there are no downloads from arbitrary URLs, no extracted archives, and no nonstandard install behavior.
Credentials
The skill declares no required environment variables (appropriate for a local SQLite app). As noted, dotenv is loaded at runtime and will populate process.env from a .env file if present; although the current code does not use those variables or send them externally, users should be aware the skill will read a .env if one exists in the same directory.
Persistence & Privilege
The skill does not request always:true, does not modify other skills, and only creates/uses a local contacts.db file in its own directory. It runs as a normal local process and does not request elevated/system-wide privileges.
How to Use
  1. Make sure OpenClaw is installed (local or Docker)
  2. Run the install command in chat: /install charmie-crm-lite
  3. After installation, invoke the skill by name or use /charmie-crm-lite
  4. Provide required inputs per the skill's parameter spec and get structured output
Version History
v3.0.3
- Simplified to pure contact management—email and messaging features removed from Lite version. - No environment variables needed; runs out of the box. - Updated description and usage instructions to clarify feature changes. - Added clear information on upgrading to regain email and messaging capabilities. # Charmie CRM Lite 3.0.3 - Removed all email and messaging functionality; now purely contact management (add, search, delete, update). - email_all and message_all tools now display an upgrade message pointing to the Professional version. - No environment variables are required – the skill runs immediately after `npm install` and `node setup.js`. - Eliminated all dependencies except `sqlite3`, `dotenv`, and the MCP SDK. - This version fully aligns with ClawHub security expectations and has no suspicious patterns.
v3.0.0
Major upgrade: SQLite database support and messaging features added. - Switched database backend from PostgreSQL to SQLite for easier setup. - New ability to send emails and messages to contacts. - Updated environment variable requirements for email and messaging integration. - Added new files for database and contact management logic. - Dropped legacy schema file used in previous PostgreSQL version.
v2.1.3
- Added DB_PORT to environment variable requirements for improved database connection configuration. - No other changes detected. # Charmie CRM Lite 2.1.3 - **Added MCP SDK dependency** – Ensures the required `@modelcontextprotocol/sdk` is installed, preventing runtime errors. - **Explicit environment metadata** – `DB_PORT` is now listed in SKILL.md under required env vars (with default 5432), making all configuration parameters transparent. - **No functional changes** – The skill remains a pure, secure PostgreSQL contact search tool.
v2.1.2
- Major simplification: Now a pure MCP tool searching contacts by name in PostgreSQL. - Removed all AI integrations, Google services, and WhatsApp features. - Environment variables now limited to PostgreSQL connection only. - Old files for database logic, Google Auth, and tools removed; added a single schema.sql for database structure. - Updated description and metadata to reflect the streamlined functionality. # Changelog for Charmie CRM Lite 2.1.2 **Released:** March 2026 **Focus:** Security, transparency, and simplification ## What's Changed - **Removed all AI components** – No Gemini API key required. The skill no longer uses any generative AI, eliminating the need for `GEMINI_API_KEY` and the `@google/generative-ai` dependency. - **Eliminated Google-related code** – Removed `google-auth.js`, `prompts.js`, and any references to Google Contacts sync. The Lite version now uses a single, simple `contacts` table. - **Safer setup process** – The `setup.js` script no longer executes `psql` commands directly. Instead, it prints the SQL schema for you to run manually, avoiding shell injection risks and credential exposure. - **Reduced dependencies** – Only `pg` (PostgreSQL driver) and `dotenv` remain. Fewer dependencies mean a smaller attack surface. - **Streamlined functionality** – The skill now focuses solely on searching contacts by name in a PostgreSQL database, exactly as advertised. - **Improved documentation** – README and SKILL.md have been updated to clearly state what the skill does (and does not do). ## Why Upgrade? - **No unexplained requirements** – All environment variables (`DB_HOST`, `DB_NAME`, `DB_USER`, `DB_PASSWORD`) are directly tied to the skill's core function. - **No background processes** – The skill runs only when invoked by OpenClaw; it does not start any autonomous services. - **Full transparency** – Every file in this version is necessary and directly supports the described feature. This release brings Charmie CRM Lite into full compliance with ClawHub’s security best practices, ensuring a safe and predictable experience for all users. For questions or feedback, contact: [[email protected]](mailto:[email protected])
v2.1.1
- Added clarification that name search features operate via OpenClaw. - Updated version number to 2.1.1. This release focuses on security, transparency, and simplicity. Removed WhatsApp integration completely – The skill is now a pure MCP tool with no autonomous network activity. It does not start any background processes or listen for incoming messages. No persistent home directory writes – The skill no longer creates ~/.charmie_usage or ~/.wwebjs_auth. The only file written is .env (for configuration), which the user explicitly creates during setup. Eliminated unused code – Removed google-auth.js and other placeholders that were not used in the Lite version, reducing the attack surface. Streamlined functionality – Focuses solely on name-based contact search via OpenClaw, exactly as described. Enhanced documentation – Added clear explanations of what the skill does and does not do. This version is now fully aligned with OpenClaw’s security best practices: no background services, no unexpected file writes, and complete transparency.
v2.1.0
- Updated to version 2.1.0 - Improved skill description and upgrade information - Added details on required environment variables for operation - Enhanced upgrade section with direct website and email contact information
Metadata
Slug charmie-crm-lite
Version 3.0.3
License MIT-0
All-time Installs 0
Active Installs 0
Total Versions 6
Frequently Asked Questions

What is Charmie CRM Lite?

Lightweight CRM with SQLite – manage contacts. Upgrade to Pro for email, messaging, and more. It is an AI Agent Skill for Claude Code / OpenClaw, with 270 downloads so far.

How do I install Charmie CRM Lite?

Run "/install charmie-crm-lite" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.

Is Charmie CRM Lite free?

Yes, Charmie CRM Lite is completely free, licensed under MIT-0. You can download, install and use it at no cost.

Which platforms does Charmie CRM Lite support?

Charmie CRM Lite is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).

Who created Charmie CRM Lite?

It is built and maintained by businessbrainsolutions (@businessbrainsolutions); the current version is v3.0.3.

💬 Comments