--- title: "I dumped 650K DNS records into Gemma, and it found patterns my dashboard completely missed" url: https://daily.dev/posts/i-dumped-650k-dns-records-into-gemma-and-it-found-patterns-my-dashboard-completely-missed-k13yhwxut source_url: https://www.xda-developers.com/i-dumped-650k-dns-records-into-gemma-and-it-found-patterns-my-dashboard-completely-missed type: article source: "XDA Developers" published: 2026-07-04T19:35:11.576Z updated: 2026-07-04T19:35:38.667Z tags: ["monitoring", "dns", "ollama", "local-ai", "gemma"] reading_time: 8 upvotes: 0 comments: 0 language: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # I dumped 650K DNS records into Gemma, and it found patterns my dashboard completely missed **[XDA Developers](https://daily.dev/sources/xda-developers)** · 8 min read · 0 upvotes · 0 comments ## Summary A home network enthusiast fed 650K+ DNS logs from Pi-hole and AdGuard Home into Gemma 4 (running locally via Ollama) to see what patterns a local LLM could surface. Because the raw CSV was far too large for any model's context window (~12M tokens vs 128K limit), the author pre-aggregated the data client-side into a structured JSON summary using PapaParse, then forwarded it to Gemma via a lightweight Python proxy and a React/FastAPI dashboard. Without being given any device names or IP labels, Gemma correctly grouped Amazon domains and attributed them to a Fire TV stick, identified a 4–7 AM traffic spike tied to Nextcloud syncs and background jobs, and flagged idle devices continuously phoning home — none of which the standard Pi-hole or AdGuard dashboards had surfaced. The key insight: the intelligence came as much from thoughtful data preparation as from the model itself. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [Pi-hole showed me 65,000 DNS queries in hours, and I didn't like where they were going](https://daily.dev/posts/pi-hole-showed-me-65-000-dns-queries-in-hours-and-i-didn-t-like-where-they-were-going-t1bkwwsjs) · XDA Developers · 0 upvotes · 0 comments - [I ran a Pi-hole for a week and was genuinely disturbed by how much my TV phones home](https://daily.dev/posts/i-ran-a-pi-hole-for-a-week-and-was-genuinely-disturbed-by-how-much-my-tv-phones-home-lzzzwdq6o) · XDA Developers · 0 upvotes · 0 comments - [I gave a local LLM access to my Docker containers, and it replaced my monitoring scripts](https://daily.dev/posts/i-gave-a-local-llm-access-to-my-docker-containers-and-it-replaced-my-monitoring-scripts-f69erso4s) · XDA Developers · 0 upvotes · 0 comments - [I have 21 Docker containers and zero documentation — my local LLM fixed that in an hour](https://daily.dev/posts/i-have-21-docker-containers-and-zero-documentation-my-local-llm-fixed-that-in-an-hour-m5marbkaf) · XDA Developers · 1 upvotes · 1 comments - [Some of my smart devices were sneaking around my Pi-hole, and blocking them was easier than I thought](https://daily.dev/posts/some-of-my-smart-devices-were-sneaking-around-my-pi-hole-and-blocking-them-was-easier-than-i-though-uekifdok0) · XDA Developers · 0 upvotes · 0 comments --- Tags: [#monitoring](https://daily.dev/tags/monitoring), [#dns](https://daily.dev/tags/dns), [#ollama](https://daily.dev/tags/ollama), [#local-ai](https://daily.dev/tags/local-ai), [#gemma](https://daily.dev/tags/gemma) [View this post on daily.dev](https://daily.dev/posts/i-dumped-650k-dns-records-into-gemma-and-it-found-patterns-my-dashboard-completely-missed-k13yhwxut)