newsboat

name	newsboat
description	OpenClaw AI agent skill for reading and managing RSS/Atom feeds via Newsboat.
homepage	https://github.com/ianwu-ca-778/openclaw-skills-newsboat
license	MIT
metadata	{"openclaw":{"emoji":"📰","requires":{"bins":["newsboat","sqlite3","pandoc"]}}}

Newsboat

This guide explains how to read and manage RSS/Atom feeds using Newsboat, a command-line RSS/Atom feed reader.

Installation

Debian/Ubuntu

sudo apt update
sudo apt install newsboat sqlite3 pandoc

macOS

brew install newsboat sqlite3 pandoc

Others

Search online for “install newsboat on [your OS]” for specific instructions.

Files

• configuration: ~/.newsboat/config
• feed URLs: ~/.newsboat/urls
• cache: ~/.newsboat/cache.db

If Newsboat is not in your PATH, use your OS search to locate its files.

List Feeds

cat ~/.newsboat/urls

Example output

$ cat ~/.newsboat/urls
https://604now.com/rss/

Add a Feed

echo "https://example.com/feed.xml" >> ~/.newsboat/urls

Remove a Feed

sed -i.bak '/https:\/\/example.com\/feed.xml/d' ~/.newsboat/urls

This removes the feed URL and creates a backup urls.bak.

Refresh All Feeds

newsboat -x reload

Read an article

Retrieve articles from the Newsboat cache using sqlite3 and convert HTML to plain text with pandoc.

The rss_item table schema:

CREATE TABLE rss_item (
	id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL
	,guid VARCHAR(64) NOT NULL
	,title VARCHAR(1024) NOT NULL
	,author VARCHAR(1024) NOT NULL
	,url VARCHAR(1024) NOT NULL
	,feedurl VARCHAR(1024) NOT NULL
	,pubDate INTEGER NOT NULL
	,content VARCHAR(65535) NOT NULL
	,unread INTEGER (1) NOT NULL
	,enclosure_url VARCHAR(1024)
	,enclosure_type VARCHAR(1024)
	,enqueued INTEGER (1) NOT NULL DEFAULT 0
	,flags VARCHAR(52)
	,deleted INTEGER (1) NOT NULL DEFAULT 0
	,base VARCHAR(128) NOT NULL DEFAULT ""
	,content_mime_type VARCHAR(255) NOT NULL DEFAULT ""
	,enclosure_description VARCHAR(1024) NOT NULL  ""
	,enclosure_description_mime_type ()   ""
);

Read the latest article

sqlite3 -noheader ~/.newsboat/cache.db \
"SELECT 'title = ' || title || '\nurl   = ' || url || '\ndate  = ' || datetime(pubDate, 'unixepoch', 'localtime') || '\n\n' || content 
 FROM rss_item ORDER BY pubDate DESC LIMIT 1;" | \
pandoc -f html-native_divs-native_spans -t plain --strip-comments

Example output

$ sqlite3 -noheader ~/.newsboat/cache.db \
"SELECT 'title = ' || title || '\nurl   = ' || url || '\ndate  = ' || datetime(pubDate, 'unixepoch', 'localtime') || '\n\n' || content 
 FROM rss_item ORDER BY pubDate DESC LIMIT 1;" | \
pandoc -f html-native_divs-native_spans -t plain --strip-comments

title = 90+ Tri-Cities Restaurants Are Dropping Exclusive Deals And
Menus For A Full Month\nurl =
https://604now.com/taste-of-the-tri-cities-february-march-2026/\ndate =
2026-02-13 16:36:10\n\n

Taste of the Tri-Cities returns for another delicious year, treating
everyone across Metro Vancouver to the amazing culinary delights that
the Coquitlam, Port Coquitlam, and Port Moody has to offer. For a whole
month, from February 15 to March 15, you can take part in one of the
tastiest annual festivals in the Lower Mainland.