Integrations / Databases
Connect ClickHouse to WhatsApp with an AI agent
Flann is an AI agent your business talks to on WhatsApp. Connect ClickHouse once, then ask Flann to look things up in it or get work done in it, by text or voice note. ClickHouse holds data about how your business is doing. Flann turns it into answers you can read on WhatsApp.
6 actions in ClickHouse. All of them only look things up, so nothing in ClickHouse is ever changed. You connect with your API key.
What you can ask Flann to do in ClickHouse
Send any of these on WhatsApp, in your own words. Flann finds the right ClickHouse action and fills in the details from the conversation.
“Show me my tables in ClickHouse.”
“Show me my databases in ClickHouse.”
“Look up the play interface in ClickHouse.”
Step by step: ClickHouse jobs you can hand to Flann
Each step below names the ClickHouse action Flann actually runs.
Get answers about your tables
- You message Flann on WhatsApp: “What is the latest on our tables in ClickHouse?”
- Flann runs
List ClickHouse Tablesin ClickHouse and shows you what it found. - Nothing in ClickHouse is changed: these are look-ups, so they run straight away.
Check your databases from WhatsApp
- You message Flann on WhatsApp: “Show me where our databases in ClickHouse stand.”
- Flann runs
List ClickHouse Databasesin ClickHouse and shows you what it found. - Nothing in ClickHouse is changed: these are look-ups, so they run straight away.
Get answers about your play interfaces
- You message Flann on WhatsApp: “What is the latest on our play interfaces in ClickHouse?”
- Flann runs
Get ClickHouse Play Interfacein ClickHouse and shows you what it found. - Nothing in ClickHouse is changed: these are look-ups, so they run straight away.
Repetitive ClickHouse work Flann takes off your plate
These are the jobs that come back every day or every week. Message Flann instead, and keep the decisions for yourself.
Logging daily readings and counts
Today
Fridge temperatures, stock counts or class attendance have to go into ClickHouse every day. They are written on paper first, then typed up when someone remembers.
With Flann
“Fridge one at three degrees, fridge two at four, freezer at minus eighteen. Log it in ClickHouse.”
Your message or voice note becomes a row in ClickHouse, with the date, time and who logged it, and any reading outside the safe range you have set is flagged to you straight away. Simple.
What you stop doing: Typing up paper logs at the end of the day is no longer needed.
Looking up a record mid-conversation
Today
A customer on the phone asks when their membership renews or what they ordered last time. Finding the record in ClickHouse means a laptop, a login and a search screen.
With Flann
“When does Priya Shah’s membership renew? Check ClickHouse.”
Within the chat, Flann searches ClickHouse for the record and replies with the renewal date, plan and last visit. If two records match, it asks which one you mean. Looking up changes nothing, so it happens straight away.
What you stop doing: Opening a laptop to answer a simple customer question is unnecessary now.
More on this: how to hand repetitive tasks to an AI agent on WhatsApp.
How Flann connects to ClickHouse
- Search for ClickHouse in Flann’s Connectors.
- Paste your ClickHouse API key into the secure form Flann opens. You will find the key in your ClickHouse account settings.
- Go back to WhatsApp and ask for what you need. Flann chooses the ClickHouse action and fills in the details.
Look-ups run as soon as you ask and change nothing in ClickHouse. You can disconnect ClickHouse from Connectors at any time.
Ways to use ClickHouse with Flann
Check before you decide
Before a big call, ask Flann for the figure that matters. It looks it up in ClickHouse first.
A weekly summary on demand
Ask Flann for the week in brief. It reads ClickHouse and sends the few numbers worth knowing.
Ask, do not dig
Ask how this week compares to last. Flann pulls the numbers from ClickHouse and answers in plain words.
There are three ways to get routine work done in ClickHouse. Side by side:
| Compare | ClickHouse on its ownEvery step is yours | A rules toolRuns the steps you wired up | With FlannThe work comes to your chat |
|---|---|---|---|
| How you ask | Open the app and find the right page | Only what was wired up in advance | A WhatsApp message, typed or spoken |
| Finding answers | Filters and searches you run yourself | Only the look-ups someone built | 6 look-ups, answered straight away |
| ClickHouse records | All of them, one screen at a time | Only the ones you wire up | 3 kinds, from one chat |
| Getting connected | Nothing new to set up | Someone builds and maintains each flow | Your ClickHouse API key, once |
YesPartlyNo
Everything Flann can do in ClickHouse
The full list of ClickHouse actions available to Flann once you connect it.
Looks up 6
- Execute ClickHouse Query
- Get Database Schema
- Get Table Schema
- List ClickHouse Databases
- List ClickHouse Tables
- Get ClickHouse Play Interface
Changes 0
None.
More Databases apps Flann works with
FoursquareCommon questions
How does Flann connect to ClickHouse?
Open Connectors in Flann, choose ClickHouse and paste your ClickHouse API key into a secure form. You will find the key in your ClickHouse account settings. Once it is connected, Flann can use 6 actions in ClickHouse.
Can I use ClickHouse from WhatsApp?
Yes. You talk to Flann on WhatsApp or in the Flann app, by text or voice note, and Flann works in ClickHouse for you. You do not need to open ClickHouse.
Is ClickHouse included in my Flann plan?
Yes. Every Flann plan includes every app, ClickHouse included.