Does it support multilingual queries?

Yes, the skill is designed to respond in the same language as your query, supporting both English and Chinese (数据分析).

Can I use this for weekly reporting?

Yes, it includes specialized templates to generate visual HTML or structured JSON reports for weekly performance reviews and stakeholder updates.

How do I view the analyzed videos?

The skill automatically formats query results with clickable links to Civitai assets and posts for immediate viewing.

How does the skill generate SQL queries?

It uses a provided database schema and query templates to translate your natural language requests into optimized PostgreSQL code for the civitai_records database.

What specific metrics can I analyze?

You can track positive engagement (likes/hearts/laughs), total engagement, quality scores, motion intensity, and tag-based performance trends.

Civitai Video Performance Analyst

Name: Civitai Video Performance Analyst
Author: feed-mob

byfeed-mob

•

Data Science & ML

Analyzes Civitai video engagement and content metrics through natural language SQL queries and automated reporting.

The Civitai Analyst skill empowers users to extract actionable insights from the Civitai platform by translating natural language questions into complex PostgreSQL queries. It provides deep-dive analysis into engagement metrics like likes and hearts, evaluates content strategies through tag and quality score analysis, and generates comprehensive weekly performance reports. Whether you are comparing video performance or seeking data-backed content recommendations, this skill bridges the gap between raw database records and strategic growth by providing clear, formatted results with direct navigation links.

Key Features

01Tag, theme, and quality score pattern recognition

02In-depth engagement metric analysis including likes, hearts, and comments

03Natural language to PostgreSQL query generation

04Automated weekly performance report generation in JSON or HTML

05Comparative video performance and trend analysis

061 GitHub stars

Use Cases

01Identifying high-performing tags and themes to optimize future content strategy

02Comparing specific video assets to understand why certain content outperforms others

03Generating automated weekly summaries of account growth and video engagement

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add feed-mob/agent-skills civitai-analyst

For use in Claude.ai and ChatGPT

Download Skill