PrestoDB
prestodb.io
- Free plan
- Open source
- macOS
- Linux
- Web
- API
- Self-hosted
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
Plans
Every plan and pricePrestoDB
Presto open-source distribution
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.