Convert JSON files and datasets to SQL INSERT statements. Supports nested JSON, PostgreSQL, MySQL, and SQLite output dialects.

⭐ Star this repo if you work with JSON data — it helps other devs discover json2sql!

| |

Real-world scenarios:

• Seeding test databases: Convert API response fixtures into seed data for integration tests
• Data migrations: Transform JSON exports from one system into INSERT statements for a new database
• CI/CD pipelines: Generate SQL from JSON configs as part of automated deployment
• Analytics imports: Convert event JSON payloads into structured SQL tables for querying

Note: json2sql is not yet on public PyPI. Install via GitHub directly:

pip install git+https://github.com/Coding-Dev-Tools/json2sql.git

Or install via Homebrew (macOS/Linux):

brew tap Coding-Dev-Tools/tap
brew install json2sql-cli

Or install via Scoop (Windows):

scoop bucket add Coding-Dev-Tools https://github.com/Coding-Dev-Tools/scoop-bucket
scoop install json2sql-cli

npm (Node.js wrapper):

npm install -g json2sql

Then run: json2sql --help

# Basic usage — converts JSON to SQL INSERT statements
json2sql convert data.json

# Specify output dialect
json2sql convert data.json --dialect postgres
json2sql convert data.json --dialect mysql
json2sql convert data.json --dialect sqlite

# Specify output file
json2sql convert data.json -o output.sql

# Specify table name
json2sql convert data.json --table users

# Handle nested JSON (auto-flattens into relational tables)
json2sql convert nested_data.json --flatten

• Nested JSON support: Automatically flattens nested objects into separate relational tables
• Multi-dialect output: PostgreSQL, MySQL, SQLite INSERT syntax
• Array of objects: Handles JSON arrays as multiple INSERT rows
• Type inference: Auto-detects strings, numbers, booleans, nulls
• Pipe support: Read from stdin for pipeline usage
• Zero dependencies: Only Python 3.10+ required (typer for CLI)

# Generate SQL as part of a data pipeline
cat data.json | json2sql convert --dialect postgres --table events > events.sql

# Use in GitHub Actions to prepare test data
json2sql convert fixtures.json --dialect sqlite -o seed.sql
sqlite3 test.db < seed.sql

json2sql is one of eleven CLI tools in the Revenue Holdings suite. One license covers all CLI tools.

🔹 No lock-in: CLI works fully offline on the free tier — no telemetry, no phone-home. 🔹 Annual billing: Save 20%.

_{Part of Revenue Holdings — CLI tools built by autonomous AI.}

MIT