adennng/wechat-query-skill

wechat-query-skill is a WeChat public account subscription, query, and push notification skill for OpenClaw.
It has a built-in wechat-download-api service and operates locally, relying on the WeChat official account backend login mode to pull article data and cache articles in SQLite for subsequent LLM queries, organization, analysis, and pushes.

The focus of this project is not just “capturing official account articles,” but integrating deployment, login, subscription, warehousing, querying, pushing, inspection, and re-login into a reusable automated process.

Prerequisites for use

• Have a WeChat public account, either subscription or service accounts
• Docker is installed in the local environment
• When the user first uses or login expires, they need to scan the code to log in using the Official Account Administrator WeChat

Applicable Scenarios

1. Deploy the service for the first time and complete the first login
2. The user voluntarily requests to log in again, or the patrol finds login invalid
3. Add, view, and unsubscribe from official accounts
4. Check the cached articles of the subscribed official account
5. Users directly send the official account article link and need to read the full text or analyze the content
6. Summarize and push new articles from the last 24 hours daily at 18:00
7. Daily 09:00 inspection service status and login status

Overall Logic Diagram

This diagram corresponds to two main links:

• Subscription and inbound link: Search for official account -> Add subscription -> Immediately complete a polling -> Backend RSS Poller automatically pulls and writes to SQLite every hour
• Query link: prioritize querying cached databases; If the database is empty, call the interface as needed to fetch it

The two most critical tables at the moment:

• subscriptions
• articles

Timed Task Chart

These two tasks have different responsibilities:

• Inspection task: Only checks service and login status; messages must be sent regardless of the outcome
• Push task: Organize articles from the last 24 hours based on the cache, including the current login status

Core Competencies

1. Service deployment and unified pre-inspection

• Built-in wechat-download-api service source code
• Unified launch via Docker Compose
• All major scenarios undergo a unified pre-check
• Pre-check default check:
• GET /api/health
• GET /api/admin/status

2. Login and relog

• Supports first-time login
• Supports active re-login
• Login validity period is about 4 days based on experience points
• Automatically saves credentials after successful login
• First-time login and re-login unified server-hosted QR code links:
• POST /api/login/relogin/start
• GET /api/login/relogin/{request_id}/qrcode
• GET /api/login/relogin/{request_id}/status

3. Subscribe to official accounts and add articles to the database

• Search for official accounts
• Add subscriptions
• View the subscription list
• Unsubscribe
• After a successful subscription, a manual polling can be triggered immediately