skills.rest
ADVISORYDZ
ADVISORYDZCOMMUNITY
Explore all skills by this author →
GitHub

wechat-daily-report

Generate WeChat group chat report PNGs from decrypted SQLite messages.

Updated Aug 23, 2026
Search Tags:#daily report#playwright#png generation#wechat#local database#ai summarization#group chat analytics
One-click install
npx skills add https://github.com/ADVISORYDZ/wechat-daily-report-skill --skill wechat-daily-report
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: wechat-daily-report
Source: https://github.com/ADVISORYDZ/wechat-daily-report-skill/tree/main
Command: npx skills add https://github.com/ADVISORYDZ/wechat-daily-report-skill --skill wechat-daily-report

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires jieba, jinja2, playwright, zstandard, pycryptodome, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

解决手动整理微信群聊天记录、提炼当天热点与金句、并生成可直接分享的日报长图所需的高成本时间与精力问题。

Core Features & Use Cases

  • 本机数据库直读分析：基于已登录微信的解密后本地 SQLite 数据库，自动统计群聊消息与成员活跃情况。
  • AI 智能摘要与结构化内容生成：从统计结果与精简聊天文本中生成可渲染的结构化 JSON（含话题、资源、重要消息、对话金句、问答等）。
  • 手机端长图交付：将 AI 结构化内容与分析统计通过 HTML 模板渲染并截图导出为适配手机的 report.png 长图。
  • 典型场景：用户要求“生成某个微信群今日日报/昨日报/群聊总结长图/聊天日报图片”时，端到端生成可交付产物。

Quick Start

请先运行脚本生成解密快照与统计与精简文本，再让 AI 根据 references/ai_prompt.md 及 stats.json 与 simplified_chat.txt 生成合法的 ai_content.json，最后再执行 generate_report.py 生成 report.png。

Frequently Asked Questions about wechat-daily-report

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

FAQPage Schema
How do I generate a WeChat group chat daily report image automatically?▼

To generate a WeChat group chat daily report image, this Skill analyzes your local decrypted WeChat database, produces AI-structured JSON content with topics and analytics, and renders a mobile-friendly PNG via HTML templating and Playwright screenshots.

What's the best way to summarize WeChat chat history into a shareable long image?▼

Summarizing WeChat chat history into a shareable long image is done by reading the local SQLite database, generating AI summaries of topics and Q&A, and using Playwright to capture a full-page HTML screenshot as report.png.

Do I need a decrypted WeChat database to extract group chat analytics?▼

Yes, a decrypted WeChat database is required to extract group chat analytics. The Skill reads local SQLite messages to compute member statistics and simplified chat text before generating the AI summary.

Can I use Playwright to screenshot HTML reports for mobile sharing?▼

Yes, Playwright is used to screenshot HTML reports for mobile sharing. The Skill renders the AI-structured JSON content into an HTML template and captures a full-page screenshot to produce the final report.png.

What steps are required to produce an AI summary from local WeChat messages?▼

Producing an AI summary from local WeChat messages requires executing setup, decrypt, and analysis steps in sequence. You first generate stats.json and simplified_chat.txt, then the AI creates ai_content.json before the final PNG is rendered.

What are the limitations of using local database analytics for WeChat group summaries?▼

Limitations of using local database analytics for WeChat group summaries include the strict prerequisite of having a decrypted local SQLite database, and the necessity to follow a sequential pipeline of decryption and AI generation before rendering the PNG.

Related Skills

Explore More Data & Analytics Skills→
afumuafumu
44

wetrace

Analyze WeChat chat databases via Wetrace REST API endpoints.

Community
Advanced
team-telnyxteam-telnyx
3

push-notification-tester

Test VoIP push notification delivery for iOS and Android via APNs and FCM.

Official
Intermediate
liumeixinliumeixin
4

html-screenshot-image-gen

Render HTML templates in a browser and capture screenshots as images.

Community
Advanced
h4vzzh4vzz
33

data-visualization

Generate static and interactive charts from structured data using matplotlib, seaborn, and plotly.

Community
Intermediate