Trilogy Studio

Fast, Flexible, Productive

Data exploration tooling that speeds you up - from initial query to long-term maintenance

Trilogy Studio is purpose-built IDE - and component library - to accelerate your analytics.

• Write less SQL, run it faster, and reuse what you write
• Refactor with confidence and ease
• Native language support, with syntax highlighting, auto-complete, and more
• Fast, interactive dashboards
• AI Native exploration experiences - optional but powerful

Connect directly to your cloud data in Bigquery or Snowflake - or use DuckDB to access any cloud or local structured data - and dive right into exploration.

Try a cloud hosted version here, and use the embedded docs and tutorials to get started.

Getting Started

Tips

You can also run the studio - and backing services - locally for a completely offline experience!

Native Semantic Layer

The shareable semantic layer provided by Trilogy gives you a single source of truth for all users (and AI). Stop trying to wrangle definitions and keep dashboards from rotting - update your layer in one place, and all resources automatically inherit it.

Rich Editing

Query Trilogy models directly, or use SQL for raw database access. Easily chart and visualize results.

The contains a guided tour which will walk you through navigation and interface.

Full-Featured Dashboarding

Assemble multiple queries together into dashboards with native interactivity and the full power of SQL for filtering.

Stop wrestling with complicated datasources and queries; connect your model and have a beautiful dashboard in minutes.

Supports all typical charts and widgets, with defaults that just work out of the box. Can be easily extended to support more as an open-source project.

Public Sharing

Build public dashboards and share them with others with a streamlined import feature. Download as PNGs for export and email.

AI Support

Love LLMs? Write queries and dashboards with your favorite LLM - just bring your own API key or try a demo key.

Hate AI? AI features are optional, and the metadata that powers them makes you - and your team - faster even if you skip AI.

Comparisons

Read more about Trilogy vs Looker Studio.

Support

Current support is focused on popular databases for analytics:

• DuckDB
• BigQuery
• Snowflake

Code

Trilogy Studio is open-source under the MIT license.

Explore - and star! on Github.

Contributions welcome!

The Stack

Trilogy Studio is a Vue app built on top of Monaco Editor - which powers VS Code - and Vega, a powerful modern visualization library.

Tips

Trilogy Studio is a simple way to run Trilogy directly against your databases, but it's not the only way! Don't forget you can run Trilogy directly from python or compile your Trilogy to SQL and run in your own favorite IDE.