Productivity tools for T-SQL in VS Code: schema-aware completion, snippets, formatting, code analysis, refactoring and query execution, plus a database dashboard and a profiler. Free and open source.
Or search the Extensions view for RashikTuladhar.sql-buddy. Open VSX serves editors built on VS Code that do not use the Microsoft Marketplace.
Its own connections, its own results grid, and no other extension needed.
Tables, columns, procedures and functions from your schema. Joins built from foreign keys, aliases added for you, SELECT * expanded.
52 built in, such as ssf, ij and cte. Type the shortcut and press Tab. Add your own and share them with your team through a folder.
Four built-in styles and your own. Separate commands for casing, brackets, semicolons and qualified names.
40 rules checked as you type: UPDATE without WHERE, non-sargable predicates, unknown columns and more, many with a quick fix.
Encapsulate as stored procedure, inline a procedure, script as ALTER, Smart Rename, Split Table and Find Invalid Objects.
F5 runs the file, the selection or the statement. Several result sets, messages, export to CSV or JSON, history.
Sizes, backups, risky settings, expensive queries, query plans, deadlocks and index suggestions, each with a script to review.
Watch queries as the server finishes them, with duration, CPU, reads and errors. Filter, sort and export the trace.
Tabs coloured by connection, red for production. A confirmation before DELETE without WHERE, DROP or TRUNCATE.
Save connections in the side bar and browse databases, tables, views, procedures and functions down to columns and parameters.
Right-click a connection or database and choose Show Dashboard to see how the database is doing.
The query plan is drawn step by step, with what each step does and ways to cut its cost, each with a script to review before you run it.
Pick what to capture and press Start. Queries appear as the server finishes them, with text, database, login, application, duration and, where the server records them, CPU, reads, writes, rows and errors.
Problems are underlined in the editor and listed in the Problems view. Set the severity of each rule, or silence one place with a comment.
Go to Definition opens a procedure, view or function read-only. Edit as ALTER above it opens an editable copy that changes the object when run.
Results open beside the query, below it, or in a view in the panel that you can drag anywhere. Copy cells, copy a column as an IN (...) list, script rows as INSERT.
Every engine can be connected, browsed and queried. The T-SQL tools cover SQL Server and Azure SQL.
| Feature | SQL Server / Azure SQL | MySQL | PostgreSQL |
|---|---|---|---|
| Connections and schema browser | Yes | Yes | Yes |
| Table and column completion | Yes | Yes | Yes |
| Query execution and results | Yes | Yes | Yes |
| Database dashboard | Yes | Yes | Yes |
| Profiler | Yes | Yes | Yes |
| Drawn query plan | Yes | No | No |
| Formatting, analysis, refactoring | Yes | Not yet | Not yet |
From install to your first result in about a minute.
.sql file.SELECT * FROM and pick a table.SQL Buddy talks only to the database servers you connect it to. It sends no telemetry. Query history and snippets are stored on your machine, and passwords in the operating system's secret storage.
Use with care. SQL Buddy suggests and writes SQL, but you decide what runs. Read every statement before you run it, especially against production. The software is provided as is, without warranty of any kind.