← 返回 Skills 市场
Charmie CRM Lite
作者
businessbrainsolutions
· GitHub ↗
· v3.0.3
· MIT-0
270
总下载
1
收藏
0
当前安装
6
版本数
在 OpenClaw 中安装
/install charmie-crm-lite
功能描述
Lightweight CRM with SQLite – manage contacts. Upgrade to Pro for email, messaging, and more.
使用说明 (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.
安全使用建议
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.
功能分析
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.
能力评估
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.
如何使用
- 确保已安装 OpenClaw(本地或 Docker 部署)
- 在对话框中输入安装命令:
/install charmie-crm-lite - 安装完成后,直接呼叫该 Skill 的名称或使用
/charmie-crm-lite触发 - 根据 Skill 的参数说明提供必要输入,即可获得结构化输出
版本历史
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
元数据
常见问题
Charmie CRM Lite 是什么?
Lightweight CRM with SQLite – manage contacts. Upgrade to Pro for email, messaging, and more. 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件,目前累计下载 270 次。
如何安装 Charmie CRM Lite?
在 OpenClaw 或 Claude Code 对话框中运行命令「/install charmie-crm-lite」即可一键安装,无需额外配置。
Charmie CRM Lite 是免费的吗?
是的,Charmie CRM Lite 完全免费,采用 MIT-0 许可证,可自由下载、安装和使用。
Charmie CRM Lite 支持哪些平台?
Charmie CRM Lite 跨平台运行,可在任意部署了 OpenClaw / Claude Code 的环境中使用(cross-platform)。
谁开发了 Charmie CRM Lite?
由 businessbrainsolutions(@businessbrainsolutions)开发并维护,当前版本 v3.0.3。
推荐 Skills