AI-powered Catholic tech content aggregator with knowledge graph

[JohnRDOrazio]

Summary

Proposal for an AI-powered system that automatically discovers, classifies, and indexes content about technology and the Catholic Church from Catholic media sources.

What it does

• Daily aggregation — A Python worker scours RSS feeds, Catholic news sites, and Vatican documents for tech-related content
• AI classification — Each article is scored for relevance, summarized, tagged, and has named entities extracted (using Claude or OpenAI)
• Full-text search — PostgreSQL tsvector indexes enable fast search across all stored articles
• Knowledge graph — Apache AGE (PostgreSQL extension) builds a property graph linking articles, entities, tags, and sources — queryable with openCypher
• Web interface — A new /research section on the CDCF website with faceted search and an interactive D3.js knowledge graph visualization

Architecture

• PostgreSQL + Apache AGE — single database for relational data, FTS, and graph queries
• Python worker — modular design with swappable AI providers (Claude/OpenAI) and pluggable fetchers (RSS, web scraper, Vatican.va)
• Next.js /research route — queries PostgreSQL directly (independent of WordPress CMS)
• Docker Compose — opt-in via --profile aggregator

Implementation plan

See docs/content-aggregator.md for the full plan including:

• Database schema (tables + graph model)
• Python worker architecture
• Next.js frontend design
• 5-phase implementation timeline
• Complete file list

🤖 Generated with Claude Code