A technical utility for querying and analyzing local WeChat SQLite databases to retrieve contacts, messages, and favorited content.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install wechate
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install wechate using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is WeChat Local Data Reader?
The WeChat data reader is a specialized tool designed for the Openclaw Skills ecosystem that enables secure, read-only access to local WeChat databases. It targets the SQLite files generated by the desktop version of WeChat on macOS and Windows, allowing users to programmatically interact with their own communication history. This skill is particularly valuable for developers who need to bridge the gap between their messaging data and their local AI agents.
By leveraging Openclaw Skills, users can perform complex searches across thousands of messages, export contact lists, or generate statistics about their usage patterns. The tool prioritizes privacy by operating entirely offline and requiring explicit system permissions, ensuring that your sensitive personal data stays under your control while still being accessible for advanced technical workflows.
WeChat Local Data Reader Use Cases
- Searching through extensive local chat logs for specific project keywords or historical context.
- Extracting contact lists and group chat metadata for organization or backup purposes.
- Generating data-driven insights and usage statistics from your personal messaging habits.
- Retrieving favorited links, notes, and media for integration into personal knowledge management systems.
- Providing local context to AI agents within the Openclaw Skills environment for better personalized responses.
How WeChat Local Data Reader Works
- The skill locates the local WeChat data storage path, defaults to the macOS container directory or a user-defined Windows path.
- It initializes a connection to specific SQLite databases (Contact, Session, Chat, Favorite) using the mode=ro (read-only) flag to prevent data corruption.
- The user or agent issues a command such as search, contacts, or stats via the Openclaw Skills interface.
- The skill executes optimized SQL queries to fetch the requested records while handling Unix timestamp conversion to readable formats.
- Results are formatted and returned to the terminal or calling agent for further processing or display.
WeChat Local Data Reader Setup
Before using this skill, ensure that OpenClawCLI is installed. On macOS, you must grant your terminal Full Disk Access in System Settings > Privacy & Security.
# Verify access to the WeChat data directory
ls -la ~/Library/Containers/com.tencent.xinWeChat/
# List available databases to confirm setup
python3 scripts/wechat.py list
# Run the stats command to verify data connectivity
python3 scripts/wechat.py stats
For Windows users, specify your custom data path:
python3 scripts/wechat.py --path "C:/Users/YourName/Documents/WeChat Files/" contacts
WeChat Local Data Reader Data Schema & Taxonomy
The skill interacts with the following primary database files found in the WeChat data directory:
| Database File | Data Content | Metadata Tracked |
|---|---|---|
| Contact.sqlite | User profiles | Nicknames, WeChat IDs, Aliases |
| Session.sqlite | Active chats | Last message time, Unread status |
| Chat.sqlite | Message logs | Content body, Timestamps, Sender ID |
| Favorite.sqlite | Saved content | Links, formatted notes, clips |
| Brand.sqlite | Official accounts | Subscription details and IDs |
WeChat Local Data Reader Advanced Features
- Multi-platform support for both macOS and Windows directory structures within the Openclaw Skills framework.
- Advanced search filters including result limits and keyword matching across large chat databases.
- Read-only safety mechanism that guarantees the integrity of original WeChat files by blocking all write operations.
- Integrated statistics engine that provides a high-level overview of message volume and contact density.
- Extensible CLI architecture allowing for custom SQL query integration for power users of Openclaw Skills.
SKILL.md
Loading
Related Openclaw Skills
Web Search Skill
A powerful DuckDuckGo-powered search tool for Openclaw Skills that enables AI agents to retrieve real-time web, news, image, and video data.
Web Search
A versatile search utility that enables AI agents to retrieve real-time web data, news articles, images, and videos via DuckDuckGo.
Google Veo 3.x Video Generation
Generate high-quality AI videos and multi-segment clips using Google Veo 3.x and the Gemini API through a streamlined CLI workflow.
Transcribee
A high-performance transcription skill for converting YouTube videos and local media into speaker-labeled text files.
WeChat Local Data Reader
A read-only utility to access and search your local WeChat SQLite database records for contacts, sessions, and messages.
WeChat Local Data Reader
A read-only SQLite utility to access and search local WeChat data including contacts, sessions, and messages.
Featured*
