Skip to content
Notis

Discover the ClickHouse Databases Behind Your Analytics

Start with a request and get a clear list of ClickHouse databases before deciding where your on-chain data query belongs.

Trigger

Webhook received

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

Action

List ClickHouse Databases

Lists the databases in an instance.

Why this helps

When several databases are available, choosing where to look can add friction before the actual analysis begins.

  • Get a list of available ClickHouse databases when your system requests it.
  • Review database options before preparing a data query.
  • Summarize the returned list so the next step is easier to choose.

Setup

Build it in a few focused steps.

  • 1Connect Alchemy and ClickHouse once in the Notis portal.
  • 2Create an automation in Automations, New Automation, and give it a name.
  • 3Tell Notis to list the available ClickHouse databases and summarize the options.
  • 4Choose a Webhook trigger and where run reports should go.
  • 5Send one real example request and check the returned database list.

Questions about this workflow

Does this workflow list tables too?

No. It lists databases. Use a separate ClickHouse table listing action when you need to inspect tables.

Can the database list tell me which database holds my Alchemy data?

The list provides database names. You need to know or investigate which one contains the data you want.

How does the workflow start?

It starts when an external system sends an HTTP request to the Notis Webhook you select.

When this happens · Trigger

Do this · Action

Lists the databases in an instance.

Supported Triggers and Actions

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

Alchemy triggers

ClickHouse actions

Recurring trigger

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

TriggerScheduled

Execute ClickHouse Query

Runs a SQL query in ClickHouse, including queries that modify data or schema.

ActionInstant

Webhook trigger

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

TriggerInstant

Get Database Schema

Retrieves a ClickHouse database schema overview and optionally its column definitions.

ActionInstant

Get Table Schema

Gets the schema and column details for a table.

ActionInstant

Get ClickHouse Play Interface

Returns the ClickHouse Play interface for writing queries and viewing results.

ActionInstant

List ClickHouse Databases

Lists the databases in an instance.

ActionInstant

List ClickHouse Tables

Lists tables in databases with basic details.

ActionInstant

Connect any two apps with Notis in the middle.

Alchemy and ClickHouse, or any other combination from 1,600+ 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.