json2sql MCP server
Commit Oct 24, 2026Converts JSON files and datasets into SQL INSERT statements for PostgreSQL, MySQL, and SQLite.
Also known as Coding-Dev-Tools/json2sql
- Stars
- 2
- Tools
- —
- Downloads, 30 days
- —
- Latest version
- —
- Last commit
- Oct 24, 2026
- License
- MIT
What is json2sql MCP?
json2sql converts JSON files and datasets into SQL INSERT statements for PostgreSQL, MySQL, and SQLite.
Summary generated from the project's README
About json2sql MCP server
Transforming JSON datasets into SQL INSERT statements for database seeding or migrations is what json2sql enables. Developers can take JSON files and convert them into specific dialects for PostgreSQL, MySQL, or SQLite. The tool handles complex data structures by automatically flattening nested objects into relational tables, making it useful for turning hierarchical API responses into structured database rows.
This utility runs locally via a command line interface and can be installed through pip, Homebrew, Scoop, or npm. It supports piping data from stdin for use in automated pipelines and includes type inference to detect strings, numbers, booleans, and null values. While a free tier is available for individual developers with limited rows, professional users can access unlimited rows, batch processing, and schema generation through paid subscription tiers.
What you can do with it
- 1Seeding test databasesConvert API response fixtures into seed data for integration tests.
- 2Automating data migrationsTransform JSON exports from one system into INSERT statements for a new database.
- 3Flattening complex JSON structuresAutomatically turn nested JSON objects into separate relational tables.
- 4Integrating with CI/CD pipelinesGenerate SQL from JSON configurations as part of automated deployment processes.
Written from the project's README. Every use case is checked against a quote from it.
README
View on GitHubjson2sql
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
Installation
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
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 |
License
MIT
json2sql MCP questions
Which SQL dialects are supported?
The tool supports PostgreSQL, MySQL, and SQLite output dialects.
How can I handle nested JSON objects?
You can use the --flatten flag to automatically flatten nested objects into separate relational tables.
Is there a free version available?
Yes, there is a free tier for individual developers and open source projects that allows CLI usage with limited rows.
Does the tool require an internet connection to work?
The CLI works fully offline on the free tier with no telemetry.