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 for VS Code | The primary JustyBase workspace: a Netezza-first SQL environment for Visual Studio Code. It provides zero-config connectivity through a built-in JavaScript driver, SQL authoring tools, schema exploration, query execution, import/export, monitoring, ETL workflows, notebooks and optional GitHub Copilot assistance. |
| JustyBase Legacy | A Windows desktop SQL client for IBM Netezza / PureData, built with .NET. It includes a SQL editor, object explorer, virtualized results grid, encrypted connection profiles and export capabilities. |
| JustyBase.NetezzaDriver | A pure C# ADO.NET driver for IBM Netezza Performance Server — with no native dependency or ODBC bridge. Supports synchronous and asynchronous APIs, pooling, transactions, SSL/TLS, query cancellation and catalog introspection. |
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.
| 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.
