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.
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. 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.
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 is the leading tool for validating, documenting, and profiling your data to maintain quality and improve communication between teams.
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.
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.
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.
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.
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.
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.
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 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.
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.