← 返回 Skills 市场
228
总下载
0
收藏
0
当前安装
2
版本数
在 OpenClaw 中安装
/install friends-db
功能描述
Query and maintain Alex's local friends database stored in a private SQLite file under the OpenClaw workspace. Use when looking up a friend, finding phone/em...
使用说明 (SKILL.md)
Friends DB
Use the helper script in scripts/friends_db.py. Do not run arbitrary SQL.
When to use
- A request depends on friend/contact details that used to live in
friends.md - You need a phone number, email, preferred name, or relationship note
- You need to track friendship cadence, last-seen dates, or activity ideas
- You need to add or update a friend fact after a conversation or event
- You need to sync past in-person interactions from calendar into the friend CRM
Commands
Initialize or migrate:
python3 ./skills/friends-db/scripts/friends_db.py migrate --source "$HOME/.openclaw/workspace/friends.md" --replace-with-stub
Search:
python3 ./skills/friends-db/scripts/friends_db.py search "lily"
python3 ./skills/friends-db/scripts/friends_db.py list
Show one contact:
python3 ./skills/friends-db/scripts/friends_db.py show "Lily Li"
python3 ./skills/friends-db/scripts/friends_db.py show "[email protected]"
Friend CRM overview:
python3 ./skills/friends-db/scripts/friends_db.py due-list
python3 ./skills/friends-db/scripts/friends_db.py due-list --status all --within-days 14
python3 ./skills/friends-db/scripts/friends_db.py profile "David Su"
python3 ./skills/friends-db/scripts/friends_db.py suggest "David Su"
CRM setup and updates:
python3 ./skills/friends-db/scripts/friends_db.py set-importance "David Su" high
python3 ./skills/friends-db/scripts/friends_db.py set-cadence "David Su" 21
python3 ./skills/friends-db/scripts/friends_db.py set-context "David Su" --home-area "South Bay" --best-times "weekday evenings"
python3 ./skills/friends-db/scripts/friends_db.py add-tag "David Su" interest pickleball
python3 ./skills/friends-db/scripts/friends_db.py add-tag "David Su" neighborhood "South Park"
Interaction logging:
python3 ./skills/friends-db/scripts/friends_db.py log-interaction "David Su" --type in_person --at 2026-03-15T18:30:00-07:00 --location "South Park"
python3 ./skills/friends-db/scripts/friends_db.py sync-calendar --days-back 180
General contact updates:
python3 ./skills/friends-db/scripts/friends_db.py add-fact "Lily Li" "Invited to dinner on 2026-03-20"
python3 ./skills/friends-db/scripts/friends_db.py set-method "David Su" phone "+14086246128" --primary
python3 ./skills/friends-db/scripts/friends_db.py set-preferred-name "Lily Li" "Lily"
Rules
- Keep the database in the hidden OpenClaw workspace state directory created by the helper.
- The helper enforces private filesystem permissions and parameterized SQL. Keep using it instead of shelling out to
sqlite3with raw user text. - Treat
friends.mdas a stub only after migration. The database is the source of truth. sync-calendaruses attendee email first, then title/description alias matches.- Count only
in_personinteractions toward the cadence target. Calls/texts/emails are supporting context. - Cadence defaults:
high=20,medium=30,low=90days. - Suggestions are local and deterministic; they come from tags plus the bundled activity template asset.
- Return only the fields needed for the task. Do not dump the whole contact database into chat unless Alex explicitly asks.
安全使用建议
This skill appears to do what it claims: manage a local, private friends SQLite DB and migrate from friends.md. Before installing or invoking it: 1) Inspect the remainder of scripts/friends_db.py (the truncated portion) to confirm what sync-calendar does and whether any subprocess calls contact external servers or execute shell commands with user-provided strings. 2) Expect the skill to create a hidden DB under your OpenClaw workspace (it sets restrictive filesystem permissions). If you plan to use calendar sync, confirm how credentials are obtained (it does not declare required credentials in metadata). 3) Run it in a controlled environment (or review the code line-by-line) if you have sensitive data in your workspace. Overall coherence is good, but review the subprocess/calendar code to raise confidence to high.
功能分析
Type: OpenClaw Skill
Name: friends-db
Version: 0.2.0
The friends-db skill is a local CRM tool for managing contact information and interaction history via a SQLite database. The implementation in scripts/friends_db.py follows security best practices, including the use of parameterized SQL queries to prevent injection, strict file permissions (0o600/0o700) for local data privacy, and symlink/path validation during the migration process. While it utilizes an external 'gog' CLI for calendar synchronization, this functionality is explicitly documented in SKILL.md and aligned with the tool's stated purpose without evidence of malicious intent or data exfiltration.
能力评估
Purpose & Capability
Name/description match the shipped script and assets. The script operates on a local SQLite DB in the OpenClaw workspace and provides search, show, CRUD, and migration commands — all consistent with a 'friends DB' helper. No unrelated services or credentials are requested.
Instruction Scope
SKILL.md restricts operations to the helper script and points to specific CLI commands (migrate, search, show, set-*, log-interaction, sync-calendar). It reads the workspace friends.md and the local DB. One caveat: sync-calendar and the script import subprocess (truncated portion not fully visible) — this suggests the script may call external calendar tooling or shell commands. That behavior is within scope if used to read calendar events, but you should review exactly what sync-calendar does and what subprocess calls it makes to ensure it doesn't call unexpected network endpoints or shell out with unsanitized input.
Install Mechanism
No install spec; this is instruction-only with a bundled Python script and JSON asset. No downloads, package installs, or archive extraction are performed by the skill metadata.
Credentials
No required environment variables or credentials are declared. The script reads optional env vars (OPENCLAW_WORKSPACE, OPENCLAW_FRIENDS_DB_DIR, OPENCLAW_FRIENDS_CALENDAR_ACCOUNT/ID/TIMEZONE) that are directly relevant to configuring where the DB and calendar account live. No unexpected secret access is requested.
Persistence & Privilege
always is false and the skill does not request elevated platform privileges. It creates and writes a private DB under the workspace and enforces 0700/0600 permissions for dirs/files. It does not modify other skills or global agent settings.
如何使用
- 确保已安装 OpenClaw（本地或 Docker 部署）
- 在对话框中输入安装命令：
/install friends-db - 安装完成后，直接呼叫该 Skill 的名称或使用
/friends-db触发 - 根据 Skill 的参数说明提供必要输入，即可获得结构化输出
版本历史
v0.2.0
Add friend CRM fields, interaction history, calendar sync, due lists, profiles, and local activity suggestions.
v0.1.1
Harden migrate source handling, tighten installer backup permissions, and add search indexes.
元数据
常见问题
Friends DB 是什么？
Query and maintain Alex's local friends database stored in a private SQLite file under the OpenClaw workspace. Use when looking up a friend, finding phone/em... 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件，目前累计下载 228 次。
如何安装 Friends DB？
在 OpenClaw 或 Claude Code 对话框中运行命令「/install friends-db」即可一键安装，无需额外配置。
Friends DB 是免费的吗？
是的，Friends DB 完全免费，采用 MIT-0 许可证，可自由下载、安装和使用。
Friends DB 支持哪些平台？
Friends DB 跨平台运行，可在任意部署了 OpenClaw / Claude Code 的环境中使用（cross-platform）。
谁开发了 Friends DB？
由 Alex（@alexuser）开发并维护，当前版本 v0.2.0。
推荐 Skills