Redash
Metabase
Tableau
Microsoft Power BI
Looker
Google Data Studio
Apache Superset
D3.js
SQLified
SQLizer
Table Format Converter
OI ConvertCSV
Online Convert
Convertio
ExtendsClass SQL Converter
DBConvert for Excel and MySQL
SQLified is a browser-based tool that converts CSV, TSV, and other delimited data files into clean, import-ready SQL —CREATE TABLE plus batched INSERT statements — for PostgreSQL, MySQL, SQLite, and SQL Server.
Unlike free one-off converters that choke around 100K rows, SQLified is built for production-scale loads: it reliably handles files of 1,000,000+ rows. It does smart type inference (INT/BIGINT, NUMERIC scale, dates, booleans, currency), lets you override any column's type, primary key, and nullability, and emits correctly chunked INSERT batches per dialect (including SQL Server's 1000-row limit and MySQL packet limits) so the output imports cleanly the first time.
Free to use for everyday conversions; Pro unlocks the largest files, batched output tuning, and an ad-free experience. A product of Octet Software.
SQLifiedSQLified's answer:
Our ability to infer data types, and produce massive insert statements quickly across multiple dialects.
SQLified's answer:
After using many online tools and being disappointed, I realized there was a need for a file that can create clean, type aware sql for bulk inserts. The product saves me tons of time every month dealing with large data sets in the payment industry and has reduced frustrations in dealing with them.
SQLified's answer:
There are numerous competitors, but none that do what SQLified does well: this is type inference, and creating runnable SQL script for extremely large inserts in multiple dialects.
SQLified's answer:
SQLified is designed for the solo developer, or the analytical employee dealing with large data sets, csv, or delimited files every day, and struggling with bulk insert. I want to eliminate that struggle so the real work can be done.
SQLified's answer:
Our tools are simple, effective, and require little processing power. We store no data; all work is "ephemeral" and done on the users machine. We do not track, store, or maintain any datasets whatsoever in regards to whatever is converted on the site. We are also not trying to be something we are not. We do what we do, which is flat file to SQL dialect conversion, and we do it well.
Based on our record, Redash seems to be more popular. It has been mentiond 19 times since March 2021. We are tracking product recommendations and mentions on various public social media platforms and blogs. They can help you identify which product is more popular and what people think of it.
I am looking for service or tool similiar to Metabase or Redash that allows me to add data source - for example Postgres connection, and create raw SQL queries that can be shared or exposed through API. So instead of keeping raw SQL code somewhere, my other service would call this tool e.g. http://microservice/query=1?param1=xx&page=2 and get the results from the DB. These calls are internal only and part of ETL... Source: about 3 years ago
I have tried Metabase, Redash beore (both self hosted open source versions), from my experience I find Metabase a bit easy to work with. Source: about 3 years ago
Regarding visualization tools, sqliteviz has proven to be the best I've found so far. Their web app runs locally but has some trackers, so I run it locally via a simple, static HTTP server. Falcon and Redash seem like overkill for my needs. Source: over 3 years ago
In addition to metabase there are redash[0] and apache superset[1]. They are more or less similar to metabase with some different quirks. You can also visualize quite a bit of data in grafana[2] as well. [0] https://redash.io/ [1] https://superset.apache.org/ [2] https://github.com/grafana/grafana. - Source: Hacker News / almost 4 years ago
This is typically called a "dashboard" and there is a whole industry of existing commercial products (for example https://redash.io/) that are built around doing data analysis and visualization. Source: about 4 years ago
Metabase - Metabase is the easy, open source way for everyone in your company to ask questions and learn from...
SQLizer - Take data in a format you don't need, and turn it into SQL
Tableau - Tableau can help anyone see and understand their data. Connect to almost any database, drag and drop to create visualizations, and share with a click.
Table Format Converter - Free online table converter tool. Convert CSV, HTML, JSON, Markdown, and other table formats instantly. No registration required, works offline, and keeps your data private.
Microsoft Power BI - BI visualization and reporting for desktop, web or mobile
OI ConvertCSV - Backup your notes and shopping lists on Android
