InsightsTrack Lets Users Query Web Analytics with AI
NishikantaRay developed InsightsTrack, a self-hosted web analytics platform, and integrated an AI analyst called Pulse. The platform offers an open-source alternative to Google Analytics, prioritizing user privacy by avoiding cookies and data selling. Pulse allows users to ask questions about their website traffic in plain English and receives responses with charts, tables, and data exports.
Ray extended Pulse's functionality by exposing its analytics tools via the Model Context Protocol (MCP). This enables users to query InsightsTrack directly from AI clients like Claude Desktop, effectively making web analytics data accessible through conversational AI. The system uses a dual-database design with PostgreSQL and DuckDB for speed and efficiency, answering queries in under 100 milliseconds.
The project prioritizes data security through encrypted model keys and scoped connect tokens. Ray hopes to make web analytics as simple as texting and available across multiple AI tools.
Surfaced by the Solutions lens — one of the vital signs ovr.news reads.
How we evaluated this
AI summary
read the original for the full story — Read on dev.to . How we work →