Clients allow you to connect to Trino, submit SQL queries, and receive the results. Clients can access all configured data sources in catalogs. Clients are full-featured applications or libraries and drivers that allow you to connect to any applications supporting that driver or even your own custom application or script.
Clients include command line tools, desktop applications, web-based applications, and software-as-a-service solutions with features such as interactive SQL query authoring with editors or rich user interfaces for graphical query creation, query running and result rendering, visualizations with charts and graphs, reporting, and dashboard creation.
Clients can also process the returned data from Trino and be used for data pipelines across catalogs, and also from other data sources to Trino catalogs.
Airflow™ is a platform created by the community to programmatically author, schedule, and monitor workflows.
Apache DolphinScheduler is an open-source, distributed workflow scheduling platform designed to manage and execute batch jobs, data pipelines, and ETL processes. DolphinScheduler enables users to create and manage consecutive jobs run easily, including support for different types of tasks, such as SQL statements, shell scripts, Spark jobs, Kubernetes deployments, and many others.
Apache Superset enables users to consume data in many different ways: writing SQL queries, creating new tables, creating a visualization (slice), adding that visualization to one or many dashboards and downloading a CSV. SQL Lab is a a part of Superset and provides a rich SQL editor that enables users to both query and visualize data. You can explore and preview tables in Trino, effortlessly compose SQL queries to access data. From there, you can either export a CSV file or immediately visualize your data in the Superset “Explore” view.
The Trino CLI is a feature-rich command line interface tool for interactive query processing with Trino. The batch mode allows you to integrate the CLI with any other processing and automation that supports command line interactions.
Coginiti offers a comprehensive solution for data professionals, integrating essential functionalities such as modular development, version control, feedback mechanisms, testing capabilities, and documentation tools. By leveraging these features, analysts and data engineers can improve analytic consistency, increase productivity, and expedite the delivery of valuable insights.
Unlock a new data analytics paradigm with Coginiti’s full support for Trino, a game-changer in large-scale data querying.
Cube is headless BI for building data apps. You can use Cube to create an additional semantic layer or a last-mile caching layer on top of Trino. More importantly, you can use the set of APIs that Cube provides, including REST API, GraphQL API, and SQL API, to deliver the data directly to custom-built front-end applications as well as BI tools and notebooks, retaining low latency and high concurrency.
DBeaver is a cross-platform database tool for developers, database administrators, analysts, and everyone working with data. With DBeaver you are able to manipulate with your data like in a regular spreadsheet, create analytical reports based on records from different data storages, export information in an appropriate format. For advanced database users DBeaver suggests a powerful SQL-editor, plenty of administration features, abilities of data and schema migration, monitoring database connection sessions, and a lot more.
It is avaiable as free open source DBeaver Community and as various commercially supported DBeaver PRO editions. A web application version called CloudBeaver is also available. All editions support many databases, including Trino.
dbt is a transformation workflow that helps you get more work done while producing higher quality results. You can use dbt to modularize and centralize your analytics code, while also providing your data team with guardrails typically found in software engineering workflows. Collaborate on data models, version them, and test and document your queries before safely deploying them to production, with monitoring and visibility.
DbVisualizer is a universal database tool for querying, managing, and visualizing data, with a long history of being a top-performing Trino editor.
Use DbVisualizer to easily connect to and query your Trino catalogs. With extended support for Trino-specific object types, you can enjoy the full suite of smart features that DbVisualizer has to offer.
Elixir is a dynamic, functional language for building scalable and maintainable applications.
Elixir runs on the Erlang VM, known for creating low-latency, distributed, and fault-tolerant systems. These capabilities and Elixir tooling allow developers to be productive in several domains, such as web development, embedded software, machine learning, data pipelines, and multimedia processing, across a wide range of industries.
Use the req_trino to connect an Elixir script or application to a Trino cluster and receive the results of the submitted queries.
GNU Emacs, a versatile and extensible text editor, offers support for numerous programming languages and tools, including SQL. If you’re interested in using Emacs to work with SQL databases, the built-in sql-mode and sql-interactive-mode are your friends. To use it with Trino include the sql-trino.el mode.
Fugue provides an easier interface to using distributed compute effectively and accelerates big data projects. It does this by minimizing the amount of code you need to write, in addition to taking care of tricks and optimizations that lead to more efficient execution on distrubted compute. Fugue ports Python, Pandas, and SQL code to Spark, Dask, and Ray, and supports Trino.
Go is a statically typed, compiled high-level programming language. Use the Trino Go client to connect a Go applications to a Trino cluster and receive the results of the submitted SQL queries.
Grafana is a multi-platform open source analytics and interactive visualization web application. It provides charts, graphs, and alerts for the web when connected to supported data sources.
The Trino Grafana Data Source Plugin allows you to connect your Grafana dashboards to Trino and use the configured catalogs as data source.
Great Expectations is the leading tool for validating, documenting, and profiling your data to maintain quality and improve communication between teams.
Harlequin is a portable, powerful, colorful, easy, fast, and beautiful database client for the terminal. It runs on any shell, any terminal, and any machine.
Harlequin is free to download and you install it with pipx
or pip
and
the command install harlequin_trino
.
Hue is a mature open source SQL assistant for querying databases and data warehouses. It is used by Fortune 500 companies, and focused on smart query typing.
Ibis is a dataframe interface to execution engines with support for 15+ backends, including Trino. Ibis doesn’t replace your existing execution engine, it extends it with powerful abstractions and intuitive syntax. For those who love doing all their data-related work in Python, this allows you to write Python code that leverages the speed and power of Trino without needing to become a SQL master.
Cognos Analytics is a comprehensive business intelligence and performance management suite providing robust reporting, dashboards, data modeling and real-time monitoring, score carding, and predictive analytics. Cognos Analytics aims to empower users to collaborate, plan, and make smart decisions for better business results.
Applications using JavaScript, TypeScript, Node.js, and related frameworks can use the trino-js-client, presto-client-node, or lento projects to connect to a Trino cluster and receive the results of the submitted queries.
Java Database Connectivity (JDBC) enables applications running on the JVM to connect and query databases. Use the Trino JDBC driver with your application for the JVM, written in Java, Kotlin, or any other JVM language, or provided by your tool vendor.
DataGrip by JetBrains is an IDE for databases that is tailored to suit the specific needs of professional SQL developers. It is designed to work with databases installed locally, on a server, or in the cloud. It is installed as a local application on your workstation.
JupySQL allows you to run SQL and plot large datasets in Jupyter a %sql
,
%%sql, and %sqlplot magics. JupySQL is compatible with all major databases,
data warehouses, embedded engines, and of course also Trino.
Looker offers a unified business intelligence platform on Google Cloud. It is self-service and governance enabled, and can be embedded in your solution.
Metabase is an open source web based business intelligence platform. You can use Metabase to ask questions about your data, or embed Metabase in your app to let your customers explore their data on their own. More information is available in the driver project repository and the user guide.
MicroStrategy is a business intelligence tool that enables you to build up platforms that provide real-time data monitoring and can be accessed and controlled over any mobile device upon creation. It provides modern analytics on an open, comprehensive enterprise platform, and allows users to overlay actionable enterprise data on popular business applications to help users make smarter, faster decisions.
Mitzu is a warehouse-native product analytics platform that revolutionizes how companies leverage their product usage data in the data lake.
By directly connecting to Trino, Mitzu eliminates the need for traditional reverse ETL processes to 3rd party applications such as Amplitude or Mixpanel. Mitzu enables real-time self-served product analytics on top of the existing data infrastructure with generated SQL queries.
Mode is the modern business intelligence platform that unites data teams with business teams to build analytics that drive business outcomes.
Open Database Connectivity (ODBC) enables applications to connect and query databases. Use an ODBC driver with your own custom application, or with any other application that supports ODBC. ODBC drivers for Trino are available from Magnitude. Starburst customers receive an ODBC driver suitable for Starburst Enterprise and Starburst Galaxy.
PopSQL is a collaborative SQL editor for your team to write queries, visualize data, and share your results.
Power BI is an interactive data visualization software product suite developed by Microsoft with a primary focus on business intelligence.
Power BI users can query Trino clusters using a variety of available clients.
Python is a programming language that lets you work quickly and integrate systems more effectively. Use the Trino Python Client to connect a Python script or application to a Trino cluster and receive the results of the submitted queries.
Querybook is a browser-based data analysis tool that turns SQL queries into natural language reports and graphs called DataDocs. Querybook’s core focus is to make composing queries, creating analyses, and collaborating with others as simple as possible.
Quix is a multi-user, easy-to-use notebook manager.By utilizing Trino it provides unified access to multiple data sources and effectively acts as a shared space for your company’s BI insights and know-how.
Redash is a take on freeing the data within our company in a way that will better fit our culture and usage patterns. It has Trino support as well as other backends, and offers a query editor with syntax highlighting and completion, and creating visualizations and dashboards from query results.
Ruby is a dynamic, open source programming language with a focus on simplicity and productivity. Use the Trino Ruby client library to connect a Ruby script or application to a Trino cluster and receive the results of the submitted queries.
SQuirrel SQL is a Java-based graphical database client that allows you to view the structure of your database, browse the data in tables, and issue SQL commands. It uses JDBC to allow users to explore and interact with databases via a JDBC driver. In addition, it provides an editor that offers code completion and syntax highlighting for standard SQL.
Tableau is a visual analytics platform transforming the way we use data to solve problems—empowering people and organizations to make the most of their data.
Visual Studio Code (VSCode) is a free, open-source editor by Microsoft with features such as syntax highlighting, IntelliSense, code navigation, and built-in debugging for developers. With extensions it can also work as a SQL client.
Wren AI is a SQL AI Agent for data teams to get results and insights faster by asking business questions without writing SQL.
yanagishima is a web application for Trino. yanagishima provides the ability to execute query, show query, kill query, bookmark query, search table, share query/query result, format query, download as CSV/TSV file, insert chart, substitute query parameter, and so on.
Zing Data is a data analysis and collaboration platform with native apps on iOS, Android, and the web. Zing makes asking questions of data and visualizing answers easy for everybody in your organization. Free for small teams, and super-affordable for bigger ones, Zing requires no SQL, no desktop, and no instruction manual. Collaborate as easily as chatting, and integrate seamlessly with all the data sources you already have.