Skip to content

cmoog/vscode-sql-notebook

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Oct 13, 2023
87b95ae · Oct 13, 2023
Sep 20, 2023
Mar 30, 2022
Dec 15, 2021
Mar 23, 2022
Oct 13, 2023
Jul 21, 2022
Mar 22, 2022
Jul 21, 2022
Mar 30, 2022
Mar 23, 2022
Mar 30, 2022
Jul 21, 2022
Aug 14, 2021
Sep 8, 2023
Oct 13, 2023
Aug 1, 2023
Oct 13, 2023
Sep 18, 2023
Oct 13, 2023

Repository files navigation

VS Code SQL Notebook

Visual Studio Marketplace Installs GitHub Release

Open SQL files in the VS Code Notebook interface. Execute query blocks and view output interactively.

Screen Shot 2021-12-30 at 1 34 19 PM

Features

  • Open any .sql file as a Notebook.
  • Execute query blocks in the Notebook UI and view output.
  • Configure database connections in the SQL Notebook side-panel.
  • Supports MySQL, PostgreSQL, SQLite, and MSSQL (OracleDB support coming soon).
  • (unstable) Built-in typed auto-complete with an embedded language server.

Usage

Open any .sql file with the Open With menu option. Then, select the SQL Notebook format. Configure database connections in the SQL Notebook side-panel.

Screen Shot 2021-12-30 at 1 30 29 PM

Screen Shot 2021-12-30 at 1 30 39 PM

Screen Shot 2021-12-30 at 1 34 32 PM

FAQ

If the file is stored as a regular .sql file, how are cell boundaries detected?

Cell boundaries are inferred from the presence of two consecutive empty lines.

Note: this can pose issues with certain code formatting tools. You will need to configure them to respect consecutive newlines.