Local SQL notebooks in your browser, backed by your DuckDB session
Compatibility Matrix
This table covers all DuckDB releases that have not reached end-of-life, including LTS releases, and shows the 2 most recent patch releases of each. Older patch releases are not listed, but the extension may be available for them as well.
| Platform | 1.4.4 | 1.4.5 | 1.5.5 | 1.5.6 | 2.0.0 |
|---|---|---|---|---|---|
| Linux AMD64 | |||||
| Linux ARM64 | |||||
| macOS AMD64 | |||||
| macOS ARM64 | |||||
| Windows AMD64 | |||||
| Windows ARM64 | |||||
| WebAssembly |
Installing and Loading
INSTALL sqlnb FROM community;
LOAD sqlnb;
Example
install sqlnb from community;
load sqlnb;
select sqlnb_start();
About sqlnb
Write SQL, explore query results, and build charts in a notebook connected to your local DuckDB database. Open and save notebook files, browse your tables, and revisit earlier versions with built-in notebook history.
SQLNB can also open, edit, and save existing notebooks from the official DuckDB UI extension.
Run select sqlnb_start(); to open SQLNB in your browser. Keep your DuckDB
session open while you work.
See the project documentation for configuration and connecting AI tools through MCP.
Added Functions
| function_name | function_type | description | comment | examples |
|---|---|---|---|---|
| sidequery_ui_start | scalar | NULL | NULL | |
| sidequery_ui_status | scalar | NULL | NULL | |
| sidequery_ui_stop | scalar | NULL | NULL | |
| sqlnb_duckdb_ui_create | scalar | NULL | NULL | |
| sqlnb_duckdb_ui_delete | scalar | NULL | NULL | |
| sqlnb_duckdb_ui_duplicate | scalar | NULL | NULL | |
| sqlnb_duckdb_ui_notebook | scalar | NULL | NULL | |
| sqlnb_duckdb_ui_notebooks | scalar | NULL | NULL | |
| sqlnb_duckdb_ui_save | scalar | NULL | NULL | |
| sqlnb_is_read_only | scalar | NULL | NULL | |
| sqlnb_read_query | table | NULL | NULL | |
| sqlnb_start | scalar | NULL | NULL | |
| sqlnb_status | scalar | NULL | NULL | |
| sqlnb_stop | scalar | NULL | NULL |
Overloaded Functions
This extension does not add any function overloads.
Added Types
This extension does not add any types.
Added Settings
| name | description | input_type | scope | aliases | typed_value |
|---|---|---|---|---|---|
| temp_directory | Set the directory to which temporary files are written. | VARCHAR | GLOBAL | [] | post.db.tmp |