JustyBase SQL Editor

Multi-database SQL, sharpened for VS Code

One workspace.Many databases.

A professional SQL workspace for Netezza, Db2, MS SQL Server, Oracle, PostgreSQL, MySQL, Access, and Files. Connect, write, validate, explore, and move data without leaving the editor you already use.

Install from Marketplace Explore on GitHub

Netezza core needs no external ODBC driver; optional packs bring their own runtimes.

JustyBase / SQL workspace connected
JustyBase workspace with a schema browser, SQL editor, and result panel
Parser-backedSQL diagnostics
Ready to queryDatabase connection active
VS Code nativeSQL, schema, and results in one workspace
Multi-databaseOne shared workspace across your stack
Deep Db2 supportParser, metadata, maintenance, and quality workflows
Open sourceInspect the project and shape its future

Your database stack

One editor for many database workflows.

Start with the connection you have today and keep the same familiar shell for the systems around it. Netezza remains a first-class core experience, while companion packs add dedicated support where your team needs it most.

Dedicated support pack

Db2 LUW

Dedicated parser, metadata, maintenance, import/export, explain, and quality workflows for everyday Db2 work.

Explore Db2 support
Core

Netezza

Deep Netezza SQL/LSP support, schema intelligence, NZPLSQL analysis, warehouse workflows, and a built-in JavaScript driver.

Companion pack

Oracle

Dialect-aware parsing, metadata, DDL, explain tooling, and database-specific authoring workflows.

Companion pack

PostgreSQL

Dialect-aware parsing, metadata, DDL, explain tooling, and database-specific authoring workflows.

Companion pack

MS SQL Server

Bring connection, schema, query, result, and export workflows to Microsoft SQL Server.

Companion pack

MySQL

Bring connection, schema, query, result, and export workflows to MySQL.

File support

Microsoft Access

Open, query, and edit MDB/ACCDB data through the native TypeScript reader and embedded DuckDB mirror.

Local data

Files / DuckDB / SQLite

Query Excel, CSV, Parquet, Avro, and Access files like tables, then explore and export the result in the same grid.

Connection panels, schema browsing, result grids, and export workflows are shared; editor depth varies by dialect and support pack.

One workspace, fewer handoffs

Built for teams that work across databases.

Keep the database context, SQL authoring, operational workflows, and result analysis close together. JustyBase turns VS Code into a focused home for the work between a question and a trusted answer.

Connect in minutes

Save connections securely in VS Code secrets and start browsing databases, schemas, tables, views, and procedures wherever they live.

Write safer SQL

Use completion, formatting, semantic context, and parser-backed diagnostics while your query is still taking shape.

Explore the result

Profile columns, inspect distributions, build pivots, chart patterns, filter large result sets, and export what matters.

Operate with context

Generate DDL, compare objects, inspect sessions, maintain tables, build ERDs, and keep repeatable workflows close at hand.

See it in action

Less context switching. More useful work.

Explore the workflows that make JustyBase more than a query runner. Every panel is designed to keep the database close to the decision you are making.

01 / START

Go from a fresh install to a live schema.

Open the JustyBase view, connect to Db2, Netezza, or another supported database, and browse the objects you need without leaving VS Code. Connection credentials stay in the editor's secrets storage.

Read the getting started guide
Connecting to a supported database and opening the JustyBase workspace
Connect, browse, and keep your working context in one place.
02 / AUTHOR

Catch mistakes before they cost a run.

Diagnostics explain what is wrong and quick fixes help you move from warning to corrected SQL with less friction.

Explore SQL diagnostics
A SQL diagnostic and quick fix in the editor
03 / COMPOSE

Build joins visually, then keep the SQL.

Drag sources onto a canvas, connect columns, add filters and aggregations, and open the generated query in the editor.

Open the Query Builder guide
Visual Query Builder creating a joined SQL query
04 / UNDERSTAND

See the shape of your data.

Move from a result grid to profiles, distributions, summaries, pivots, charts, and time-based views without writing another exploratory query.

Learn about result exploration
Using the JustyBase schema browser and SQL results workspace
05 / MOVE

Export insight in the format your team needs.

Send query results to XLSB/XLSX, CSV, JSON, XML, SQL INSERT, Markdown, or Parquet with streaming and cancellation support.

See export and import options
Exporting a query result to an Excel workbook
06 / MODEL

Make structure visible.

Generate ERDs and visual workflows so relationships, dependencies, and repeatable data movement are easier to discuss.

Explore visual workflows
Visualizing database relationships and workflows in JustyBase

Query to insight

Your result set is the start of the analysis.

The results workspace gives you practical ways to understand what came back before you export it or hand it to someone else.

  • Filter, sort, search, and compare result sets.
  • Inspect types, cardinality, null counts, and distinct values.
  • Build pivots, charts, distributions, and time-based views.
  • Export full results, not just the visible grid window.
Explore data workflows
Interactive chart built from a JustyBase query result
Result explorer with profiles and data summaries
GitHub Copilot assisting with SQL in JustyBase

AI with explicit control

Bring assistance into the workflow. Keep the decision yours.

Optional Copilot workflows can explain, fix, optimize, or generate SQL while you remain in control of the final query and execution.

Transparent by designPrivacy confirmations appear before supported AI actions transmit SQL or metadata to Microsoft/GitHub services.
Read the Copilot SQL Assistant guide

Ready when you are

Install once. Query with confidence.

Bring your database workflows into VS Code and keep the path from SQL to insight in one familiar place.

code --install-extension krzysztof-d.justybaselite-netezza
Open Marketplace View source