杨轩
144 lines
4.3 KiB
Markdown
144 lines
4.3 KiB
Markdown
# TOOLS.md - Local Notes
|
||
|
||
Skills define _how_ tools work. This file is for _your_ specifics — the stuff that's unique to your setup.
|
||
|
||
## What Goes Here
|
||
|
||
Things like:
|
||
|
||
- Camera names and locations
|
||
- SSH hosts and aliases
|
||
- Preferred voices for TTS
|
||
- Speaker/room names
|
||
- Device nicknames
|
||
- Anything environment-specific
|
||
|
||
## Examples
|
||
|
||
```markdown
|
||
### Cameras
|
||
|
||
- living-room → Main area, 180° wide angle
|
||
- front-door → Entrance, motion-triggered
|
||
|
||
### SSH
|
||
|
||
- home-server → 192.168.1.100, user: admin
|
||
|
||
### TTS
|
||
|
||
- Preferred voice: "Nova" (warm, slightly British)
|
||
- Default speaker: Kitchen HomePod
|
||
```
|
||
|
||
## Why Separate?
|
||
|
||
Skills are shared. Your setup is yours. Keeping them apart means you can update skills without losing your notes, and share skills without leaking your infrastructure.
|
||
|
||
---
|
||
|
||
Add whatever helps you do your job. This is your cheat sheet.
|
||
|
||
### mica 项目数据库
|
||
|
||
- **主机：** 47.99.209.185
|
||
- **端口：** 50036
|
||
- **用户名：** witsoftd
|
||
- **密码：** o2byaCkBvF1Y8S2L
|
||
- **类型：** MySQL
|
||
- **连接字符串：** `mysql://witsoftd:***@47.99.209.185:50036/mica`
|
||
|
||
### 🔴 mica 项目 git 操作红线
|
||
|
||
- **禁止 git push** - 只能 commit，push 操作必须由用户手动执行
|
||
- **禁止擅自提交项目代码到 git** - 必须先询问用户确认后再提交
|
||
|
||
### sql-toolkit 技能使用
|
||
|
||
**技能位置：** `/root/.openclaw/workspace-backend/skills/sql-toolkit/SKILL.md`
|
||
|
||
**支持数据库：** SQLite、PostgreSQL、MySQL
|
||
|
||
**常用命令：**
|
||
```bash
|
||
# MySQL 连接
|
||
mysql -h 47.99.209.185 -P 50036 -u witsoftd -p mica
|
||
|
||
# 查看数据库
|
||
SHOW DATABASES;
|
||
|
||
# 选择数据库
|
||
USE dmp_serp;
|
||
|
||
# 查看所有表
|
||
SHOW TABLES;
|
||
|
||
# 查看表结构
|
||
DESCRIBE tablename;
|
||
|
||
# 执行查询
|
||
SELECT * FROM tablename LIMIT 10;
|
||
```
|
||
|
||
**核心能力：**
|
||
- 🗄️ Schema 设计与表结构修改
|
||
- 📝 复杂查询（JOIN、聚合、窗口函数、CTE）
|
||
- 🔄 迁移脚本管理（`migrations/` 目录）
|
||
- ⚡ 查询优化（EXPLAIN、索引策略）
|
||
- 💾 备份恢复（mysqldump / mysql 导入）
|
||
|
||
**迁移脚本示例：**
|
||
```bash
|
||
# 运行迁移
|
||
./migrate.sh "mysql://witsoftd:***@47.99.209.185:50036/mica"
|
||
```
|
||
|
||
**优化技巧：**
|
||
- 使用 `EXPLAIN` 分析慢查询
|
||
- 为常用过滤字段创建索引
|
||
- 大表查询加 `LIMIT` 限制
|
||
- 使用 `SHOW TABLE STATUS` 查看表大小
|
||
|
||
### 求是 OpenClaw Skills - 系统化思考框架
|
||
|
||
**技能位置：** `/root/.openclaw/workspace-backend/skills/qiushi-openclaw-skill/SKILL.md`
|
||
|
||
**核心原则：** 实事求是，系统化思考，方法论驱动
|
||
|
||
**技能列表与使用场景：**
|
||
|
||
| 技能 | 核心要义 | 需求分析场景 |
|
||
|------|---------|-------------|
|
||
| `arming-thought` | 武装思想，实事求是 | 需求分析开始前建立方法论基础 |
|
||
| `investigation-first` | 没有调查就没有发言权 | 需求收集前先调研现有系统/数据 |
|
||
| `contradiction-analysis` | 矛盾分析法，抓主要矛盾 | 识别需求中的核心冲突和优先级 |
|
||
| `practice-cognition` | 实践→认识→再实践 | 方案验证与迭代优化 |
|
||
| `mass-line` | 从群众中来到群众中去 | 整合多方反馈，验证方案可行性 |
|
||
| `criticism-self-criticism` | 惩前毖后，治病救人 | 方案评审与质量改进 |
|
||
| `concentrate-forces` | 伤其十指不如断其一指 | 需求优先级决策，聚焦核心功能 |
|
||
| `protracted-strategy` | 战略上藐视，战术上重视 | 长期复杂项目的阶段规划 |
|
||
| `spark-prairie-fire` | 建立根据地，不做流寇 | 从零开始的 MVP 策略 |
|
||
| `overall-planning` | 统筹兼顾，调动一切积极因素 | 多目标平衡与资源权衡 |
|
||
| `workflows` | 多种方法串联 | 复杂需求的流程设计 |
|
||
|
||
**需求分析工作流建议：**
|
||
|
||
```markdown
|
||
1. arming-thought → 建立实事求是的方法论基础
|
||
2. investigation-first → 调研现有系统、数据、流程
|
||
3. contradiction-analysis → 识别核心矛盾和关键需求
|
||
4. concentrate-forces → 确定优先级，聚焦核心功能
|
||
5. overall-planning → 统筹兼顾，平衡多目标
|
||
6. practice-cognition → 输出方案，等待反馈迭代
|
||
```
|
||
|
||
**使用原则：**
|
||
- 需求不明确时 → 先用 `investigation-first`
|
||
- 需求冲突时 → 用 `contradiction-analysis` 抓主要矛盾
|
||
- 资源有限时 → 用 `concentrate-forces` 做优先级决策
|
||
- 方案评审时 → 用 `criticism-self-criticism` 自我审视
|
||
|
||
## Related
|
||
|
||
- [Agent workspace](/concepts/agent-workspace)
|