In-browser SQL Workbench for data querying & visualization
SQL Workbench enables querying of remote CSV, JSON, Parquet and Arrow data sources, as well as uploaded local files, directly from a browser, for free. A focus lies on data privacy, no data leaves the machine of its users. It supports local Text-to-SQL models
Hey Product Hunt 👋
SQL Workbench is a free tool for online data analysis & data visualization, which is focussed on ease-of-use and data privacy. It offers a wide range of functionalities:
⌨️ Data Querying
You can either load local CSV, JSON, Parquet or Arrow files, or load them from remote HTTP(S) or object storage sources (S3 compatible, Azure Blob Storage). It's also possible to directly attach remote DuckDB databases.
📊 Data Visualization
There's a large variety of configurable visualizations, e.g. bar, line and area charts, maps, scatter plots, sunburst diagrams and more.
⚡ Performance
It supports the analysis and visualization of large datasets up to multi-million records, without having to run infrastructure.
✨ Extensions
It uses DuckDB WASM internally, so you can install and use all the extensions DuckDB provides, for example you can use the spatial extension to query remote geo data in various formats (see https://duckdb.org/docs/api/wasm...).
➰ Shareability
You can easily share your data analysis' SQL code, and even include the visualization configurations via URL.
💻 Bring your own AI
You can integrate a Text-to-SQL model running on your local machine via Ollama that supports SQL query generation from natural language.
📒 Data models
It automatically generates ERD diagrams from the created tables.
If you're curious how to use it, there's an intro into its usage at https://tobilg.com/using-duckdb-... containing basic but also more complex use cases and examples.
For the impatient, here are some example queries:
🔗 Read data from Google Sheets
🔗 Query the GitHub Events API
🔗 Read remote Parquet files
🔗 Read remote CSV data
🔗 Read geo data from Shapefile