← JustyBase

Cross-platform desktop · Netezza-first

JustyBase. Desktop SQL, kept close to the data.

A cross-platform SQL IDE for IBM Netezza Performance Server, built with Avalonia UI and .NET 10. Write and run SQL, explore schemas, work with Git-backed files, inspect results, and use optional local AI assistance in one focused desktop workspace.

Windows x64 Linux x64 macOS ARM64 .NET 10 · Avalonia MIT
JustyBase SQL editor with schema explorer and query results in dark theme
SQL editor, schema explorer, and query results in one desktop workspace

01 / PRODUCT MODEL

Netezza is the current focus. The workspace is built to grow.

CURRENT FOCUS

IBM Netezza Performance Server

JustyBase combines Netezza-first SQL authoring, schema exploration, multi-connection work, result inspection, and data import/export in a native desktop application.

NETEZZA COREDESKTOP IDECROSS-PLATFORM
IN DEVELOPMENT

Additional database engines

PostgreSQL, Db2, Snowflake, Oracle, DuckDB, MySQL, and SQLite are represented in the plugin architecture, but the repository marks them as coming soon or work in progress.

PostgreSQLDb2SnowflakeOracleDuckDBMySQLSQLite
AI is opt-in: embedded FIM runs locally with a user-selected GGUF model. Ollama and LM Studio use local endpoints; remote AI providers receive only the context selected for the active request.

02 / DOWNLOAD

Choose your desktop.

Release builds are Native AOT packages for Windows x64, Linux x64, and macOS Apple Silicon. Windows also has an installer.

01
RECOMMENDED · WINDOWS

Windows installer

Velopack installer for Windows x64. The simplest way to install JustyBase on a regular desktop.

Download installer ↗
02
PORTABLE · WINDOWS

Windows ZIP

Portable Windows x64 package. Extract it and run without a traditional installation.

Download ZIP ↗
03
PORTABLE · LINUX

Linux x64 ZIP

Native AOT Linux x64 archive for a portable desktop setup.

Download Linux build ↗
04
PORTABLE · MACOS

macOS Apple Silicon ZIP

Native AOT package for macOS ARM64, intended for Apple Silicon Macs.

Download macOS build ↗
1

Download the package matching your operating system and architecture.

2

Run the Windows installer, or extract the portable ZIP on Linux or macOS.

3

Add a Netezza connection, open a SQL document, and start working.

Checking available release assets…

03 / FEATURES

A SQL workspace with useful edges.

Focused tools for the loop from SQL file to database result, with local-first assistance when you want it.

SQL editor

Syntax highlighting, folding, autocomplete, Quick Open, and Netezza-oriented authoring for everyday query work.

Schema exploration

Inspect database objects and connections without leaving the editor workspace.

Git-aware workflow

Review status, stage changes, inspect history and diffs, and commit SQL-backed work from the application.

Data tools

Group and filter results, then export data to Excel, CSV, or Parquet.

Optional local AI

Use embedded FIM with GGUF models, or connect to Ollama and LM Studio. AI features are disabled by default.

Native AOT

Release packages target fast, self-contained desktop startup across Windows, Linux, and Apple Silicon.

04 / IN THE WORKSPACE

See the workflow.

Product screenshots are served directly from the source repository.

JustyBase data import workflow in dark theme
Import workflow for moving data into the workspace
JustyBase settings view in dark theme
Settings and application configuration

Documentation & source

The README and docs in the product repository remain the source of truth for supported databases, AI privacy, architecture, builds, and contribution workflows.

JustyBase FAQ

What is JustyBase?

It is a cross-platform desktop SQL IDE focused on IBM Netezza Performance Server, with SQL editing, schema exploration, Git workflows, data tools, and optional local AI assistance.

Which operating systems are supported?

The release workflow packages Windows x64, Linux x64, and macOS ARM64 builds. The macOS package targets Apple Silicon.

Which databases are supported today?

Netezza is the current supported focus. Other engines are present in the plugin architecture but are marked in the repository as coming soon or work in progress.

Does AI send my SQL to a remote service?

AI is opt-in. Embedded FIM runs locally; Ollama and LM Studio use configured local endpoints. Remote provider behavior depends on the provider and the context you explicitly send.