Weibo Hot Search Data Collector for Openclaw

A comprehensive multi-channel crawler and visualization engine for monitoring and archiving Weibo trending topics.

noah-1106
v1.0.0
Mar 16, 2026
0
1.5k
0

Install & Download

1. ClawHub CLI

The fastest way to install a skill directly from the registry.

npx clawhub@latest install weibo-trending

2. Manual Installation

Copy the skill folder to one of these locations

Global
~/.openclaw/skills/
Workspace
<project>/skills/

Priority: Workspace > Local > Bundled

3. Prompt Installation

Copy this prompt to OpenClaw to install it automatically.

Help me install weibo-trending 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 Weibo Hot Search Data Collector?

Weibo Hot Search is a specialized technical utility built for Openclaw Skills to facilitate the automated collection of social media trends. It supports high-fidelity data scraping across multiple dimensions, including the general Hot Search list, Social news, Entertainment, and Lifestyle channels. By bridging the gap between raw web data and structured analysis, this skill allows developers and researchers to maintain a persistent record of viral events.

The tool is designed for reliability and depth, capturing not just titles and ranks, but also heat values, commercial tags, and associated post content. By integrating this into Openclaw Skills, users gain a robust pipeline for social listening that transforms volatile trending data into a long-term SQLite database for deep analytical querying and interactive reporting.

Weibo Hot Search Data Collector Use Cases

  • Archiving daily social media trends for historical sentiment analysis and brand monitoring.
  • Generating automated daily reports on entertainment and lifestyle trends for digital marketing teams.
  • Tracking the heat and lifespan of specific viral topics across different Weibo channels.
  • Identifying official government announcements versus commercial promotions using tag recognition.

How Weibo Hot Search Data Collector Works

  1. The user initializes the local SQLite environment to establish a structured storage foundation for the Openclaw Skills ecosystem.
  2. Collection scripts access the Weibo multi-channel interface to fetch top trending items with built-in rate limiting to ensure stability.
  3. The data is processed to identify ranking, heat levels, and specific tags like Hot, New, or Commercial.
  4. Records are deduplicated by URL and date before being persisted into the database tables.
  5. A visualization script processes the database content to generate an interactive, searchable HTML report for local exploration.

Weibo Hot Search Data Collector Setup

To get started with this skill in your Openclaw Skills workspace, follow these installation steps:

# Navigate to the scripts directory and initialize the database
cd scripts
python3 init_db.py

# Perform the initial data collection (defaults to 30 items per channel)
python3 save_to_db.py

# Generate the interactive HTML visualization report
python3 generate_html.py

Note: Ensure you are logged into weibo.com in your browser to maintain session access for detailed data fetching.

Weibo Hot Search Data Collector Data Schema & Taxonomy

The skill organizes collected information into two primary tables within the weibo.db file:

Table Description Key Fields
hot_items Primary trending metadata rank, title, url, heat, tag, channel_id, fetch_date
topic_posts Detailed topic content author, author_type, content, url, is_media

Files are stored in the following structure:

  • /data/weibo.db: The core SQLite database.
  • /data/index.html: The generated interactive dashboard.

Weibo Hot Search Data Collector Advanced Features

  • Multi-channel simultaneous scraping (Hot, Social, Entertainment, Life).
  • Intelligent deduplication using a unique hash of URL, date, and channel ID.
  • Real-time heat value updates for existing database records during re-scans.
  • Integrated HTML dashboard featuring real-time keyword search and date-based filtering.
  • Support for identifying media accounts versus standard user accounts in post details.
  • Command-line query tools for quick statistics and historical trend lookups within Openclaw Skills.

SKILL.md


Loading

Related Openclaw Skills

METADATA

Github Stars: 0
forks: 0

Featured*