habit-monthly-report

Generate monthly habit reports and Telegram posts from SQL query results.

Updated Jan 13, 2024
One-click install
npx skills add https://github.com/iRootPro/dotfiles --skill habit-monthly-report
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: habit-monthly-report
Source: https://github.com/iRootPro/dotfiles/tree/main/pi/agent/skills/habit-monthly-report
Command: npx skills add https://github.com/iRootPro/dotfiles --skill habit-monthly-report

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill addresses the need for a monthly summary of user habits, providing both a detailed report and a Telegram post format for social media sharing.

Core Features & Use Cases

  • Monthly Habit Report: Offers a comprehensive overview of a user's habits for a specific month, including statistics and summaries.
  • Telegram Post Format: Generates a Telegram-style post that can be shared with others, showcasing habit progress.
  • Use Case: Ideal for individuals tracking their habits and looking to share their progress with a community or personal network.

Quick Start

Generate a monthly habit report for March by saying: "Отчет по привычкам за март"

Frequently Asked Questions about habit-monthly-report

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

FAQPage Schema
How do I generate a monthly habit report from a database?

Generate a monthly habit report by querying your production database with SQL to retrieve user data and habit statistics, then formatting the results into markdown tables. The Skill requires PostgreSQL to execute the database queries and structure the output.

Can I format habit tracking data into a Telegram post?

Format habit tracking data into a Telegram post by querying habit statistics from your database and converting the results into social media content. The Skill supports two output formats: detailed markdown data tables and Telegram-style posts for sharing progress.

Do I need PostgreSQL to query habit statistics for a monthly summary?

PostgreSQL is required to query habit statistics for a monthly summary. The Skill depends on the psql command-line tool to retrieve user data and habit statistics from your production database before formatting the results into reports.

What's the best way to summarize monthly habits for social media sharing?

Summarize monthly habits for social media sharing by querying habit statistics from a database and formatting the results into a Telegram post. This approach provides a comprehensive overview of habit progress suitable for sharing with a community or personal network.

How do I retrieve user habit statistics and output them as a markdown table?

Retrieve user habit statistics and output them as a markdown table by executing SQL queries against your production database. The Skill fetches habit data for a specific month and formats the statistics into a structured data table report.

Are there limitations when using database queries for habit tracking summaries?

Limitations of using database queries for habit tracking summaries include the requirement for a production database with properly structured habit data. The Skill cannot generate reports without SQL queries to retrieve the necessary user data and habit statistics.