# DuckDB vs Trino

**Leader by vioscaleAI score:** DuckDB

| Attribute | DuckDB | Trino |
|---|---|---|
| **vioscaleAI score** | 59.1 (51% (medium)) | 50.7 (54% (medium)) |
| activity.commits_last_30d | 100 | 100 |
| adoption.dependent_repos | 1 | 468 |
| adoption.github_stars | 42,154 | 13,330 |
| adoption.package_downloads_weekly | 15,285,415 | - |
| content.faq | `[{"answer":"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. It is indexed under Data Warehouse Software.","source":"https://duckdb.org","question":"What is DuckDB?","confidence":0.6},{"answer":"DuckDB is open source, so it can be self-hosted and used at no licence cost. It is released under the MIT licence. Pricing changes often, so verify at source before relying on it.","source":"https://duckdb.org","question":"Is DuckDB free to use?","confidence":0.6},{"answer":"DuckDB supports the web, Windows, macOS, Linux and a command-line interface. Platforms we have not confirmed are simply not listed here rather than ruled out.","source":"https://duckdb.org","question":"What platforms does DuckDB support?","confidence":0.6},{"answer":"Yes. DuckDB can be deployed self-hosted, so it does not have to run on the vendor's infrastructure.","source":"https://duckdb.org","question":"Can DuckDB be self-hosted?","confidence":0.6},{"answer":"We have confirmed 27 integrations for DuckDB, including Postgres, AWS, S3, Azure, Google Cloud, Hugging Face, SQLite and MySQL, plus 19 more. This is what we could verify from public sources, so the vendor may support others we have not indexed.","source":"https://duckdb.org","question":"What does DuckDB integrate with?","confidence":0.6},{"answer":"Yes. DuckDB is published under the MIT 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/duckdb/duckdb","question":"Is DuckDB open source?","confidence":0.99},{"answer":"DuckDB is available worldwide. The vendor is headquartered in the Netherlands.","source":"https://duckdb.org","question":"Where is DuckDB available?","confidence":0.75}]` | `[{"answer":"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. It is indexed under Data Warehouse Software.","source":"https://trino.io","question":"What is Trino?","confidence":0.6},{"answer":"Trino is open source, so it can be self-hosted and used at no licence cost. It is released under the Apache-2.0 licence. Pricing changes often, so verify at source before relying on it.","source":"https://trino.io","question":"Is Trino free to use?","confidence":0.6},{"answer":"Trino supports a command-line interface. Platforms we have not confirmed are simply not listed here rather than ruled out.","source":"https://trino.io","question":"What platforms does Trino support?","confidence":0.6},{"answer":"Yes. Trino can be deployed cloud / SaaS, on-premise and self-hosted, so it does not have to run on the vendor's infrastructure.","source":"https://trino.io","question":"Can Trino be self-hosted?","confidence":0.6},{"answer":"We have confirmed 17 integrations for Trino, including Grafana, Apache Airflow, Apache DolphinScheduler, Coginiti, Cube, DBeaver, dbt and DbVisualizer, plus 9 more. This is what we could verify from public sources, so the vendor may support others we have not indexed.","source":"https://trino.io","question":"What does Trino integrate with?","confidence":0.6},{"answer":"Yes. Trino 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/trinodb/trino","question":"Is Trino open source?","confidence":0.95}]` |
| deployment.options | `{"self_hosted":true}` | `{"self_hosted":true}` |
| description.long | A portable analytical database that runs locally or embedded in applications, with PostgreSQL-like SQL and APIs for major programming languages, supporting popular data formats including CSV, JSON, Parquet, and Apache Iceberg. | Trino is an open-source SQL query engine designed for fast analytics on big data. It enables distributed querying across multiple data sources and integrates with numerous data processing, visualization, and analytics tools. |
| features.capabilities | `{"in_db_ml":true,"deployment":"embedded","sql_dialect":"vendor","license_class":"permissive","table_formats":"Parquet, CSV, JSON, Iceberg, Delta Lake, Vortex, DuckLake, Lance, Arrow, Avro, E","semi_structured":"functional","federation_query":true}` | `{"deployment":"self","sql_dialect":"ansi","architecture":"coupled_mpp","compute_model":"clusters","license_class":"permissive","federation_query":true}` |
| integrations.count | 27 | 10 |
| integrations.list | `[{"name":"Postgres"},{"name":"AWS"},{"name":"S3"},{"name":"Azure"},{"name":"Google Cloud"},{"name":"Hugging Face"},{"name":"SQLite"},{"name":"MySQL"},{"name":"Iceberg"},{"name":"Delta Lake"},{"name":"Parquet"},{"name":"JSON"},{"name":"Arrow"},{"name":"Avro"},{"name":"Pandas"},{"name":"dplyr"},{"name":"Jupyter"},{"name":"Marimo"},{"name":"Claude"},{"name":"Cloudflare"},{"name":"ODBC"},{"name":"HTTP"},{"name":"Excel"},{"name":"Vortex"},{"name":"DuckLake"},{"name":"Lance"},{"name":"Geospatial formats"},{"name":"PostgreSQL","category":"database"},{"name":"Apache Iceberg","category":"table_format"},{"name":"ADBC","native":true}]` | `[{"name":"Grafana"},{"name":"Apache Airflow"},{"name":"Apache DolphinScheduler"},{"name":"Coginiti"},{"name":"Cube"},{"name":"DBeaver"},{"name":"dbt"},{"name":"DbVisualizer"},{"name":"Emacs"},{"name":"Tableau"},{"name":"Power BI"},{"name":"Superset"},{"name":"R"},{"name":"Hadoop"},{"name":"S3"},{"name":"Cassandra"},{"name":"MySQL"},{"name":"Elasticsearch"},{"name":"Fugue","category":"data_processing"},{"name":"Logi Symphony","category":"analytics"},{"name":"Mitzu","category":"product_analytics"},{"name":"DolphinScheduler","category":"workflow_scheduling"},{"name":"Cognos Analytics","category":"business_intelligence"},{"name":"MicroStrategy","category":"business_intelligence"},{"name":"JupySQL","category":"notebooks"},{"name":"SQuirrel SQL","category":"database_client"},{"name":"Zing Data","category":"analytics"},{"name":"Trino CLI","native":true,"category":"client"}]` |
| language.primary | C++ | Java |
| license.spdx | MIT | Apache-2.0 |
| market.availability | `{"hqCountry":"NL","primaryMarkets":[],"availabilityScope":"global","availableCountries":[],"notAvailableCountries":[]}` | `{"primaryMarkets":[],"availabilityScope":"global","availableCountries":[],"notAvailableCountries":[]}` |
| platform.support | `{"cli":true,"mac":true,"linux":true,"windows":true}` | `{"cli":true,"mac":true,"web":true,"linux":true}` |
| pricing | `{"type":"open_source","summary":"Free, open source under MIT license","freeTier":true,"sourceUrl":"https://duckdb.org","retrievedAt":"2026-08-14T15:30:03.636Z"}` | `{"type":"open_source","sourceUrl":"https://trino.io","retrievedAt":"2026-10-13T15:15:20.514Z"}` |
| pricing.free_tier | yes | yes |
| pricing.model | open_source | open_source |
| pricing.price_level | free | free |
| pricing.transparent | yes | yes |
| release.cadence_days | 33 | 45 |
| release.history | `[{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.5.6","date":"2026-09-28T13:35:11Z","type":"stable","version":"v1.5.6"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.5.5","date":"2026-07-22T10:51:50Z","type":"stable","version":"v1.5.5"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.5.4","date":"2026-06-17T10:45:53Z","type":"stable","version":"v1.5.4"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.4.5","date":"2026-06-17T10:42:38Z","type":"stable","version":"v1.4.5"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.5.3","date":"2026-05-20T11:50:43Z","type":"stable","version":"v1.5.3"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.5.2","date":"2026-04-13T10:46:51Z","type":"stable","version":"v1.5.2"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.5.1","date":"2026-03-23T12:10:58Z","type":"stable","version":"v1.5.1"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.5.0","date":"2026-03-09T12:40:59Z","type":"stable","version":"v1.5.0"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.4.4","date":"2026-01-26T12:08:09Z","type":"stable","version":"v1.4.4"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.4.3","date":"2025-12-09T10:20:40Z","type":"stable","version":"v1.4.3"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.4.2","date":"2025-11-12T13:04:29Z","type":"stable","version":"v1.4.2"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.4.1","date":"2025-10-07T10:29:57Z","type":"stable","version":"v1.4.1"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.4.0","date":"2025-09-16T10:17:31Z","type":"stable","version":"v1.4.0"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.3.2","date":"2025-07-08T10:39:09Z","type":"stable","version":"v1.3.2"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.3.1","date":"2025-06-16T13:54:58Z","type":"stable","version":"v1.3.1"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.3.0","date":"2025-05-21T16:04:19Z","type":"stable","version":"v1.3.0"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.2.2","date":"2025-04-08T08:44:15Z","type":"stable","version":"v1.2.2"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.2.1","date":"2025-03-05T18:03:02Z","type":"stable","version":"v1.2.1"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.2.0","date":"2025-02-05T13:57:07Z","type":"stable","version":"v1.2.0"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.1.3","date":"2024-11-04T13:59:58Z","type":"stable","version":"v1.1.3"}]` | `[{"url":"https://github.com/trinodb/trino/releases/tag/483","date":"2026-07-18T01:28:57Z","type":"stable","version":"483"},{"url":"https://github.com/trinodb/trino/releases/tag/482","date":"2026-06-25T19:22:28Z","type":"stable","version":"482"},{"url":"https://github.com/trinodb/trino/releases/tag/481","date":"2026-05-12T01:03:57Z","type":"stable","version":"481"},{"url":"https://github.com/trinodb/trino/releases/tag/480","date":"2026-03-24T23:06:31Z","type":"stable","version":"480"},{"url":"https://github.com/trinodb/trino/releases/tag/479","date":"2025-12-15T03:19:30Z","type":"stable","version":"479"},{"url":"https://github.com/trinodb/trino/releases/tag/478","date":"2025-10-29T18:42:57Z","type":"stable","version":"478"},{"url":"https://github.com/trinodb/trino/releases/tag/477","date":"2025-09-25T00:32:51Z","type":"stable","version":"477"}]` |
| reliability.status_page | yes | - |
| security.scorecard | - | 5.6 |
| security.vulnerabilities | `{"count":0,"source":"https://advisories.ecosyste.ms/api/v1/advisories?ecosystem=conda&package_name=python-duckdb&per_page=100","last_12m":0,"max_severity":null}` | `{"count":0,"source":"https://advisories.ecosyste.ms/api/v1/advisories?ecosystem=maven&package_name=io.trino%3Atrino-jdbc&per_page=100","last_12m":0,"max_severity":null}` |

## Capabilities (Data Warehouse Software)

| Capability | DuckDB | Trino |
|---|:--:|:--:|
| **Deployment** |  |  |
| Deployment | Embedded | Self-hosted |
| **Architecture** |  |  |
| Architecture | - | Coupled MPP |
| Compute model | - | Clusters |
| **Query** |  |  |
| SQL dialect | Vendor-specific | ANSI SQL |
| Federation / lakehouse query-in-place | ✓ | ✓ |
| **Interoperability** |  |  |
| Table-format support | Parquet, CSV, JSON, Iceberg, Delta Lake, Vortex, DuckLake, Lance, Arrow, Avro, E | - |
| **Scale** |  |  |
| Concurrency scaling | - | - |
| **Ingestion** |  |  |
| Streaming ingest | - | - |
| **Data model** |  |  |
| Semi-structured (JSON/VARIANT) | Functional | - |
| **Analytics** |  |  |
| ML / in-DB functions | ✓ | - |
| **Sharing** |  |  |
| Data sharing / marketplace | - | - |
| **Licensing** |  |  |
| Licence class | Permissive OSS | Permissive OSS |

*Source: vioscaleAI. Generated 2026-10-16T21:24:25.722Z. "-" = undocumented, not absent.*