# ClickHouse vs TimescaleDB

**Leader by vioscaleAI score:** ClickHouse

| Attribute | ClickHouse | TimescaleDB |
|---|---|---|
| **vioscaleAI score** | 65.7 (60% (medium)) | 56.8 (62% (medium)) |
| activity.commits_last_30d | 100 | 100 |
| adoption.dependent_repos | 1 | 0 |
| adoption.github_stars | 50,255 | 23,634 |
| content.faq | `[{"answer":"An open-source columnar database system designed to handle large-scale analytical workloads with extremely low latency. Excels at real-time analytics, observability (logs, metrics, traces), data warehousing, and AI/ML applications. It is indexed under Time-Series Databases.","source":"https://clickhouse.com/pricing","question":"What is ClickHouse?","confidence":0.6},{"answer":"ClickHouse offers a free tier, so you can start without paying. Paid plans start at $0.22 per hour. Prices are published openly on the vendor's own pricing page. Pricing changes often, so verify at source before relying on it.","source":"https://clickhouse.com","question":"Is ClickHouse free?","confidence":0.6},{"answer":"ClickHouse supports the web, Linux and a command-line interface. Platforms we have not confirmed are simply not listed here rather than ruled out.","source":"https://clickhouse.com/pricing","question":"What platforms does ClickHouse support?","confidence":0.6},{"answer":"Yes. ClickHouse can be deployed cloud / SaaS, hybrid and self-hosted, so it does not have to run on the vendor's infrastructure.","source":"https://clickhouse.com/pricing","question":"Can ClickHouse be self-hosted?","confidence":0.6},{"answer":"We have confirmed 11 integrations for ClickHouse, including Amazon S3, Kafka, Airbyte, Vector, PostgreSQL, MySQL, Microsoft Azure Data Factory and dbt, plus 3 more. This is what we could verify from public sources, so the vendor may support others we have not indexed.","source":"https://clickhouse.com/pricing","question":"What does ClickHouse integrate with?","confidence":0.6},{"answer":"We have independently confirmed SOC 2, ISO 27001, HIPAA and GDPR for ClickHouse. Certifications we do not list are ones we have not been able to verify from public sources, which is not the same as ClickHouse not holding them. Always confirm compliance directly before you rely on it.","source":"https://clickhouse.com/legal/agreements/security-addendum","question":"What security certifications does ClickHouse have?","confidence":0.7},{"answer":"Yes. ClickHouse is published under the Apache-2.0 licence, a permissive licence that generally allows commercial use and modification. Licence terms can change between releases, so verify against the repository for the version you intend to use.","source":"https://github.com/ClickHouse/ClickHouse","question":"Is ClickHouse open source?","confidence":0.95}]` | `[{"answer":"Built on PostgreSQL, this time-series database is optimized for ingesting high-volume sensor and operational data quickly, storing years of historical data cost-effectively, and querying both current and historical data together using standard SQL. It is indexed under Time-Series Databases.","source":"https://www.tigerdata.com/learn/understanding-rds-pricing-and-costs","question":"What is TimescaleDB?","confidence":0.6},{"answer":"TimescaleDB does not publish its prices. Pricing is quoted on request, across 2 plans (Cloud Basic Support and Cloud Production Support), so the figure depends on your seat count and requirements. We record this as a pricing-transparency signal rather than guessing a number. Pricing changes often, so verify at source before relying on it.","source":"https://www.tigerdata.com/learn/understanding-rds-pricing-and-costs","question":"How much does TimescaleDB cost?","confidence":0.6},{"answer":"TimescaleDB supports the web and a command-line interface. Platforms we have not confirmed are simply not listed here rather than ruled out.","source":"https://www.tigerdata.com/learn/understanding-rds-pricing-and-costs","question":"What platforms does TimescaleDB support?","confidence":0.6},{"answer":"We have only confirmed a cloud / SaaS deployment for TimescaleDB, so it appears to be vendor-hosted. If a self-hosted option exists we have not found it documented publicly.","source":"https://www.tigerdata.com/learn/understanding-rds-pricing-and-costs","question":"Can TimescaleDB be self-hosted?","confidence":0.6},{"answer":"We have confirmed 9 integrations for TimescaleDB, including Kafka, S3, Iceberg, AWS, Azure, Observability tools, Postgres ecosystem and Tableau, plus 1 more. This is what we could verify from public sources, so the vendor may support others we have not indexed.","source":"https://www.tigerdata.com/learn/understanding-rds-pricing-and-costs","question":"What does TimescaleDB integrate with?","confidence":0.6},{"answer":"We have independently confirmed SOC 2, HIPAA and GDPR for TimescaleDB. Certifications we do not list are ones we have not been able to verify from public sources, which is not the same as TimescaleDB not holding them. Always confirm compliance directly before you rely on it.","source":"https://www.tigerdata.com/security","question":"What security certifications does TimescaleDB have?","confidence":0.7},{"answer":"TimescaleDB is available worldwide. Its primary market is the United States.","source":"https://www.tigerdata.com/learn/understanding-rds-pricing-and-costs","question":"Where is TimescaleDB available?","confidence":0.5}]` |
| deployment.options | `{"cloud":true,"hybrid":true,"self_hosted":true}` | `{"cloud":true,"self_hosted":true}` |
| description.long | A column-oriented database that processes analytical queries efficiently on large datasets using compression and vectorized execution. It supports fast aggregations and search over logs, metrics, and traces, with vector search capabilities for AI workloads. | A PostgreSQL-based time-series database optimized to efficiently ingest and store massive volumes of continuously-generated sensor and machine data, with automatic data partitioning, columnar storage compression, and tiered storage for cost-effective long-term retention. |
| features.capabilities | `{"hosting":"both","clustering":"distributed","data_model":"both","deployment":"self_hosted","compression":"columnar","replication":true,"sql_support":true,"ingest_model":"both","licence_class":"permissive_oss","managed_cloud":true,"vector_search":true,"query_language":"SQL","replication_ha":true,"high_cardinality":"strong","sql_compatibility":"full_sql","horizontal_scaling":true}` | `{"clustering":"distributed","data_model":"metrics","deployment":"embedded","compression":"Row-columnar with compression","downsampling":"continuous_aggregates","ingest_model":"both","licence_class":"permissive_oss","retention_ttl":"automatic","query_language":"SQL","replication_ha":true,"high_cardinality":"strong","sql_compatibility":"full_sql"}` |
| integrations.count | 100 | 3 |
| integrations.list | `[{"name":"Amazon S3"},{"name":"Kafka"},{"name":"Airbyte"},{"name":"Vector"},{"name":"PostgreSQL"},{"name":"MySQL"},{"name":"Microsoft Azure Data Factory"},{"name":"dbt"},{"name":"Calyptia"},{"name":"Dataddo"},{"name":"GrowthBook"},{"name":"OpenTelemetry","native":false,"category":"observability","direction":"inbound"},{"name":"HyperDX","native":true,"category":"visualization","direction":"bidirectional"},{"name":"Langfuse","native":true,"category":"observability","direction":"bidirectional"},{"name":"Cassandra","native":false},{"name":"Google","native":true,"category":"authentication","direction":"inbound"},{"name":"Microsoft","native":true,"category":"authentication","direction":"inbound"},{"name":"AWS","native":true,"category":"cloud","direction":"bidirectional"},{"name":"Google Cloud","native":true,"category":"cloud","direction":"bidirectional"},{"name":"Azure","native":true,"category":"cloud","direction":"bidirectional"},{"name":"GitHub","native":false,"category":"development","direction":"inbound"},{"name":"Slack","native":false,"category":"chat"}]` | `[{"name":"Kafka"},{"name":"S3"},{"name":"Iceberg"},{"name":"AWS"},{"name":"Azure"},{"name":"Observability tools"},{"name":"Postgres ecosystem"},{"name":"Tableau","native":false,"category":"analytics"},{"name":"Power BI","native":false,"category":"analytics"}]` |
| language.primary | C++ | C |
| license.spdx | Apache-2.0 | - |
| market.availability | `{"hqCountry":"US","primaryMarkets":["US"],"availabilityScope":"global","availableCountries":[],"notAvailableCountries":[]}` | `{"primaryMarkets":["US"],"availabilityScope":"global","availableCountries":[],"notAvailableCountries":[]}` |
| platform.support | `{"cli":true,"web":true,"linux":true}` | `{"cli":true,"web":true}` |
| pricing | `{"type":"usage","plans":[{"free":false,"name":"Basic","features":["Up to 1 TB storage","1 availability zone","Export backups to own cloud account","Expert support with 1 business day response time","SSO with Google or Microsoft","Multi-factor authentication"],"components":[{"kind":"fixed","amount":53,"period":"month","currency":"USD"},{"per":{"qty":1,"unit":"TB"},"kind":"metered","amount":0.2181,"currency":"USD"}],"description":"Development and testing with limited storage","contactSales":false,"includedLimits":{"storage":"1 TB"}},{"free":false,"name":"Scale","features":["Unlimited storage","2+ availability zones","24x7 expert support with 1 hour response for Severity 1 issues","S3 role-based access","Automatic vertical scaling","Manual horizontal scaling"],"components":[{"kind":"fixed","amount":437,"period":"month","currency":"USD"},{"per":{"qty":1,"unit":"TB"},"kind":"metered","amount":0.2985,"currency":"USD"}],"description":"Production environments with unlimited scalable storage","contactSales":false,"includedLimits":{"storage":"Unlimited"}},{"free":false,"name":"Enterprise","features":["SAML SSO","Private regions","Enterprise support with 30 minute response time","Named Lead Support Engineer","Transparent data encryption and CMEK","HIPAA and PCI compliance"],"components":[{"kind":"fixed","amount":571,"period":"month","currency":"USD"},{"per":{"qty":1,"unit":"TB"},"kind":"metered","amount":0.3903,"currency":"USD"}],"description":"Enterprise deployments with compliance and advanced security controls","contactSales":false,"includedLimits":{"storage":"Unlimited"}}],"summary":"From $53/month plus usage-based compute and storage. Free tier with $300 credits for 30 days.","currency":"USD","freeTier":true,"sourceUrl":"https://clickhouse.com/pricing","retrievedAt":"2026-10-05T10:14:01.496Z","freeTrialDays":30,"startingPrice":{"amount":53,"period":"month","currency":"USD"},"billingPeriods":["month"]}` | `{"type":"usage","plans":[{"free":false,"name":"Performance","summary":"$30/month minimum compute; $0.177/GB-month storage","features":["4 database services","Up to 16 TB disk storage per service","Single-node high-availability replicas","Performance Insights","Basic support (business hours)"],"commitment":"monthly","components":[{"kind":"fixed","amount":30,"period":"month","currency":"USD"},{"per":{"qty":1,"unit":"gb"},"kind":"metered","amount":0.177,"currency":"USD"}],"contactSales":false},{"free":false,"name":"Scale","summary":"$36/month minimum compute; $0.212/GB-month storage","features":["Unlimited tiered storage","Multi-node high-availability replicas","Integrations with observability tools","SAML single-sign-on","HIPAA compliance"],"commitment":"monthly","components":[{"kind":"fixed","amount":36,"period":"month","currency":"USD"},{"per":{"qty":1,"unit":"gb"},"kind":"metered","amount":0.212,"currency":"USD"}],"contactSales":false}],"summary":"From $30/month minimum compute. Storage from $0.177–$0.212/GB-month. 30-day free trial.","currency":"USD","freeTier":true,"sourceUrl":"https://www.tigerdata.com/pricing","retrievedAt":"2026-10-02T16:22:02.553Z","freeTrialDays":30,"startingPrice":{"amount":30,"period":"month","currency":"USD"},"billingPeriods":["month"]}` |
| pricing.free_tier | yes | yes |
| pricing.model | freemium | freemium |
| pricing.price_level | mid | mid |
| pricing.starting_price | `{"amount":53,"currency":"USD"}` | `{"amount":30,"currency":"USD"}` |
| pricing.transparent | yes | yes |
| release.cadence_days | - | 12 |
| release.history | `[{"url":"https://github.com/ClickHouse/ClickHouse/releases/tag/v26.9.10.4-stable","date":"2026-10-04T07:07:07Z","type":"stable","version":"v26.9.10.4-stable"},{"url":"https://github.com/ClickHouse/ClickHouse/releases/tag/v26.8.17.4-lts","date":"2026-10-04T16:53:21Z","type":"stable","version":"v26.8.17.4-lts"},{"url":"https://github.com/ClickHouse/ClickHouse/releases/tag/v26.7.21.2-stable","date":"2026-10-04T15:39:19Z","type":"stable","version":"v26.7.21.2-stable"},{"url":"https://github.com/ClickHouse/ClickHouse/releases/tag/v26.3.41.4-lts","date":"2026-10-04T14:18:22Z","type":"stable","version":"v26.3.41.4-lts"},{"url":"https://github.com/ClickHouse/ClickHouse/releases/tag/v26.9.9.28-stable","date":"2026-10-03T18:04:59Z","type":"stable","version":"v26.9.9.28-stable"},{"url":"https://github.com/ClickHouse/ClickHouse/releases/tag/v26.8.16.41-lts","date":"2026-10-03T16:29:58Z","type":"stable","version":"v26.8.16.41-lts"},{"url":"https://github.com/ClickHouse/ClickHouse/releases/tag/v26.7.20.28-stable","date":"2026-10-03T15:08:53Z","type":"stable","version":"v26.7.20.28-stable"},{"url":"https://github.com/ClickHouse/ClickHouse/releases/tag/v26.3.40.16-lts","date":"2026-10-03T13:51:37Z","type":"stable","version":"v26.3.40.16-lts"},{"url":"https://github.com/ClickHouse/ClickHouse/releases/tag/v26.3.39.7-lts","date":"2026-10-02T12:39:18Z","type":"stable","version":"v26.3.39.7-lts"},{"url":"https://github.com/ClickHouse/ClickHouse/releases/tag/v26.9.8.3-stable","date":"2026-10-01T15:14:40Z","type":"stable","version":"v26.9.8.3-stable"},{"url":"https://github.com/ClickHouse/ClickHouse/releases/tag/v26.7.19.5-stable","date":"2026-10-01T13:48:36Z","type":"stable","version":"v26.7.19.5-stable"},{"url":"https://github.com/ClickHouse/ClickHouse/releases/tag/v26.3.38.2-lts","date":"2026-10-01T12:32:21Z","type":"stable","version":"v26.3.38.2-lts"},{"url":"https://github.com/ClickHouse/ClickHouse/releases/tag/v26.9.7.9-stable","date":"2026-09-30T15:30:54Z","type":"stable","version":"v26.9.7.9-stable"},{"url":"https://github.com/ClickHouse/ClickHouse/releases/tag/v26.7.18.2-stable","date":"2026-09-30T13:56:44Z","type":"stable","version":"v26.7.18.2-stable"},{"url":"https://github.com/ClickHouse/ClickHouse/releases/tag/v26.3.37.3-lts","date":"2026-09-30T12:37:27Z","type":"stable","version":"v26.3.37.3-lts"},{"url":"https://github.com/ClickHouse/ClickHouse/releases/tag/v26.9.6.6-stable","date":"2026-09-29T17:05:48Z","type":"stable","version":"v26.9.6.6-stable"},{"url":"https://github.com/ClickHouse/ClickHouse/releases/tag/v26.8.15.10-lts","date":"2026-09-29T15:11:15Z","type":"stable","version":"v26.8.15.10-lts"},{"url":"https://github.com/ClickHouse/ClickHouse/releases/tag/v26.7.17.7-stable","date":"2026-09-29T13:50:16Z","type":"stable","version":"v26.7.17.7-stable"},{"url":"https://github.com/ClickHouse/ClickHouse/releases/tag/v26.3.36.6-lts","date":"2026-09-29T12:29:53Z","type":"stable","version":"v26.3.36.6-lts"},{"url":"https://github.com/ClickHouse/ClickHouse/releases/tag/v26.9.5.2-stable","date":"2026-09-28T16:25:06Z","type":"stable","version":"v26.9.5.2-stable"}]` | `[{"url":"https://github.com/timescale/timescaledb/releases/tag/2.30.2","date":"2026-09-29T15:20:31Z","type":"stable","version":"2.30.2"},{"url":"https://github.com/timescale/timescaledb/releases/tag/2.30.1","date":"2026-09-17T09:21:45Z","type":"stable","version":"2.30.1"},{"url":"https://github.com/timescale/timescaledb/releases/tag/2.30.0","date":"2026-09-08T10:54:46Z","type":"stable","version":"2.30.0"},{"url":"https://github.com/timescale/timescaledb/releases/tag/2.29.2","date":"2026-08-18T08:48:11Z","type":"stable","version":"2.29.2"},{"url":"https://github.com/timescale/timescaledb/releases/tag/2.29.1","date":"2026-08-04T08:54:38Z","type":"stable","version":"2.29.1"},{"url":"https://github.com/timescale/timescaledb/releases/tag/2.29.0","date":"2026-07-28T11:49:24Z","type":"stable","version":"2.29.0"},{"url":"https://github.com/timescale/timescaledb/releases/tag/2.28.3","date":"2026-07-16T12:54:32Z","type":"stable","version":"2.28.3"},{"url":"https://github.com/timescale/timescaledb/releases/tag/2.28.2","date":"2026-06-30T11:35:40Z","type":"stable","version":"2.28.2"},{"url":"https://github.com/timescale/timescaledb/releases/tag/2.28.1","date":"2026-06-23T08:29:24Z","type":"stable","version":"2.28.1"},{"url":"https://github.com/timescale/timescaledb/releases/tag/2.28.0","date":"2026-06-16T10:20:10Z","type":"stable","version":"2.28.0"},{"url":"https://github.com/timescale/timescaledb/releases/tag/2.27.2","date":"2026-06-02T10:28:34Z","type":"stable","version":"2.27.2"},{"url":"https://github.com/timescale/timescaledb/releases/tag/2.27.1","date":"2026-05-19T10:37:36Z","type":"stable","version":"2.27.1"},{"url":"https://github.com/timescale/timescaledb/releases/tag/2.27.0","date":"2026-05-12T08:35:57Z","type":"stable","version":"2.27.0"},{"url":"https://github.com/timescale/timescaledb/releases/tag/2.26.4","date":"2026-04-28T20:37:35Z","type":"stable","version":"2.26.4"},{"url":"https://github.com/timescale/timescaledb/releases/tag/2.26.3","date":"2026-04-14T09:24:02Z","type":"stable","version":"2.26.3"},{"url":"https://github.com/timescale/timescaledb/releases/tag/2.26.2","date":"2026-04-08T10:37:56Z","type":"stable","version":"2.26.2"},{"url":"https://github.com/timescale/timescaledb/releases/tag/2.26.1","date":"2026-03-30T08:23:08Z","type":"stable","version":"2.26.1"},{"url":"https://github.com/timescale/timescaledb/releases/tag/2.26.0","date":"2026-03-24T12:44:25Z","type":"stable","version":"2.26.0"},{"url":"https://github.com/timescale/timescaledb/releases/tag/2.25.2","date":"2026-03-03T09:28:51Z","type":"stable","version":"2.25.2"},{"url":"https://github.com/timescale/timescaledb/releases/tag/2.25.1","date":"2026-02-17T11:43:20Z","type":"stable","version":"2.25.1"}]` |
| reliability.status_page | yes | yes |
| security.certifications | `[{"name":"SOC 2 Type II","level":"Type II","status":"active"},{"name":"ISO 27001","status":"active"},{"name":"HIPAA","status":"active"},{"name":"PCI DSS Level 1 Service Provider","level":"Level 1","status":"active"}]` | `[{"name":"SOC 2 Type II","level":"Type II","status":"active"}]` |
| security.disclosure_policy | yes | yes |
| security.gdpr | yes | yes |
| security.hipaa | yes | yes |
| security.iso27001 | yes | - |
| security.pci | yes | yes |
| security.scorecard | 4.8 | 4.6 |
| security.soc2 | yes | yes |
| security.trust_center | https://clickhouse.com/legal/agreements/security-addendum | https://www.tigerdata.com/security |
| security.vulnerabilities | `{"count":0,"source":"https://advisories.ecosyste.ms/api/v1/advisories?ecosystem=go&package_name=github.com%2FClickHouse%2FClickHouse&per_page=100","last_12m":0,"max_severity":null}` | `{"count":0,"source":"https://advisories.ecosyste.ms/api/v1/advisories?ecosystem=alpine&package_name=postgresql-timescaledb&per_page=100","last_12m":0,"max_severity":null}` |

