skills.rest
xianmingyao
xianmingyaoCOMMUNITY
Explore all skills by this author →
GitHub

wechat

Extract contacts, sessions, messages, and favorites from local WeChat SQLite databases.

1|1|Updated Mar 18, 2026
Search Tags:#sqlite#sessions#wechat#messages#read-only#contacts#local-data
One-click install
npx skills add https://github.com/xianmingyao/openclaw-CaySon --skill wechat-xianmingyao
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: wechat
Source: https://github.com/xianmingyao/openclaw-CaySon/tree/main/skills/wechat
Command: npx skills add https://github.com/xianmingyao/openclaw-CaySon --skill wechat-xianmingyao

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

Users often need to review their own locally stored WeChat data without relying on cloud backups or external tools, but they face scattered SQLite databases and difficult access patterns.

Core Features & Use Cases

  • Read-only access to Contact.sqlite, Session.sqlite, Chat.sqlite, and Favorite.sqlite to inspect contacts, conversations, messages, and favorites.
  • List contacts, view recent sessions, search message content, and summarize data for reporting or auditing.
  • Use-case: a user troubleshooting data integrity on their desktop WeChat installation.

Quick Start

Run the wechat script to list contacts, sessions, and messages from your local WeChat databases.

Frequently Asked Questions about wechat

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I read local WeChat data from SQLite databases on my desktop?▼

You can read local WeChat data by extracting records from SQLite databases like Contact.sqlite, Session.sqlite, Chat.sqlite, and Favorite.sqlite. The Skill establishes safe, read-only SQLite connections to inspect contacts, sessions, messages, and favorites directly from your desktop installation.

Can I search WeChat message content locally without cloud backups?▼

Yes, searching WeChat message content locally is possible by querying the Chat.sqlite database. This allows you to review conversations and search specific message text securely without relying on cloud backups or external extraction tools.

Does this method for extracting WeChat data work on both macOS and Windows?▼

Extracting WeChat data works across both macOS and Windows platforms. You can customize the database file locations using the --path configuration option to accurately target your desktop WeChat installation directories.

Is it safe to query local WeChat SQLite databases without modifying my data?▼

Querying local WeChat SQLite databases is completely safe because the process operates strictly in read-only mode. It establishes safe, read-only SQLite connections to ensure your original contacts, sessions, messages, and favorites remain unmodified.

What is the best way to audit and list my WeChat contacts and recent sessions?▼

The best way to audit and list WeChat contacts and recent sessions is by reading the Contact.sqlite and Session.sqlite files. This approach summarizes your local data securely for reporting, auditing, or troubleshooting data integrity.

Related Skills

Explore More Data & Analytics Skills→
yankeeinlondonyankeeinlondon
3

dirs

Resolve platform-specific config, data, and cache directories for Rust applications.

Community
Intermediate
sungaoxiang-backendsungaoxiang-backend

evidence-wechat-chat-handler

Extract WeChat chat screenshots into grouped card_features by contact remark.

Community
Advanced
ImGoodBaiImGoodBai
195

goodqunbot

Retrieve and send WeChat messages via the PC client using wxauto_lib.

Community
Intermediate
droxeydroxey
1

mobile-forensics

Carve SQLite databases and parse plist artifacts from mobile backups.

Community
Advanced