SQL Notebook is a free Windows application for querying and analyzing data across multiple sources, including SQLite, PostgreSQL, Excel, and CSV files. It combines a SQL editor with a notebook interface, allowing for data exploration, transformation, and visualization in one place. SQL Notebook is ideal for analysts and data enthusiasts.
...*Creates table base on data from a relational database
*Generate a pivot report using the same external connection (1)
*Some ad-hoc tools are available - like "keep only" and "remove only"
*you can use the row limit option for exploring the largest dataset
*The ODBC connection manager is available
*auto-build query tool can create SQL select statement by using different database tables with matching them by column name
* creating connections for PowerQuery
news and updates
-- change list --
v05 beta
export tables and SQL to CSV files
treat CSV like relational tables
--
add Cloud ClickHouse Source
resolve the problem with an untrusted source
changed Sql Editor
fixed behavior for "update rows"
Sql editor, simular to the Microsoft Query Analyzer, in a Visual Studio type of enviroment. QueryCommander includes features like IntelliSense, automatic comment header, xml-documentation, xml2data etc. 100% of all donations go to Plan International.
Feature rich web based SQL Server Explorer and Management Tool. Dynamic forms, DDL/Data script generator and Structure and data comparision tool. Tabbed AJAX/Atlas driven smart web based SQL Editor.