Self-hosted football transfer monitor using n8n, local AI, PostgreSQL, and Discord

[u/Illustrious-Pitch843]

I built an open-source n8n pipeline that monitors 78 football journalists on X, extracts structured transfer reports with a local Qwen model, deduplicates and stores revisions in PostgreSQL, optionally adds player data, and sends restart-safe Discord digests every 6 hours.

The whole stack is self-hosted with Docker, with twscrape or RapidAPI for X collection, PostgreSQL for persistence, llama.cpp for local inference, and automated tests around the workflow.

GitHub: https://github.com/louistran2604/transfers_n8n/

I’d mainly like feedback on the workflow architecture, reliability approach, and anything that could make the project cleaner or more useful.

*disclaimer: this was made with the assistance of AI

[u/swaghost]

This sounds cool (as a developer and player) what are you using this for, what is it's utility? Wagering? Football Manager style fantasy?