Skip to content
Notis

Find the right ClickHouse database for each meeting

New calendar events can start a quick discovery pass across your ClickHouse instance.

Trigger

New Calendar Event

Triggered when a new calendar event is created in the Outlook calendar.

Action

List ClickHouse Databases

List all databases in the clickhouse instance. useful for discovering available databases before querying tables.

Why this helps

Meeting preparation slows down when you do not know which database contains the needed metrics.

  • Find data sources faster
  • Reduce preparation friction
  • Create a repeatable discovery habit

Setup

Build it in a few focused steps.

  • 1Connect Outlook and ClickHouse in the Notis portal once.
  • 2Create an automation asking Notis to list databases relevant to meeting preparation.
  • 3Choose New Calendar Event as the trigger.
  • 4Select a report channel and test with one real event.

Questions about this workflow

Can Notis choose the best database automatically?

Ask it to identify the most relevant database from the returned names and your stated meeting purpose.

Does this query any rows?

No. It lists available ClickHouse databases.

When this happens · Trigger

Do this · Action

Supported Triggers and Actions

Notis builds workflows that link Outlook to ClickHouse. A trigger fires from one place; an action lands in another.

Outlook triggers

ClickHouse actions

Recurring trigger

Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.

TriggerScheduled

Execute ClickHouse Query

Execute a sql query in clickhouse and return the results. this is the primary action for querying data from clickhouse databases.

ActionInstant

Webhook trigger

Notis starts this workflow when an external tool or custom backend sends an HTTP request.

TriggerInstant

Get Database Schema

Get comprehensive schema overview of an entire database including all tables and optionally their column definitions. essential for ai agents to understand the complete database structure in a single call.

ActionInstant

New Contact Added

Triggered when a new contact is added in the Outlook contacts.

TriggerInstant

Get Table Schema

Get detailed schema information for a specific table including column definitions, types, keys, and optionally sample data. this is essential for ai agents to understand table structure before constructing queries.

ActionInstant

Calendar Event Changes

Triggered when a new calendar event occurs (created, updated, or deleted) in the Outlook calendar.

TriggerInstant

List ClickHouse Databases

List all databases in the clickhouse instance. useful for discovering available databases before querying tables.

ActionInstant

New Calendar Event

Triggered when a new calendar event is created in the Outlook calendar.

TriggerInstant

List ClickHouse Tables

List tables in clickhouse databases. returns information about tables including their engine, size, and row count.

ActionInstant

New Outlook Message

Triggered when a new message is received in the Outlook mailbox.

TriggerInstant

New Sent Message

Triggered when a new message is sent from the Outlook mailbox.

TriggerInstant

Connect any two apps with Notis in the middle.

Outlook and ClickHouse, or any other combination from 1,000+ integrations.

When this happens · Trigger

Do this · Action

Save your first hour today.

7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business ClickHouse.