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.
Execute ClickHouse Query
Runs a SQL query in ClickHouse, including queries that modify data or schema.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Get Database Schema
Retrieves a ClickHouse database schema overview and optionally its column definitions.
Get Table Schema
Gets the schema and column details for a table.
Get ClickHouse Play Interface
Returns the ClickHouse Play interface for writing queries and viewing results.
List ClickHouse Databases
Lists the databases in an instance.
List ClickHouse Tables
Lists tables in databases with basic details.
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.