--- title: How OpenRouter observes, understands, and acts on 740... description: OpenRouter uses ClickHouse Cloud as its single store behind customer analytics, public rankings, internal AI agents, and routing. Since adopting it in November... canonical: https://daily.dev/posts/how-openrouter-observes-understands-and-acts-on-740-million-llm-requests-a-day-with-clickhouse-clo-2bbfxidfw twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: How OpenRouter observes, understands, and acts on 740 million LLM requests a day with ClickHouse Cloud | daily.dev og:description: OpenRouter uses ClickHouse Cloud as its single store behind customer analytics, public rankings, internal AI agents, and routing. Since adopting it in November... og:url: https://daily.dev/posts/how-openrouter-observes-understands-and-acts-on-740-million-llm-requests-a-day-with-clickhouse-clo-2bbfxidfw og:image: https://api.daily.dev/og/posts/2BbFxIDfW.png og:image:alt: How OpenRouter observes, understands, and acts on 740 million LLM requests a day with ClickHouse Cloud og:image:width: 1200 og:image:height: 630 og:locale: 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. # How OpenRouter observes, understands, and acts on 740 million LLM requests a day with ClickHouse Cloud **[ClickHouse](https://daily.dev/sources/clickhouse)** · 9 min read · 1 upvotes · 0 comments ## Summary OpenRouter uses ClickHouse Cloud as its single store behind customer analytics, public rankings, internal AI agents, and routing. Since adopting it in November 2024, monthly requests grew 33x to 19.7 billion, with 110+ trillion tokens served weekly and a 134-billion-row generation log. The same data powers customer dashboards, public model rankings, internal Slack-based AI agents, and real-time routing decisions across 500+ models. The newest addition, the Jev Router from TypeSafe AI, available since October 2026, lets OpenRouter pick the model itself based on real usage data, not just the provider. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### How much has OpenRouter's request volume grown since it adopted ClickHouse? OpenRouter's monthly requests grew 33 times, from around 600 million in November 2024 to 19.7 billion by August 2026. The platform now serves over 110 trillion tokens per week, and its raw generation log in ClickHouse holds roughly 134 billion rows. _Engineers scaling LLM gateway infrastructure can follow real-world growth benchmarks like this on daily.dev._ ### What is the Jev Router and how does OpenRouter's model selection work? The Jev Router, from TypeSafe AI and available since October 2026, lets OpenRouter pick the model itself instead of just the provider. It classifies a prompt into one of about 30 task types, ranks models by real usage data in ClickHouse for that task, filters by user constraints like cost and capability, then chooses an endpoint with fallbacks ready. _Developers comparing LLM routing approaches can track announcements like this on daily.dev._ ### How does OpenRouter let non-technical staff query its ClickHouse data warehouse? OpenRouter built internal AI agents, accessible mainly through Slack, that read documented dbt models (around 270 of them) and small markdown 'skill' files describing how to query ClickHouse. This lets support staff get answers, like tracing a customer's failing requests end to end, without writing SQL or understanding the underlying data structure. _Teams designing agent-driven data access patterns can follow practical examples like this on daily.dev._ ## Similar posts on daily.dev - [OpenRouter: Discover and use the latest LLMs](https://daily.dev/posts/openrouter-discover-and-use-the-latest-llms-scdb1pvuw) · Product Hunt · 3 upvotes · 0 comments - [OpenRouter more than doubles valuation to $1.3B in a year](https://daily.dev/posts/openrouter-more-than-doubles-valuation-to-1-3b-in-a-year-bvrjwycba) · TechCrunch · 0 upvotes · 0 comments - [State of AI](https://daily.dev/posts/state-of-ai-dlul2m2pu) · Hacker News · 3 upvotes · 0 comments - [Chinese AI models dominate OpenRouter’s US token consumption. It can now guarantee that traffic stays entirely in the US.](https://daily.dev/posts/chinese-ai-models-dominate-openrouter-s-us-token-consumption-it-can-now-guarantee-that-traffic-stay-vaaqti3xq) · The New Stack · 0 upvotes · 0 comments --- Tags: [#observability](https://daily.dev/tags/observability), [#clickhouse](https://daily.dev/tags/clickhouse), [#data-warehouse](https://daily.dev/tags/data-warehouse), [#ai-gateway](https://daily.dev/tags/ai-gateway), [#openrouter](https://daily.dev/tags/openrouter) [View this post on daily.dev](https://daily.dev/posts/how-openrouter-observes-understands-and-acts-on-740-million-llm-requests-a-day-with-clickhouse-clo-2bbfxidfw) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"How OpenRouter observes, understands, and acts on 740 million LLM requests a day with ClickHouse Cloud","url":"https://daily.dev/posts/how-openrouter-observes-understands-and-acts-on-740-million-llm-requests-a-day-with-clickhouse-clo-2bbfxidfw","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/how-openrouter-observes-understands-and-acts-on-740-million-llm-requests-a-day-with-clickhouse-clo-2bbfxidfw"},"datePublished":"2026-11-02T13:01:03.352Z","dateModified":"2026-11-02T13:01:36.947Z","description":"OpenRouter uses ClickHouse Cloud as its single store behind customer analytics, public rankings, internal AI agents, and routing. Since adopting it in November...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/aa0ad806e37c729f2b7d4a1c4bd27d20?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/aa0ad806e37c729f2b7d4a1c4bd27d20?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"ClickHouse","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"ClickHouse","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/clickhouse","url":"https://daily.dev/sources/clickhouse"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/how-openrouter-observes-understands-and-acts-on-740-million-llm-requests-a-day-with-clickhouse-clo-2bbfxidfw","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":1},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"observability,clickhouse,data-warehouse,ai-gateway,openrouter","timeRequired":"PT9M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"ClickHouse","item":"https://daily.dev/sources/clickhouse"},{"@type":"ListItem","position":3,"name":"How OpenRouter observes, understands, and acts on 740 million LLM requests a day with ClickHouse Cloud"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/how-openrouter-observes-understands-and-acts-on-740-million-llm-requests-a-day-with-clickhouse-clo-2bbfxidfw#faq","mainEntity":[{"@type":"Question","name":"How much has OpenRouter's request volume grown since it adopted ClickHouse?","acceptedAnswer":{"@type":"Answer","text":"OpenRouter's monthly requests grew 33 times, from around 600 million in November 2024 to 19.7 billion by August 2026. The platform now serves over 110 trillion tokens per week, and its raw generation log in ClickHouse holds roughly 134 billion rows. Engineers scaling LLM gateway infrastructure can follow real-world growth benchmarks like this on daily.dev."}},{"@type":"Question","name":"What is the Jev Router and how does OpenRouter's model selection work?","acceptedAnswer":{"@type":"Answer","text":"The Jev Router, from TypeSafe AI and available since October 2026, lets OpenRouter pick the model itself instead of just the provider. It classifies a prompt into one of about 30 task types, ranks models by real usage data in ClickHouse for that task, filters by user constraints like cost and capability, then chooses an endpoint with fallbacks ready. Developers comparing LLM routing approaches can track announcements like this on daily.dev."}},{"@type":"Question","name":"How does OpenRouter let non-technical staff query its ClickHouse data warehouse?","acceptedAnswer":{"@type":"Answer","text":"OpenRouter built internal AI agents, accessible mainly through Slack, that read documented dbt models (around 270 of them) and small markdown 'skill' files describing how to query ClickHouse. This lets support staff get answers, like tracing a customer's failing requests end to end, without writing SQL or understanding the underlying data structure. Teams designing agent-driven data access patterns can follow practical examples like this on daily.dev."}}]} ```