surface↓extraction↓rss
Extractionscalar · returns table

RSS

Fetch an RSS/Atom feed and return entries as a table

Per-row — runs once for each row.

extractionllmtext

Arguments

nametypedescription
urlVARCHARRSS/Atom feed URL
limit(optional)INTEGERMax entries to return

About

Fetch and parse RSS/Atom feeds into queryable rows. Zero cost, no API key needed. Works with any RSS 2.0, Atom, or RSS 1.0 feed. SQL Usage: SELECT * FROM rss('https://news.ycombinator.com/rss') SELECT title, link FROM rss('https://blog.example.com/feed') WHERE title ABOUT 'AI'

Examples

Fetches at least one entry from the Hacker News RSS feed

SELECT
  COUNT(*) > 0
FROM
  rss ('https://news.ycombinator.com/rss', 3)

Nearby rabbit holes

same domain
scalar

CRAWL_BATCH

Crawl a website and extract structured data from each page (via Firecrawl)

extractionexternal-apiurl
scalar

EXTRACT

Extract specific information from unstructured text (zero-shot NER)

extractionnlispecialist-zootext
scalar

EXTRACT_LLM

LLM-backed extraction (escape hatch for EXTRACTS)

extractionllmllm-escape-hatchtext
scalar

EXTRACT_STRUCTURED

Extract structured fields from text per a user-supplied schema

extractionllmtext
aggregate

MERGE_TIMELINES

Merge multiple timelines into unified chronological sequence

extractionllmjson
scalar

PARSE

Extract information from text using natural-language instructions

extractionllmtext
Climb back to The Looking Glass