Skills
.Work. You
Rest

blogwatcher-db

Community

Query blogwatcher-cli SQLite database for RSS scan results with pre-verified templates.

Data & Analytics#data retrieval#database query#sqlite3#blogwatcher-cli#rss scanning
Authorkzinmr
Version1.0.0
Installs0

System Documentation

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.

Dependency Matrix

Required Modules

None required

Components

scriptsreferences

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: blogwatcher-db
Download link: https://github.com/kzinmr/ai-topics/archive/main.zip#blogwatcher-db

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 620,000+ vetted skills library on demand.