content-ops

What This Skill Does

The Content Ops (content-ops) skill is a robust automation suite designed for social media managers and content creators. It provides an end-to-end workflow for managing multi-platform content lifecycles, including Xiaohongshu (Little Red Book), Reddit, Pinterest, and Discord. Built on a performant SQLite backend with Drizzle ORM, the skill enables developers and power users to automate the extraction, curation, publishing, and analytical tracking of content. It features a sophisticated MCP-integrated architecture that handles complex authentication and real-time data fetching, allowing for data-driven decisions based on platform engagement metrics.

Installation

To deploy this skill, ensure your OpenClaw environment is properly configured. Run clawhub install openclaw/skills/skills/cwyhkyochen-a11y/content-ops in your terminal. After the initial installation, navigate to the workspace directory to run npm install followed by npx drizzle-kit migrate to initialize your local database schema. Finally, ensure the MCP service (specifically the xiaohongshu-mcp) is running at http://localhost:18060 with your credentials synced to cookies.json.

Use Cases

This skill is ideal for content agencies and solo creators needing to scale their digital footprint. Use it to: 1) Automatically curate trending AI content from Xiaohongshu based on specific keywords. 2) Schedule recurring posts to Reddit subreddits with automated engagement logging. 3) Analyze weekly performance metrics across multiple social accounts using centralized data storage. 4) Maintain a consistent pipeline of high-quality content by filtering automated crawls through your custom approval workflow.

Example Prompts

1. "Content Ops, scan Xiaohongshu for the latest trends in 'AI video tools' and save the top 10 most liked posts to my database for review."
2. "Show me the engagement report for my Reddit accounts for the past 7 days and identify which posts had the highest conversion rate."
3. "Create a new publishing task for the selected content in task #452 and schedule it for deployment to my Discord channel at 9:00 AM tomorrow."

Tips & Limitations

Always verify your authentication cookies before starting a high-volume scraping task to avoid session timeouts. The system is designed for Linux-based environments, specifically utilizing screen for long-running MCP services. Be mindful of platform rate limits; while the skill handles scheduling, it is recommended to stagger your publishing tasks to avoid flagging by social media API security filters. If you encounter database errors, use the show-overview.ts script to verify your connection string and table existence.