Comparison

DuckDB vs Trino

On the evidence we track, DuckDB leads this comparison with a composite score of 62/100. Scores are only directly comparable because these tools share a category; the full breakdown and every source is below.

Machine formatsJSONMarkdownGraphQLor send Accept: application/json
DuckDB62
Trino52
Score
Vioscale score
DuckDB62 / 100medium · 56%
Trino52 / 100medium · 54%
Pricing
Free tier
DuckDB
Trino
Model
Price level
DuckDBfree
Trinofree
Transparent
DuckDB
Trino
Integrations
Count
DuckDB27
Trino18
Reliability
Status page
DuckDB
Trino
Adoption
Dependent repos
DuckDB1
Trino468
Github stars
DuckDB40,661
Trino13,183
Package downloads weekly
Trino
Activity
Commits last 30d
DuckDB100
Trino100
Release
Cadence days
DuckDB28
Trino45
History
DuckDB20 items
Trino7 items
License
Spdx
DuckDBMIT
Language
Primary
DuckDBC++
TrinoJava

Capabilities

Feature-by-feature on the axes that matter for data warehouse software. “-” means undocumented, not absent.

Deployment
Deployment
DuckDBEmbedded
TrinoSelf-hosted
Architecture
Architecture
DuckDB-
TrinoCoupled MPP
Compute model
DuckDB-
TrinoClusters
Query
SQL dialect
DuckDBVendor-specific
TrinoANSI SQL
Federation / lakehouse query-in-place
DuckDB
Trino
Interoperability
Table-format support
DuckDBParquet, CSV, JSON, Iceberg, Delta Lake, Vortex, DuckLake, Lance, Arrow, Avro, E
Trino-
Scale
Concurrency scaling
DuckDB-
Trino-
Ingestion
Streaming ingest
DuckDB-
Trino-
Data model
Semi-structured (JSON/VARIANT)
DuckDBFunctional
Trino-
Analytics
ML / in-DB functions
DuckDB
Trino-
Sharing
Data sharing / marketplace
DuckDB-
Trino-
Licensing
Licence class
DuckDBPermissive OSS
TrinoPermissive OSS

What each one is

The product in its own terms, so the numbers below have context.

DuckDB

Leader

An in-process SQL analytical database that runs natively in applications across operating systems and environments. Supports querying files and cloud data directly with a SQL dialect and includes vector search capabilities.

Independently observed

Trino

An open-source SQL query engine built for fast, distributed analytics over large-scale datasets stored in multiple systems. It enables users to query data in place without copying, supporting interactive analytics workloads from single queries to high-volume applications.

Independently observed

Pricing

List pricing as published by each vendor, with the date we read it. Always verify at the source before you buy.

DuckDB

Leader
Open sourceFree tier

Free, open source under MIT license

as of verify ↗

Trino

Open sourceFree tier
as of verify ↗

Platform & deployment

Where each product runs and how it can be hosted. A dash means undocumented, not unsupported.

Platforms
Web
DuckDB
Trino
macOS
DuckDB
Trino
Windows
DuckDB
Trino
Linux
DuckDB
Trino
CLI
DuckDB
Trino
Deployment
Cloud / SaaS
DuckDB
Trino
Self-hosted
DuckDB
Trino
On-premise
DuckDB
Trino

Integrations

What each product connects to. Counts come from the vendor's own integration directory where one exists.

In common (2)
  • S3
  • MySQL

DuckDB

Leader
27 total - 25 not shared
  • Postgres
  • AWS
  • Azure
  • Google Cloud
  • Hugging Face
  • SQLite
  • Iceberg
  • Delta Lake
  • Parquet
  • JSON
  • Arrow
  • Avro
  • Pandas
  • dplyr
  • Jupyter
  • Marimo
  • Claude
  • Cloudflare
  • ODBC
  • HTTP
  • Excel
  • Vortex
  • DuckLake
  • Lance
  • +1 more
Independently observed

Trino

18 total - 16 not shared
  • Grafana
  • Apache Airflow
  • Apache DolphinScheduler
  • Coginiti
  • Cube
  • DBeaver
  • dbt
  • DbVisualizer
  • Emacs
  • Tableau
  • Power BI
  • Superset
  • R
  • Hadoop
  • Cassandra
  • Elasticsearch
Independently observed

Comparison generated from independently-sourced facts. Every value links to its source and retrieval date. See the method.