Free Data & Database Tools
Turn CSV and JSON into SQL, view large CSV files, build connection strings and tune MySQL and PostgreSQL — all offline in your browser.
CSV Viewer
Open a CSV as a sortable table.
CSV to SQL INSERT
CREATE TABLE + INSERT statements from CSV.
JSON to SQL
INSERT statements from a JSON array.
JSON Schema Generator
Infer a JSON Schema from sample data.
Database Connection String Builder
URLs for MySQL, PostgreSQL, MongoDB, Redis.
MySQL ↔ PostgreSQL Converter
Rewrite common syntax between MySQL and Postgres.
Database Size Estimator
Estimate table size from rows and columns.
SQL to MongoDB Query Converter
Turn a simple SELECT into a MongoDB find().
SQL INSERT to CSV
Extract rows from INSERT statements into CSV.
ER Diagram from SQL
Draw tables and relationships from CREATE TABLE statements.
SQL Index Advisor
Suggest indexes for a slow query.
MySQL EXPLAIN Reader
Make sense of EXPLAIN output.
Database Migration Checklist
Move a MySQL or PostgreSQL database without losing data.
How do I import a CSV file into MySQL?
Use the CSV to SQL tool to generate CREATE TABLE and INSERT statements, or for very large files use LOAD DATA INFILE with the same column list.