## Capabilities (Time-Series Databases)

| Capability | ClickHouse | TimescaleDB |
|---|:--:|:--:|
| **Query** |  |  |
| Query language (SQL / PromQL / InfluxQL-Flux / Graphite) | SQL | SQL |
| SQL compatibility | Full SQL | Full SQL |
| **Ingest** |  |  |
| Ingest model | Both | Both |
| **Model** |  |  |
| Data model | Both | Metrics (labels/tags) |
| **Lifecycle** |  |  |
| Downsampling / rollups | - | Continuous aggregates |
| Retention / TTL | - | Automatic |
| **Storage** |  |  |
| Compression (columnar / delta / Gorilla) | columnar | Row-columnar with compression |
| **Performance** |  |  |
| High-cardinality handling | Strong | Strong |
| **Scale** |  |  |
| Clustering / horizontal scale | Distributed / sharded | Distributed / sharded |
| Replication / HA | ✓ | ✓ |
| **Deployment** |  |  |
| Deployment | Self-hosted | Embedded |
| **Interop** |  |  |
| Prometheus remote-write compatible | - | - |
| **Licensing** |  |  |
| Licence class | Permissive OSS | Permissive OSS |

*Source: vioscaleAI. Generated 2026-10-16T20:13:19.999Z. "-" = undocumented, not absent.*