MCPcopy Index your code
hub / github.com/cmoog/vscode-sql-notebook

github.com/cmoog/vscode-sql-notebook @v0.7.0

Chat with this repo
repository ↗ · DeepWiki ↗ · release v0.7.0 ↗ · + Follow
87 symbols 155 edges 11 files 0 documented · 0%
What it actually does AI analysis from the code graph — generated when you open this
loading…
README

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.

Extension points exported contracts — how you extend this code

Pool (Interface)
(no doc)
src/driver.ts
LspConfig (Interface)
(no doc)
src/lsp.ts
Conn (Interface)
(no doc)
src/driver.ts
BaseConfig (Interface)
(no doc)
src/driver.ts
SqliteConfig (Interface)
(no doc)
src/driver.ts
MySQLConfig (Interface)
(no doc)
src/driver.ts

Core symbols most depended-on inside this repo

refresh
called by 5
src/connections.ts
writeErr
called by 3
src/controller.ts
writeSuccess
called by 3
src/controller.ts
setActive
called by 2
src/connections.ts
getPool
called by 2
src/driver.ts
sqlitePool
called by 2
src/driver.ts
start
called by 2
src/lsp.ts
createSqLitePool
called by 1
src/driver.ts

Shape

Function 50
Method 17
Class 12
Interface 8

Languages

TypeScript100%

Modules by API surface

src/driver.ts29 symbols
src/connections.ts10 symbols
src/controller.ts9 symbols
src/lsp.ts8 symbols
src/form.ts8 symbols
src/serializer.ts5 symbols
src/markdown.ts5 symbols
src/commands.ts5 symbols
webview/Form.tsx4 symbols
webview/main.tsx2 symbols
src/main.ts2 symbols

For agents

$ claude mcp add vscode-sql-notebook \
  -- python -m otcore.mcp_server <graph>

⬇ download graph artifact