github.com/brimsec/brim ↗

About brimsec/brim

Zui is a desktop application built with Electron and TypeScript that serves as the official front-end for SuperDB, a system designed for exploring and analyzing data with advanced type information and structure awareness. The application enables users to ingest data through drag-and-drop functionality with automatic format detection and schema inference, supporting formats like CSV, JSON, Parquet, Arrow IPC streams, and security logs from tools like Zeek. Once data is loaded into local SuperDB pools, users can query and transform it using SuperSQL, a query language designed to work with heterogeneous and deeply nested data structures.

The application provides an intuitive interface for data exploration with beautiful result views that adapt to whether data is nested or tabular, keyword search capabilities, named queries with version history, and session tracking to maintain work context. Additional features include right-click context menus for pivoting and filtering operations, pinnable query fragments to organize complex searches, and a JSON inspector for examining complex data structures. Behind the scenes, the app runs a local SuperDB server instance that handles the heavy lifting of data storage, indexing, and querying.

The project is organized as a monorepo using Nx and includes several standalone packages alongside the main desktop application, including a JavaScript library for SuperDB data types, a Node.js client library, and an end-to-end testing framework. The project welcomes community contributions and maintains active support resources and a public Slack community for users.