⭐Download the 64-bit installer (recommended)⭐

Or: Download the 64-bit portable zip • Install using Chocolatey

Requires Windows 10 or newer on a 64-bit computer. Going forward, 32-bit systems and Windows 7 and 8 are no longer supported. Users of older machines may continue to use version 1.2.3 which should work indefinitely.

Changes

🔄 FOREACH Loop Statement

Iterate through table rows with automatic variable assignment:

FOREACH (@id, @name, @email) IN customers 
BEGIN
    PRINT CONCAT('Customer: ', @name, ' (', @email, ')');
END

• Variables are automatically declared and assigned values from each row
• Supports BREAK and CONTINUE statements like other loops
• Works with tables, views, and subqueries

💻 Command-Line Interface

Execute SQL Notebook scripts from the command line without opening the GUI:

SqlNotebookCmd "MyNotebook.sqlnb" "MyScript"

• Perfect for automation, batch processing, and CI/CD pipelines
• Outputs results in CSV format
• Returns appropriate exit codes for success/failure

📝 Dynamic Script Management

Create and delete scripts programmatically:

-- Create a new script
CREATE SCRIPT DataCleanup AS '
    DELETE FROM temp_table WHERE processed = 1;
    PRINT ''Cleanup completed'';
';

-- Execute the script
EXECUTE DataCleanup;

-- Remove the script when no longer needed
DROP SCRIPT DataCleanup;

• CREATE SCRIPT to add new scripts dynamically
• DROP SCRIPT and DROP PAGE to remove scripts and pages
• Useful for generating reports, temporary procedures, and workflow automation

💾 Save Command

Save your notebook programmatically from within scripts:

-- Save to current file
SAVE;

-- Save to a specific file
SAVE 'MyBackup.sqlnb';

• Particularly useful in SqlNotebookCmd for persisting changes
• Must be used outside of transactions (use "None (auto-commit)" mode in GUI)

🦆 DuckDB Integration

Import data from DuckDB files with full UI support:

• Drag and drop .duckdb files directly into SQL Notebook
• Available in Import menu → "From file..."
• Support for both copying data and live database connections

-- Copy data from DuckDB
IMPORT DATABASE 'duckdb'
CONNECTION 'Data Source=C:\data\analytics.duckdb'
TABLE sales_data;

-- Create live connection
IMPORT DATABASE 'duckdb'
CONNECTION 'Data Source=C:\data\analytics.duckdb'
TABLE sales_data
OPTIONS (LINK: 1);

🗄️ Enhanced SQLite Support

Expanded SQLite file compatibility:

• Open SQLite databases (.db, .sqlite, .sqlite3) directly via File → Open
• Import SQLite tables using the same interface as other databases
• Seamless integration with your existing SQLite workflows

Requires Windows 7 or newer.

Windows 7 users: Service Pack 1 and security update KB3063858 are required.

Changes

• Arm64 computers are now supported. Use the downloads labeled "arm64".
• Small joins to remote database tables are now faster.
• Updated to SQLite 3.46.0.

Requires Windows 7 or newer.

Windows 7 users: Service Pack 1 and security update KB3063858 are required.

Changes

• 32-bit Windows is now supported. If you have an older 32-bit computer, use the "32bit" download below.
• Updated to SQLite 3.44.0.

Requires 64-bit Windows 7 or newer.

Windows 7 users: Service Pack 1 and security update KB2533623 are required.

Changes

• Fixed an error message when saving a notebook in certain situations. (#48)
• No longer inserts nonprintable control characters when pressing Ctrl+? key combinations. (#52)
• Fixed an error message when a query result includes a zero-length blob.
• Updated to SQLite 3.40.1.

Requires 64-bit Windows 7 or newer.

Windows 7 users: Service Pack 1 and security update KB2533623 are required.

Changes

• When importing CSV/XLS, you can now set the type for multiple selected columns at once. You may also opt to automatically detect column types. (#45)
• You can now import non-public schemas in PostgreSQL. (#47)
• Fixed handling of blank or missing column names in CSV/XLS files.
• Updated to SQLite 3.38.5.

Requires 64-bit Windows 7 or newer.

Windows 7 users: Service Pack 1 and security update KB2533623 are required.

Changes

• Updated to SQLite 3.38.0.
• Added the crypto, fuzzy, and stats extensions from Anton Zhiyanov's sqlean project.
• Enabled the load_extension function for loading custom SQLite extensions.
• You can now drag-and-drop a CSV or Excel file onto the SQL Notebook window to import it.

Requires 64-bit Windows 7 or newer.

Windows 7 users: Service Pack 1 and security update KB2533623 are required.

Changes

• On Windows 7, an error message was preventing the application from launching. This has been fixed. Windows 7 users, please see the System Requirements for Windows 7.

Requires 64-bit Windows 7 (or newer).

Changes

• This is the first stable release. All aspects of the application have been improved and polished.

Requires 64-bit Windows 7 with .NET Framework 4.6 (or newer).

Changes

• First public release.

• Fixed exception when binding NULL to query parameter.
• Added additional help pages.
• Removed "root_" prefix from imported JSON table names.
• Installer and application are now signed.