Sherlock Calls
for Aircall + ClickHouse
Aircall logs your sales team's calls, tags, and recordings in real time. ClickHouse stores and queries high-volume event and operational data at scale. When you need to investigate across both, the evidence is split between two dashboards neither of which knows the other exists. Sherlock Calls bridges them — no code, no exports, no manual joins. Ask once from Slack and get a sourced answer in under 5 seconds.
TL;DR — What beta users get access to
- 1
Sherlock Calls connects to Aircall, ClickHouse simultaneously — read-only, no code changes, no webhooks — and lets you query both with a single Slack message.
- 2
Ask questions that neither Aircall nor ClickHouse can answer alone. Aircall shows call counts — not which calls are actually moving deals forward. ClickHouse holds the raw source of truth — but querying it for business questions requires SQL access and data engineering resources. Sherlock deduces the complete picture from both.
- 3
No dashboard switching, no manual joins, no fog of uncertainty — ask in Slack and receive a sourced answer with evidence from every connected provider in under 5 seconds. The game is afoot.
<5s
Answer to any telephony + database query
2
Connected platforms, 1 Slack question
0
Code changes or webhooks required
The Investigation Gap
What's invisible when you use Aircall + ClickHouse without Sherlock
Each platform shows you its own data. But the questions that matter most live in the gaps between them.
ClickHouse call events and Aircall record updates are correlated manually, if at all
When a customer calls through ClickHouse, it often triggers a downstream Aircall record update — an order change, a support ticket, an account modification. The connection between the call and the data change is invisible without a deliberate join.
ClickHouse call failure patterns are diagnosed without Aircall application context
A ClickHouse call failure may have been caused by an upstream Aircall data issue — a missing record, an edge case in application state. But ClickHouse logs the telephony error without the Aircall context that would reveal the root cause.
Aircall application state changes that trigger inbound ClickHouse calls go untracked
Specific Aircall events — a status change, a billing update, a record modification — reliably produce inbound ClickHouse calls. Identifying those high-volume trigger patterns requires correlating both datasets, but neither platform makes that connection automatically.
Cross-Provider Questions
What teams ask Sherlock about Aircall + ClickHouse
Questions that would take hours to answer manually — answered in under 5 seconds from Slack.
- SC“Which Aircall call events are associated with specific ClickHouse record updates in the last 7 days?”
- SC“Show me ClickHouse tables whose row counts change most after high Aircall inbound call volume”
- SC“Find Aircall callers whose corresponding ClickHouse account records were last updated more than 30 days ago”
- SC“Which ClickHouse application states most frequently precede inbound Aircall calls?”
- SC“What's the ClickHouse record activity pattern for customers who've called Aircall more than 3 times this month?”
Beta Setup
Connect Aircall + ClickHouse to Sherlock in 2 minutes
No code, no webhooks, no new dashboards. Beta users get direct onboarding support.
- 1
Connect Aircall
Add your Aircall credentials to Sherlock Calls. Read-only access — no code changes, no webhooks, no Aircall configuration required.
- 2
Connect ClickHouse
Add your ClickHouse credentials. Sherlock indexes all event tables, query logs, operational records, and analytical datasets automatically.
- 3
Ask your first cross-provider question. The game is afoot.
Type any question about your combined Aircall + ClickHouse stack in Slack. Sherlock queries all connected platforms in parallel, correlates the evidence, and returns a sourced answer in under 5 seconds.
FAQ
Common questions about Sherlock + Aircall + ClickHouse
How does Sherlock Calls connect Aircall and ClickHouse data?
- Sherlock uses read-only API access to both platforms simultaneously. When you ask a question, it queries Aircall, ClickHouse in parallel, correlates the results by timestamp and shared identifiers, and produces a single sourced answer — the same way a good detective correlates evidence from multiple witnesses.
Do I need to set up any data pipelines between Aircall and ClickHouse?
- No. Sherlock Calls is entirely pull-based — it queries both APIs on demand when you ask a question. There are no webhooks, no ETL pipelines, no data warehouses, and no code changes required in any of the connected platforms.
What kinds of questions can I ask about my Aircall + ClickHouse stack?
- You can investigate anything that spans both platforms — rep call activity and talk-time per deal, query volume and event ingestion rate, cross-platform costs, handoff patterns, and performance comparisons. Sherlock translates your plain-English question into the right API calls and returns the deduced answer.
Is my Aircall and ClickHouse data stored by Sherlock?
- No. Sherlock Calls queries your data in real time and returns results directly to Slack — nothing is stored, indexed, or replicated in any Sherlock database. All data remains in Aircall and ClickHouse and is accessed only during an active investigation.
How long does it take to set up the Aircall + ClickHouse integration?
- Elementary — typically under 5 minutes total. Connect each platform with read-only credentials, install the Sherlock Calls Slack app, and ask your first question. No engineering, no dashboards, no onboarding calls required.
Apply for early access to Sherlock + Aircall + ClickHouse
We're accepting a select group of beta users to shape the Aircall + ClickHouse combination. Tell us about your stack and we'll reach out personally if you're a fit.
Explore individual integrations