Jupyter-style SQL notebooks inside VS Code. Connect to PostgreSQL, write queries, and visualize results — all without leaving your editor.
Install → Connect → Create → Query → Visualize
1. Install
Search for "SQL Notebook EDA" in VS Code Extensions, or install the .vsix from the releases.
2. Create a .sqlnb File
Create a new file with the .sqlnb extension (e.g. analysis.sqlnb). This is the only file format the extension works with.
You can also run Cmd+Shift+P → SQL Notebook: New Notebook.
New notebooks auto-include a Schema Browser at the top so you can explore tables, views, and materialized views right away.
3. Connect to a Database
Cmd+Shift+P → SQL Notebook: Connect to Database → paste your connection string.
Supports PostgreSQL (
postgres://...).
4. Write & Run SQL Write SQL in any code cell and hit Run. Results appear as a sortable, paginated table.
5. Add Visualizations Click + Chart in the toolbar → pick X/Y axes → click Run Chart.
| Feature | What it does |
|---|---|
| Notebook Format | Mix Markdown + SQL + Charts in .sqlnb files |
| Premium UX | Collapsible cells, inline SQL status bars, and modern connection management |
| Schema Browser | Browse tables, views, and materialized views with toggle filters |
| Smart Tables | Server-side cursors for large datasets — zero RAM spikes |
| Server-Side Sort | Click column headers to sort millions of rows on the DB side |
| Charts | Bar, Line, Scatter, Pie via ECharts — with multiple Y axes, separate axes, and log scale |
| Data Profile | One-click summary statistics (numeric, categorical, date columns) |
| Query Cancel | Stop runaway queries instantly via interrupt |
| CSV / Excel Export | Export any result to CSV or Excel |
| Connection Modal | Configure PostgreSQL with a dedicated connection card and test button |
| Action | Shortcut |
|---|---|
| Open Command Palette | Cmd+Shift+P |
| Run Cell | Shift+Enter |
| Add Cell Below | Cmd+Shift+Enter |
- VS Code ≥ 1.80
- PostgreSQL database
Developed by Dilmurod Yarmukhamedov