ClickHouse

Platform

Columnar database for analytical SQL over large event datasets

Price: Free server; Cloud trial then paid
Access: Configure database credentials

About

ClickHouse is an Apache-2.0 columnar database for analytical workloads. Use ClickHouse Cloud or operate your own server, with HTTP SQL and native clients. Configure database credentials; its official MCP server can run locally against either deployment.

What you can do with it

Query large event datasets with columnar SQL analytics
Host an analytical database for logs, telemetry or product events
Run reporting queries from an application through the HTTP SQL interface

Get started

Start a ClickHouse server or create a Cloud service
Configure a database user and HTTPS endpoint
Submit a SELECT query over HTTP or through a client

Example

curl "$CLICKHOUSE_URL/?query=SELECT%20version()" \
  --user "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD"

Details

Hosting: Hosted service, Self-hosted, Runs locally
Available in: Worldwide
Official SDKs: JavaScript/TypeScript, Python
MCP server: Local