Feishu Table Data Analytics
Paste the following prompt into your AI chat to install this skill:
Please install @user_af28adda/feishu-table-analytics by following https://skillhub.cn/install/skillhub.md.
About this skill
Problem
When business data already lives in Feishu Base or Sheets, manual copying, cleaning, ad hoc SQL, and report drafting can become fragmented. This skill turns table export, data exploration, and report generation into a local workflow for csv or excel files.
How It Works
- Export:
scripts/main.pycalls the Feishu CLI to exportwiki/base/sheetsURLs, including multi-table or multi-worksheet output, and converts rich-text cells to plain text. - Analysis:
scripts/duckdb_analyzer.pyuses DuckDB fordescribeorquerymodes. It can inspect schema, distributions, and data quality, generate SQL, retry failed queries, correct syntax, column names, and quoting, and validate logic with--sample_fraction. - Reporting: AI produces a Markdown report,
scripts/append_data_to_report.pyappends result rows, andscripts/generate_report.pycan build a self-contained HTML report with KPI cards, bar/line/pie/radar charts, and insights.
Boundaries
This is an offline export-query-report tool, not a real-time dashboard. It depends on pandas, openpyxl, duckdb, numpy, and the Feishu CLI; use the provided scripts for data access, SQL execution, and report updates rather than pasting large result sets into chat.
Use Cases
- Export a Feishu Base table to CSV and query 30-day order trends with SQL.
- Inspect sheet field distributions, validate SQL aggregation with sampling, then generate a Markdown report.
- Export multiple worksheets to Excel and produce an HTML report with KPI cards and charts.
- Append analyzed results to the Markdown report, preserving SQL, conclusions, and up to 100 detail rows.
Best For
- Operations analysts who turn Feishu tables into local queryable files for review.
- BI engineers who validate SQL aggregation and document conclusions in reports.
- Product project managers who export project ledgers and add KPI charts.
- Data engineers who analyze CSV/Excel files with DuckDB.
Related Skills
Query Douyin creator videos, image/text posts, and short-drama series by sec_user_id or profile URL with paginated list retrieval.
Uses CDP-controlled browser screenshots of Douyin video pages and multimodal AI to extract teaching points into a Markdown report.
Query Douyin hot searches and works with SocialDataX API or MCP tools, supporting keyword, sorting, time range, duration, content type, and pagination.
Fetch the GitHub Trending leaderboard and generate fact-grounded project analysis, trend hypotheses, and directional insights.