content-ops

Social media content operations automation system with SQLite database. Manage content crawling, curation, publishing, and analytics across platforms (Xiaohongshu, Reddit, Pinterest, Discord).

View Source SKILL.md

Stars

Installs

Status

ACTIVE

Visibility

PUBLIC

安装方式

直接复制以下提示词，发送给你的 AI 助手即可完成安装。

请先检查是否已安装 SkillHub 商店，若未安装，请根据 https://skillhub-1388575217.cos.ap-guangzhou.myqcloud.com/install/skillhub.md 安装 SkillHub 商店，然后安装 content-ops 技能。若已安装，则直接安装 content-ops 技能。

Overview

Skill Key: cwyhkyochen-a11y/content-ops
Author: cwyhkyochen-a11y
Source Repo: openclaw/skills
Version: -
Source Path: skills/cwyhkyochen-a11y/content-ops
Latest Commit SHA: 81d59d4912fe9e60cf042c0d915e7e5b123fa919

Extracted Content

SKILL.md excerpt

# Content Ops System

社交媒体内容运营自动化系统，使用 **SQLite + Drizzle ORM** 存储数据，支持小红书、Reddit、Pinterest、Discord 等平台的内容抓取、策划、发布和数据分析。

---

## 📋 目录

1. [初始化部署](#一初始化部署)
2. [测试任务](#二测试任务)
3. [正式任务](#三正式任务)
4. [工作流详解](#四工作流详解)
5. [参考文档](#五参考文档)

---

## 一、初始化部署

### 1.1 基础环境

#### Node.js 依赖
```bash
cd /home/admin/.openclaw/workspace/skills/content-ops

# 安装依赖
npm install

# 生成并执行数据库迁移
npx drizzle-kit generate
npx drizzle-kit migrate
```

#### Python 依赖（可选，用于增强功能）
```bash
# 如果需要使用 xiaohongshutools skill
pip install aiohttp loguru pycryptodome getuseragent requests
```

### 1.2 MCP 服务部署

#### 小红书 MCP (xpzouying/xiaohongshu-mcp)

**下载部署：**
```bash
cd ~/.openclaw/workspace/bin

# 下载二进制文件
wget https://github.com/xpzouying/xiaohongshu-mcp/releases/download/v2026.02.28.1720-8a7fe21/xiaohongshu-mcp-linux-amd64.tar.gz
tar -xzf xiaohongshu-mcp-linux-amd64.tar.gz

# 登录（首次，扫码）
./xiaohongshu-login

# 启动服务（后台运行）
screen -dmS xhs-mcp ./xiaohongshu-mcp -headless=true
```

**服务信息：**
- 端口：`18060`
- 端点：`http://localhost:18060`
- Cookie 文件：`~/.openclaw/workspace/bin/cookies.json`

**验证服务：**
```bash
curl http://localhost:18060/api/v1/login/status
```

### 1.3 数据库初始化

**自动创建的数据表：**
| 表名 | 用途 | 核心字段 |
|------|------|----------|
| `target_accounts` | 被运营账号（Reddit等） | platform, api_config, positioning |
| `source_accounts` | 信息源账号（小红书等） | login_status, daily_quota |
| `crawl_tasks` | 抓取任务 | status, query_list, target_count |
| `crawl_results` | 抓取结果 | source_url, content, quality_score |
| `publish_tasks` | 发布任务 | status, content, scheduled_at |
| `publish_metrics_daily` | 发布内容每日数据 | metric_date, reddit_score |
| `target_accounts_metrics_daily` | 账号整体每日数据 | followers_change, engagement_rate |

**数据库位置：**
```
~/.openclaw/workspace/...

Related Claw Skills

heyixuan2

bambu-studio-ai

★ 41

Bambu Lab 3D printer control and automation. Activate when user mentions: printer status, 3D printing, slice, analyze model, generate 3D, AMS filament, print monitor, Bambu Lab, or any 3D printing task. Full pipeline: search → generate → analyze → colorize → preview → open BS → user slice → print → monitor. Supports all 9 Bambu Lab printers (A1 Mini, A1, P1S, P2S, X1C, X1E, H2C, H2S, H2D).

human-pages-ai

humanpages

★ 3

Search and hire real humans for tasks — photography, delivery, research, and more

zseven-w

openclaw-skills

★ 1

Reusable skill templates for OpenClaw AI agents. Templates for API integration, data processing, web scraping, CLI tools, and file processing.

capt-marbles

geo-optimization

★ 1

Generative Engine Optimization (GEO) for AI search visibility. Optimize content to appear in ChatGPT, Perplexity, Claude, and Google AI Overviews. Use when optimizing websites, pages, or content for LLM discoverability and citation.

camopel

ddgs-search

★ 0

Free multi-engine web search via ddgs CLI (DuckDuckGo, Google, Bing, Brave, Yandex, Yahoo, Wikipedia) + arXiv API search. No API keys required. Use when user needs web search, research paper discovery, or when other skills need a search backend. Drop-in replacement for web-search-plus.

camopel

arxivkb

★ 0

Local arXiv paper manager with semantic search. Crawls arXiv categories, downloads PDFs, chunks content, and indexes with FAISS + Ollama embeddings. No cloud API keys required — everything runs locally.