{ }DevToolsDaily
DevToolsDailyDirectory
ToolsInterview Prep
New
CheatsheetsDirectoryMy spaceBlog
Ctrl + K
Ask AI

ClickHouse

by ClickHouse

Open-source column-oriented database for real-time analytics

Visit clickhouse.com FreemiumOpen source

ClickHouse is an open-source columnar database for fast analytical SQL over large datasets, used for real-time analytics, observability, and data warehousing. It can be self-hosted or run as ClickHouse Cloud, and clickhouse-local and chDB run queries over local files without a server.

Key features

  • Columnar storage with vectorized execution
  • SQL with analytical functions
  • Reads Parquet, CSV, JSON, and many other formats
  • clickhouse-local for querying files
  • Managed ClickHouse Cloud

Similar tools

  • DuckDB

    In-process analytical SQL database for fast queries over local and remote files

    by DuckDB LabsFreeOpen sourceCLI, macOS, Windows +2

  • DBeaver

    Universal database client for SQL and NoSQL databases

    by DBeaver CorpFreemiumOpen sourcemacOS, Windows, Linux

  • Datasette

    Explore and publish SQLite data as an interactive website and JSON API

    FreeOpen sourceCLI, Web, Self-hosted

  • Neon

    Serverless Postgres with branching and scale to zero

    by Neon (Databricks)FreemiumOpen sourceWeb, API, CLI

  • PlanetScale

    Managed Postgres and Vitess (MySQL) databases built for scale

    by PlanetScalePaidWeb, CLI, API

  • Redis

    In-memory data store for caching, queues, and real-time data

    by RedisFreemiumOpen sourceLinux, macOS, Self-hosted +2

Built a tool like ClickHouse? Submit it for review

Buy me a coffeePrivacyTermsFAQChangelogFeature RequestsBlogAll ToolsPricingContact Us © Monkey SkatesHave kids?