Search Results for "csv"

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.

...It is a Django-based application that you can add to an existing Django site, or use as a standalone business intelligence tool. Quickly write and share SQL queries in a simple, usable SQL editor, preview the results in the browser, share links, download CSV, JSON, or Excel files (and even expose queries as API endpoints, if desired), and keep the information flowing! Comes with support for multiple connections, to many different SQL database types, a schema explorer, query history (e.g. lightweight version control), a basic security model, in-browser pivot tables, and more. SQL Explorer values simplicity, intuitive use, unobtrusiveness, stability, and the principle of least surprise. ...

chDB is an in-process SQL OLAP Engine powered by ClickHouse. It is developed by ClickHouse, Inc and open-source contributors.

Just use the portable copy of the free sqlitebrowser program, available here : https://sqlitebrowser.org/dl/ to open and test the sample db, that I have given as a download here ( after extracting the zip file ) . Also, I have enclosed, the csv files, that I have used for importing and exporting, from the file menu of the program. Also, watch the video below, for a quick start. Tags: Learn SQL Quickly, Analyze Data Easily, SQL Guide, SQL Samples

LazLiteDB can create and utilize multi-table SQlite databases with report capability. It provides an editor to create SQLite tables and maintain the table structure. For day to day data entry, LazLiteDB provides a user friendly interface with custom reports. See ReadMe.txt file for version updates

1.SQL Compare Compare and synchronize SQL Server database schemas effortlessly. 2.SQL Data Compare Identify and sync data differences between SQL Server databases. 3.Folder to SQL Compare Compare SQL script folders with live SQL Server databases. 4.SQL Trace / SQL Profiler (Azure Supported) Capture, trace, and analyze SQL Server events and performance — includes Azure SQL support. 5.SQL Table Documents Generate structured documentation for SQL Server table schemas. 6.SQL Data Export Export SQL Server data into multiple formats (CSV, Excel, JSON, etc.). 7.Excel to SQL Move Import Excel spreadsheets directly into SQL Server tables. 8.Import / Export Data Perform high-speed bulk data transfer between databases and formats. 9.Daily Tasks Automate and schedule routine SQL Server maintenance tasks. 10.Procedure Creation Easily design, edit, and manage stored procedures. 11.Script Maintenance Organize, version, and manage SQL scripts within the applica

...*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"

Falcon is a free, open-source SQL editor with inline data visualization. With Falcon you can connect to your database in the Connection tab, run SQL queries in the Query tab, then export your results as a CSV or open them in the Chart Studio to unlock the full power of Plotly graphs. Optionally, you can use Falcon as a middleman between plot.ly and your database - so that when your database updates, your charts and dashboards update as well. Currently, Falcon supports connections to RedShift, MySQL, PostgreSQL, IBM DB2, Impala, MS SQL, and SQLite. ...

DaFT is a frontend to any database that can be connected via ODBC. It provides list views of tables and columns, table view of data, SQL editor, CSV,HTML,SyLK,XLS data format export, and functions for copying data between two ODBC databases.