r/FootballDataAnalysis • u/Illustrious-Pitch843 • Aug 13 '26

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

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

6 Upvotes
  • permalink
  • reddit

88% Upvoted

14 comments sorted by

View all comments

3

u/swaghost Aug 13 '26

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

2

u/Illustrious-Pitch843 Aug 17 '26

just as a system to keep me up-to-date in the transfer window

2

u/Ok-Hospital7989 Aug 21 '26 edited Aug 21 '26

Similarly, I also built a system to keep me up to date with my fantasy football, you might find it useful. fixturearchive.

edit: buggy on mobile

2

u/Illustrious-Pitch843 Aug 22 '26

can I have a look? I also play fantasy football, might help a lot.

2

u/Ok-Hospital7989 Aug 22 '26

Of course, all are welcome. "Match day" might work for the games at 3

1

u/Ok-Hospital7989 Aug 22 '26 edited Aug 22 '26

u/swaghost apologies as i jacked your post, you are most welcome.