skills.rest
kzinmr
kzinmrCOMMUNITY
Explore all skills by this author →
GitHub

blogwatcher-db

Retrieves RSS scan results from the sliegerlab-blogwatcher-cli database using SQL templates and Python integration.

7|Updated Mar 26, 2026
Search Tags:#data retrieval#database query#sqlite3#blogwatcher-cli#rss scanning
One-click install
npx skills add https://github.com/kzinmr/ai-topics --skill blogwatcher-db
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: blogwatcher-db
Source: https://github.com/kzinmr/ai-topics/tree/main/config/hermes/skills/_custom/blogwatcher-db
Command: npx skills add https://github.com/kzinmr/ai-topics --skill blogwatcher-db

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines querying the blogwatcher-cli SQLite database for RSS scan results, eliminating errors associated with guesswork in column names and providing templates for repeatable tasks.

Core Features & Use Cases

  • Pre-Verified Queries: Access RSS scan results using predefined SQL templates to avoid errors.
  • Database Location Flexibility: Identifies the location of the database with fallback mechanisms.
  • Schema Documentation: Includes a verified schema and table information.
  • Query Templates: Offers a set of SQL templates for common tasks such as daily scan, unread articles, and article search.
  • Python Usage Pattern: Provides a Python usage pattern for executing SQL queries reliably.
  • Execution Tips: Includes important notes on execution in cron mode and a simple count command.

Quick Start

Use the query_daily_scan('YYYY-MM-DD') function to get all articles discovered on a specific date, grouped by blog.

Frequently Asked Questions about blogwatcher-db

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

FAQPage Schema
How do I query RSS scan results from a blogwatcher-cli SQLite database?▼

Query RSS scan results from a blogwatcher-cli SQLite database using pre-verified SQL templates and a Python integration pattern to retrieve article discovery logs and manage read status reliably.

How do I retrieve unread articles discovered on a specific date using sqlite3?▼

Retrieve unread articles discovered on a specific date by calling the query_daily_scan('YYYY-MM-DD') function, which groups all discovered RSS entries by blog using pre-verified SQL templates.

How can I avoid column name errors when running database queries for RSS scanning?▼

Avoid column name errors during RSS scanning database queries by using pre-verified SQL templates and included schema documentation, eliminating guesswork and ensuring accurate data retrieval.

Does blogwatcher-cli database querying require manual database location configuration?▼

No, manual database location configuration is not strictly required because the querying mechanism identifies the SQLite database location automatically with built-in fallback mechanisms.

What are the limitations of using SQL templates for blogwatcher-cli data retrieval?▼

Limitations include being restricted to predefined templates for common tasks like daily scans and unread article searches, and requiring attention to specific execution notes when running in cron mode.

Related Skills

Explore More Data & Analytics Skills→
lxt070409lxt070409
1

blogwatcher

Monitor blogs and RSS/Atom feeds for updates using blogwatcher-cli.

Community
Intermediate
kenbanks-pengkenbanks-peng
1

job-search

Scan job boards, score matches, and store results in SQLite.

Community
Advanced
louloulinlouloulin
19

data-analyst

Analyze raw datasets from CSV, Excel, and SQL sources with Python.

Community
Intermediate
AIDotNetAIDotNet
84

sql-executor

Execute SQL queries against SQLite, PostgreSQL, and MySQL databases with formatted output and CSV/JSON export.

Official
Intermediate