Oracle SQL & SQL Server Query Client (MSSQL, T-SQL, PLSQL, Oracle Database Tool)

Oracle SQL & SQL Server Query Client (MSSQL, T-SQL, PLSQL, Oracle Database Tool), a VS Code extension by Zovo

A free Oracle SQL client and SQL Server client (MSSQL, Azure SQL) in one extension. Run T-SQL and PLSQL with Ctrl+Enter, see PRINT and DBMS_OUTPUT lines, browse tables and procedures, cancel long queries and export millions of rows to CSV. It works in VS Code, Cursor and Windsurf. No sign-in, no account, no subscription.

Free, MIT license. Needs VS Code 1.90.0 or newer. Extension ID zovo.zovo-oracle-sqlserver-client, version 0.2.1.

Network: the extension connects only to the database servers you add, and only when you expand a connection or run a query. It sends no telemetry, makes no update check and calls no license server. It never runs a keep-alive or polling query. Passwords and tokens go to VS Code's secret storage, never to settings or logs.

Questions people ask

Why this one

Measured against complaints in recent reviews of other SQL Server and Oracle extensions on the Marketplace (dates are review dates). The numbers on the right come from the real-app test of this version, on VS Code 1.142.0 with SQL Server (Azure SQL Edge) and Oracle Database 23ai Free in local containers.

Features (free)

• SQL Server and Azure SQL through tedious (pure JavaScript):
• SQL login, Windows login (NTLM, with a domain) and Azure AD access tokens.
• Encrypt, strict (TDS 8.0) or off, plus "Trust the server certificate". Named instances.
• Paste an ADO.NET string, a JDBC URL or sqlserver://user@host:1433/db to fill the form.
• Oracle Database through node-oracledb in Thin mode (pure JavaScript, no Oracle Instant Client):
• Easy Connect (host:1521/service), SID, or a full (DESCRIPTION=...) string.
• tnsnames.ora aliases from TNS_ADMIN or a folder you pick.
• Wallet folders for Autonomous Database (ewallet.pem), and SYSDBA and the other admin roles.
• Database Explorer, loaded level by level:
• SQL Server: databases, schemas, tables, views, procedures and functions.
• Oracle: schemas, tables, views, procedures, functions and packages (invalid ones marked).
• Columns with types and keys, indexes, and row counts from the statistics.
• "Script as CREATE" for any table, view, procedure, function or package.
• "New Query: SELECT TOP 100 / FETCH FIRST 100" on any table.
• Query editor for any .sql file:
• Ctrl+Enter runs the statement or GO batch at the cursor, or the selection. Ctrl+Alt+Enter runs the whole file.
• T-SQL: GO and GO 5 split batches, so DECLARE, temp tables and PRINT behave as in other SQL Server tools.
• Oracle: ; ends SQL statements. PL/SQL blocks and CREATE PROCEDURE, PACKAGE or TRIGGER end at a line with /. Scripts copied from SQL*Plus keep working: SET SERVEROUTPUT ON, PROMPT and similar lines are handled.
• Every result set gets a tab: a batch with 20 SELECTs, or a procedure that returns 20 results, shows 20 tabs.
• The Messages tab shows PRINT lines, DBMS_OUTPUT.PUT_LINE output (on by default per session) and row counts.
• An error underlines the right place in your SQL: the line of a T-SQL error, the column of an Oracle error, and the line and column of a PL/SQL compile error.
• Autocomplete knows your tables, views, columns and aliases, plus T-SQL and Oracle keywords.
• Results grid: virtual scroll, the first 1,000 rows at once, more on scroll or Load more.
• Sort and filter run on the server when not every row is loaded.
• Copy as CSV, TSV, JSON or Markdown.
• Large text, CLOB and binary cells show a preview. Click one to open the full value.
• Cancel stops the running statement on the server: a TDS attention for SQL Server, a break for Oracle.
• Export: CSV, JSON or SQL INSERT, for a result or a whole table, streamed to the file.
• Safety:
• A read-only switch per connection, enforced by the server. Oracle opens the session read-only (23ai and later; older versions get a read-only transaction). SQL Server runs each batch in a transaction that is rolled back.
• Obvious writes are refused before they are sent, with a clear message.
• UPDATE or DELETE without WHERE, TRUNCATE and DROP ask before they run.
• A 10-second connect timeout with a clear message, and a clear message for a wrong password, a refused port or an unknown service name.
• Edit rows of a table opened from the explorer when it has a primary key. You review the exact SQL first, and it runs in one transaction.
• Query history, kept on this computer.

Zovo Pro

These tools are ready and free in this version: execution plan (SQL Server estimated showplan or Oracle EXPLAIN PLAN, as a tree with costs), schema compare between two connections, ER diagram saved as SVG, DDL export of a whole schema to one .sql file, and a saved query library. If they ever move to Zovo Pro, it will be a one-time price (USD 19 for every Zovo extension), with no ads and no nag. Everything in "Features (free)" stays free.

Getting started

1. Open the "Oracle & SQL Server" view in the activity bar and click Add Connection.
2. Pick SQL Server or Oracle. Paste a connection string or fill in the form, then click Test connection. It shows how long the connection took.
3. Click New Query on the connection, type SQL and press Ctrl+Enter (Cmd+Enter on macOS).

The status bar shows which connection a .sql file runs on. Click it to change.

Settings

Privacy

• Connections to the database hosts you add, and nothing else. No telemetry, no analytics, no update check, no license server.
• Passwords, access tokens and wallet passwords live in VS Code's secret storage.
• The query history and saved queries stay in VS Code's storage on this computer.

Not supported yet

• Kerberos and Azure AD interactive sign-in for SQL Server. Use SQL login, NTLM or an access token.
• Oracle native network encryption without TLS, and Oracle Thick-mode features (for example LDAP naming). Thin mode covers Easy Connect, TNS aliases and wallets.

License

MIT. Third-party packages and their licenses are listed in THIRD-PARTY-NOTICES.md.