Trilogy Studio

The Easiest Way to Trilogy

Trilogy Studio is available as a free webapp. An integrated tutorial covers usage.

We don't want to be exclusive about IDEs - long term, Trilogy can be embedded in the great existing IDEs out there, and top-notch VS code support is a priority - but it's hard to get a feel for the language without a good native editing experience.

Trilogy Studio aims to provide that by building a Trilogy-native data studio, featuring:

• Native Trilogy editors, with autocomplete
• Fast, interactive visuals
• Model reuse and sharing

Trilogy Studio currently supports the following analytic DBs

• DuckDB
• Bigquery
• Snowflake

The IDE is MIT licensed and source is available on github.

A Trilogy/SQL IDE

Trilogy Studio is a streamlined online IDE for writing, compiling, and executing Trilogy and SQL code. It is designed to be a fully-functional demonstration of core trilogy value propostiions, from writing and testing queries to creating and extending custom models. Trilogy Studio is built on top of the Monaco Editor - which powers VS code and provides a rich editing experience with shortcuts, a command palette, and syntax highlighting - and Vega, a 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!

Features

• Execute Trilogy queries directly in an IDE and get results
• Execute SQL queries directly for comparison and development
• Query new models as you author them
• LLM integration for fast query generation