Back Original

Ultorg: The User Interface for Relational Databases

Screenshot of Ultorg, showing Customers, Orders, and Line Items in a sample PostgreSQL database.

Ultorg is an efficient, spreadsheet-like UI for relational databases. Query and edit data across tables and relationships, without SQL or custom CRUD apps. Watch the conference talk.

Download Ultorg

MacOS | Windows | Linux

Explore, combine, query, and edit data in spreadsheets and relational databases:

Profile Photo

Matías Fernández

@matias__eduardo

Logo X

@ultorg is the most mind blowing database tool I have ever seen. The way it can visualize multiple joins feels canonical in the sense that now, when I run complicated SQL queries, *that’s* the format I use to imagine the results. vimeo.com/695905306

Profile Photo Logo X

Jaw dropping talk on a way to view SQL databases without writing a custom app.

Profile Photo Logo X

This presentation by @eirikbakke on a generic UI abstraction to navigate a relational database is the most exciting bit of interaction design I've seen in a long, long time.

Profile Photo Logo X

The future never came: I expected dynamic multi-dimensional spreadsheet to sooner or later become the norm ever since I saw Lotus Improv.

“Harmonic is building mathematical superintelligence. Deep, detailed analysis of our system's outputs is crucial for rapid advancement of our research agenda. Ultorg provides, by far, the best tool for visualizing and investigating our data. It is an invaluable tool for our research.”

—Tudor Achim, co-founder and CEO, Harmonic

Table Icon

Screenshot of Ultorg combining three database tables into a single joined perspective, with a formula being edited.

Join Icon

One-to-Many Icon

Screenshot of Ultorg combining data from many tables, and two data sources, into a single form-like view

One-to-many relationships also occur inside database queries, when grouping on fields to calculate sums or averages, or when nesting one query within another. Ultorg will visualize each stage of such data flows.

For example, you can see the individual values that contribute to a group-wise sum. This lets you audit the query visually. You can tweak filters and calculations in the input, while gaining confidence in the aggregated totals.

Filter Icon

Ruler Icon

Ultorg's typographical engine can visualize records and one-to-many relationships using a combination of general-purpose strategies, such as nested tables, forms, and crosstabs.

Ultorg's visual data layouts are analogous to the hand-designed user interface screens you might see in traditional, tailored database applications. But in Ultorg, they are available immediately, for any data, without custom programming.

Screenshot of a crosstab layout generated by Ultorg, with one-to-many relationships visible inside each crosstab cell

Pencil Icon

Connect to Your Data, Right Now

Start Ultorg and connect immediately to your data source. No “cloud” required; all data stays private on your computer or corporate network.