Skip to content

README.md

Latest commit

 

History

History
132 lines (97 loc) · 4.81 KB

README.md

File metadata and controls

132 lines (97 loc) · 4.81 KB

json2sql

GitHub stars

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!

GitHub release Python License: MIT |Open Source Alternative CI PyPI

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

Installation

pip install json2sql-cli

Or install directly from GitHub:

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

Or install via Scoop (Windows):

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

npm (Node.js wrapper):

npm install -g json2sql-cli

Then run: json2sql --help

Quick Start

# 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

Features

  • 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)

CI/CD Integration

# 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

Pricing

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

Plan Price Best For
Free $0 Individual devs, OSS — CLI only, limited rows
json2sql Individual $9/mo ($7 billed annually) Professional devs — unlimited rows, batch processing
Suite (all 11 CLI tools) $49/mo ($39 billed annually) Full Revenue Holdings toolkit — 40% savings
Team $79/mo ($63 billed annually) Up to 5 devs — API access, CI/CD integration, priority support
Enterprise Custom SSO, RBAC, compliance reports, dedicated support

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

Per-Tier Features

Feature Free json2sql Suite Team Enterprise
CLI: convert, pipe ✓ ✓ ✓ ✓ ✓
Unlimited rows per conversion — ✓ ✓ ✓ ✓
Batch processing — ✓ ✓ ✓ ✓
Schema generation — ✓ ✓ ✓ ✓
API access — — — ✓ ✓
Compliance reports — — — — ✓
RBAC — — — — ✓
SSO / SAML / OIDC — — — — ✓
Priority support Community 24h 24h 8h Dedicated

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

License

MIT