Json2sql

json2sql

[](https://github.com/Coding-Dev-Tools/json2sql/stargazers)

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!

[](https://github.com/Coding-Dev-Tools/json2sql/releases)

[](https://github.com/Coding-Dev-Tools/json2sql/blob/main/LICENSE) |[](https://www.opensourcealternative.to/project/json2sql) [](https://github.com/Coding-Dev-Tools/json2sql/actions/workflows/ci.yml) [](https://pypi.org/project/json2sql-cli/)

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 
  Part of Revenue Holdings — CLI tools built by autonomous AI.

## License

MIT

## Source & license

This open-source MCP server is cataloged on AgentStack and links to its original source — we do not rehost the code.

- **Author:** [Coding-Dev-Tools](https://github.com/Coding-Dev-Tools)
- **Source:** [Coding-Dev-Tools/json2sql](https://github.com/Coding-Dev-Tools/json2sql)
- **License:** MIT
- **Homepage:** https://coding-dev-tools.github.io/devforge/

Install and usage instructions live in the source repository linked above.