JustyBase Core
Zero Config Netezza / PureData tools inside Visual Studio Code
Connect to IBM Netezza without ODBC drivers, run queries, browse schema, export data, and use AI-assisted SQL workflows in one VS Code extension.
(VS Code extension overview)
AI Copilot for SQL work
Use @sql-copilot and database-aware tools to explain, fix, optimize, and generate SQL directly in VS Code.
-- Ask Copilot for schema-aware help
@sql-copilot /schema orders
-- Optimize a query with database context
@sql-copilot /optimize
SELECT
customer_id,
SUM(amount) AS total_amount
FROM
sales
WHERE
sale_date >= CURRENT_DATE - 7
GROUP BY
customer_id
ORDER BY
total_amount DESC;
Privacy confirmations and feature switches let you control when schema or query context is sent to AI services.
What the extension gives you
Zero-config Netezza
Connect with host, user, password, and database. The extension ships with its own TypeScript driver.
Schema Browser
Explore databases, schemas, tables, views, procedures, sequences, and rich metadata from the sidebar.
Query Execution
Run selection or batch, cancel long queries, inspect explain plans, and keep per-tab connections.
Import & Export
Export results to CSV, JSON, XML, Markdown, SQL INSERT, XLSX, or XLSB and import CSV or Excel data.
Monitoring & ERD
Open session dashboards, inspect resources, compare objects, and generate ER diagrams.
Favorites & History
Reuse SQL snippets, manage favorites, and search persistent query history with filters and tags.
Built for daily VS Code workflows
The homepage stays simple, but the extension covers advanced database work when you need it.