Clients applications allow you to connect to Trino, submit SQL queries, and receive the results. Client applications can access all configured data sources in catalogs.
Client applications include command line tools, desktop applications, web-based applications, and software-as-a-service solutions. Common features are interactive SQL query authoring with editors, rich user interfaces for graphical query creation, query running and result rendering, visualizations with charts and graphs, reporting, and dashboard creation.
You can use client applications for data pipelines in Trino including across catalog. Client applications that support other data sources can be used in data pipelines connecting them with Trino catalogs.
Client applications use client drivers as wrappers around the client protocol or the client protocol directly.
Official client applications #
The following client applications are developed and maintained by the Trino community.
CLI #
Integration developed and maintained by the Trino community
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.
Grafana #
Integration developed and maintained by the Trino community
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.
Other client applications #
The following client applications are developed and maintained by other communities and vendors.
Apache Airflow #
Airflow™ is a platform created by the community to programmatically author, schedule, and monitor workflows.
Apache DolphinScheduler #
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.
Coginiti #
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 #
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 #
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 #
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 #
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.
Emacs #
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.
FugueSQL #
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.
Great Expectations #
Great Expectations is the leading tool for validating, documenting, and profiling your data to maintain quality and improve communication between teams.
Harlequin #
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 #
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 #
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.
IBM Cognos Analytics #
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.
JetBrains Datagrip #
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.
Jupy SQL #
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 #
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 #
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 #
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 #
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 #
Mode is the modern business intelligence platform that unites data teams with business teams to build analytics that drive business outcomes.
PopSQL #
PopSQL is a collaborative SQL editor for your team to write queries, visualize data, and share your results.
Power BI #
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.
Querybook #
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 #
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 #
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.
SQuirrel SQL #
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 #
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.
VSCode #
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.
waii #
Waii helps you build more intuitive data products and applications with the world’s most accurate text-to-sql, text-to-chart, and conversational business intelligence APIs.
Wren AI #
Wren AI is a SQL AI Agent for data teams to get results and insights faster by asking business questions without writing SQL.
yanagishima #
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 #
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.