#59 · Primary category: Business Intelligence & Analytics

trench

analytics clickhouse clickhouse-database clickhouse-server dashboard dashboards event-replay kafka kafka-engine llm matomo matomo-analytics nodejs open-source plausible-analytics posthog product-analytics rag tracking tracking-events

Trench — Open-Source Analytics Infrastructure. A single production-ready Docker image built on ClickHouse, Kafka, and Node.js for tracking events. Easily build product analytics dashboards, LLM RAGs, observability platforms, or any other analytics product.

Project last updated:04/06/26

GitHub Stars

1.7K

Forks

64

Contributors

10

License

MIT

Why we included this project

Trench is a self-hosted event tracking pipeline that pairs Kafka for ingestion with ClickHouse for storage, so a single node can take in thousands of events per second and still answer analytics queries in real time. Instead of committing to a SaaS analytics vendor, you deploy one production Docker image and start sending it the Track, Group, and Identify events the Segment API uses. It runs without cookies and is GDPR and PECR compliant, with controls that let users access, rectify, or delete their data, which matters when privacy rules are strict. That makes it a practical base for building product dashboards, observability views, or feeding usage data into an LLM retrieval pipeline.

Articles for this project

No articles for this project yet.

To suggest a topic or contribute an article, contact us.

Related projects in this category