Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

PrestoDB

prestodb.io

  • Free plan
  • Open source
  • macOS
  • Linux
  • Web
  • API
  • Self-hosted
8.2 Club score Visit prestodb.io

What PrestoDB is

PrestoDB is a free, open-source distributed SQL query engine for querying large datasets across different data systems. It uses connectors and a standard API to query sources such as Hive, Iceberg, Kafka, Cassandra, MongoDB, MySQL, PostgreSQL, BigQuery, Redshift, and SQL Server. Queries run across a coordinator and worker nodes. The project provides a server tarball, command line interface, JDBC driver, and Docker container, with installation guidance for Docker, Helm, and Homebrew. Security documentation covers Kerberos, LDAP, password-file and OAuth 2.0 authentication, access control, and secure internal communication; SSL/TLS can protect communication between cluster nodes. Presto is self-hosted and governed as an independent open-source project under the Linux Foundation. The project directs users to its Slack community to connect with engineers and other users. Its documentation cautions that SQL familiarity does not mean Presto has the features of a standard database, so users should assess whether a query engine meets their needs. The getting-started page identifies version 0.299 as the current release, dated August 31, 2026.

Who it suits

It suits teams that need to query large datasets spread across heterogeneous data sources and can manage a self-hosted deployment. It may be less suitable for someone seeking a standard database rather than a query engine.

Good to know, and what to watch

  • Free and open source
  • Connectors cover a range of data systems
  • Offers Docker, Helm, and Homebrew deployment guidance
  • Documents multiple authentication and access-control options
  • Horizontal scaling is supported
  • Self-hosted deployment
  • Documentation cautions it is not a standard database
  • Requires users to assess whether a query engine fits their needs

PrestoDB

Free

Presto open-source distribution

Free

Open source

The verdict

PrestoDB is a self-hosted option for distributed queries across multiple data systems, with documented connectors and security controls. Keep its distinction from a standard database in mind when evaluating it.

What the maker publishes

Analytics focus
Presto targets OLAP workloads such as analysis, aggregation and reporting rather than OLTP database transactions. source
Authorization
Presto includes built-in system access control options for allowing all operations, read-only operations, or file-based rules. source
Built-in connectors
Built-in connectors include JMX, System, Hive and TPC-H, with additional connectors supplied by third parties. source
Client libraries
Official documentation covers Java/JDBC, Python, Go and JavaScript clients, plus CLI usage. source
Company facts
The project is governed by the Presto Foundation, a Linux Foundation project; no standalone commercial headquarters or employee count is stated on the official Presto pages reviewed. source
Connector ecosystem
Documentation lists connectors for systems including BigQuery, Cassandra, ClickHouse, Delta Lake, Druid, Elasticsearch, Hudi, Iceberg, Kafka, MongoDB, MySQL, Oracle, PostgreSQL, Redis, Redshift, SQL Server and others. source
Connectors
The documentation lists connectors for systems including Hive, Iceberg, Kafka, Cassandra, MongoDB, MySQL, PostgreSQL, BigQuery, Redshift, and SQL Server. source
Current release
The getting-started page identifies version 0.299 as the current release and dates it August 31, 2026. source
Current release
The getting-started page identifies Presto 0.299 as the current release dated August 31, 2026. source
Custom connectors
Developers can implement connectors through Presto's connector SPI and connector factory interfaces. source
Deployment
The project provides a server tarball, command line interface, JDBC driver, and Docker container for getting started. source
Developer extensibility
The developer guide documents custom connectors, functions, procedures, types, system access control, authenticators, event listeners and request filters. source
Docker deployment
The project publishes a prestodb/presto Docker image and provides configuration and run instructions. source
Documentation depth
The documentation covers installation, clients, security, administration, caching, optimization, connectors, SQL, REST, troubleshooting, releases and developer APIs. source
Federated querying
A single SQL query can access data lakes, lakehouses, NoSQL systems and relational databases through connectors. source
Founded
2012 source
Governance
The Presto Foundation was established under the Linux Foundation with Facebook, Alibaba, Twitter and Uber as founding members. source
Internal encryption
Communication between Presto cluster nodes can be secured with SSL/TLS. source
JDBC driver
The JDBC driver is distributed as a Maven Central artifact and supports Java 8 or newer. source
License
The Presto repository identifies the project license as Apache License 2.0. source
Limit: incomplete transactional scope
G2 reviewers note limited transaction support and that Presto often needs other tools to fill product gaps. source
Limit: integration effort
G2 reviewers report that connecting databases can be tedious, slow or prone to intermittent errors during table refreshes. source
Limit: large fact joins
A TrustRadius reviewer says Presto's memory-oriented design is not suited to large fact-to-fact joins. source
Limit: learning curve
G2 reviewers repeatedly describe setup, distributed-system concepts and design decisions as difficult to learn. source

Checked against the maker's pages on 15 Oct 2026.