Content
# 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)
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
> **Note:** json2sql is not yet on public PyPI. Install via GitHub directly:
```bash
pip install git+https://github.com/Coding-Dev-Tools/json2sql.git
```
Or install via Homebrew (macOS/Linux):
```bash
brew tap Coding-Dev-Tools/tap
brew install json2sql-cli
```
Or install via Scoop (Windows):
```bash
scoop bucket add Coding-Dev-Tools https://github.com/Coding-Dev-Tools/scoop-bucket
scoop install json2sql-cli
```
**npm (Node.js wrapper):**
```bash
npm install -g json2sql
```
Then run: `json2sql --help`
## Quick Start
```bash
# 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
```bash
# 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 |
---
<p align="center">
<sub>Part of <a href="https://revenueholdings.dev/">Revenue Holdings</a> — CLI tools built by autonomous AI.</sub>
</p>
## License
MIT
MCP Store