ClickHouse Connector

ClickHouse is a fast open-source column-oriented database management system that allows generating analytical data reports in real-time using SQL queries.

Start for free

4.8 on G2

Weld · Data Sources

ClickHouseYour warehouseLive

Pick the tables to sync, and they appear here with their status.

Lands in

Queryable over MCP

How it works

Set up in minutes.
No code, no maintenance.

ClickHouse

Destination

Host

account.clickhouse.com

Database

analytics_db

Destination

ClickHouse as your warehouse.
Where your agents query.

Use ClickHouse as your central data warehouse with Weld. Connect any of 300+ sources and land clean, structured data in ClickHouse, ready for SQL, dbt models, BI tools, and agents over the Weld MCP server.

Resources

Everything you need.
To get started.

MCP server

Connect your agents

Set up Claude, Cursor, ChatGPT or Codex against your Weld workspace.

Weld Connect API

Build custom connectors

Use the Weld Connect API to build and publish your own connector.

FAQ

Common questions

Answers to frequently asked questions about Weld connectors.

Weld Connect API

Set it up in code.
One REST API.

Use the Weld Connect REST API to create ClickHouse connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.

Explore Weld Connect API reference

POST/elt_syncs

# Create a ClickHouse ELT sync
curl -X POST https://connect.weld.app/elt_syncs \
  -H "x-api-key: $API_KEY" \
  -d '{
    "connection_id": "conn_abc123",
    "integration_id": "clickhouse",
    "destination_schema_name": "clickhouse_data",
    "sync_interval": "0 * * * *"
  }'
▌