Open-source tools for database development and high-performance spreadsheet processing.
JustyBase builds practical developer tools in two connected areas:
- Database tooling — Netezza-first SQL clients, VS Code integrations and a pure .NET driver.
- Spreadsheet tooling — fast, lightweight libraries for reading and writing XLSX and XLSB files in TypeScript, .NET and Python.
| Project | Description |
|---|---|
| JustyBase Core for VS Code | Netezza-first SQL development in Visual Studio Code: built-in JavaScript connectivity, SQL authoring, schema exploration, query execution, import/export, monitoring, ETL workflows, notebooks and optional database packs. |
| JustyBase desktop | Cross-platform SQL IDE for IBM Netezza Performance Server, built with Avalonia UI and .NET 10. Includes SQL editing, schema exploration, Git-aware workflows, data tools and optional local AI assistance. Downloads |
| JustyBase Legacy | Windows desktop SQL client for IBM Netezza / PureData, with a SQL editor, object explorer, virtualized results grid, encrypted connection profiles and installer releases. Downloads |
| nzpy_extended | High-performance IBM Netezza Python driver with a C extension, synchronous and asynchronous APIs, connection pooling, streaming bulk load and pre-built wheels. |
| Project | Description |
|---|---|
| JustyBase.NetezzaDriver | Pure C# ADO.NET driver for IBM Netezza Performance Server — no native dependency or ODBC bridge, with sync/async APIs, pooling, transactions, SSL/TLS and catalog introspection. |
| @justybase/netezza-driver | Pure TypeScript Netezza / PureData driver for Node.js with connection pooling, SSL and an ADO.NET-style Connection/Command/Reader API. |
| JustyBase.NetezzaSql | .NET libraries for Netezza SQL parsing, authoring, DDL generation and catalog metadata queries. |
| dbeaver-netezza-tools-plugin | DBeaver extension for clipboard and Excel import/export, table creation and Netezza-friendly DDL. |
Netezza / PureData is the first-class target. The extension also offers optional companion support for PostgreSQL, Db2 LUW, DuckDB and Oracle through the shared JustyBase workspace.
Core capabilities include:
- SQL completion, formatting, diagnostics and linting;
- Netezza and NZPLSQL-aware language tooling;
- schema browser, metadata search and DDL generation;
- result grid, Excel/CSV/JSON/Parquet export and data import;
- query history, SQL notebooks, ERD, ETL designer and monitoring;
- optional GitHub Copilot features for SQL analysis, generation and optimization.
The Avalonia/.NET 10 desktop application brings the same data-first focus to a native cross-platform workspace. Netezza is the current supported database focus; other engines are represented in the plugin architecture but remain work in progress.
Core capabilities include:
- SQL editor with syntax highlighting, folding, autocomplete and Quick Open;
- schema exploration and multi-connection database work;
- Git status, staging, history, diffs and commit workflows;
- result grouping, filtering and export to Excel, CSV and Parquet;
- optional local AI through embedded FIM, Ollama or LM Studio;
- Native AOT release packages for Windows x64, Linux x64 and macOS ARM64.
Download the latest desktop packages from the JustyBase Releases page.
| Project | Ecosystem | Description |
|---|---|---|
| @justybase/spreadsheet-tasks | TypeScript / Node.js | High-performance XLSB and XLSX reader/writer, published as an npm package. Includes streaming support, browser builds, multi-sheet workbooks, formatting and auto-filters. |
| SpreadSheetTasks | .NET | .NET library for fast XLSX/XLSB reading, writing and editing, including updating worksheet data and pivot-table source ranges. |
| xlspy | Python | Python library for efficient XLSB and XLSX processing, with read/write support, streaming-friendly APIs and cell formatting. |
- Practical over generic — tools designed around real SQL and data workflows.
- Netezza-first — deep support where it matters most, rather than shallow compatibility claims.
- Performance-conscious — especially for large result sets and large spreadsheet exports.
- Open source — repositories include their own documentation, licenses and contribution guidance.
Use the Issues section of the relevant repository for bug reports, feature requests and technical discussion.
Licensing is defined separately in each project repository.
