json2sql MCP server
2026년 10월 24일 커밋Converts JSON files and datasets into SQL INSERT statements for PostgreSQL, MySQL, and SQLite.
다른 이름 Coding-Dev-Tools/json2sql
- 스타
- 2
- Tools
- —
- 다운로드, 30일
- —
- 최신 버전
- —
- 마지막 커밋
- 2026년 10월 24일
- 라이선스
- MIT
json2sql MCP란?
json2sql은(는) MCP server입니다. Converts JSON files and datasets into SQL INSERT statements for PostgreSQL, MySQL, and SQLite.
프로젝트 README에서 생성된 요약
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.
활용 사례
- 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.
프로젝트의 README를 바탕으로 작성되었습니다. 모든 활용 사례는 해당 내용의 인용문과 대조하여 확인합니다.
자동 검사
2026년 11월 15일에 실행됨전체 보고서 →아직 인증되지 않았습니다. 서버는 80점 이상의 점수, 심각한 결함 없음, 그리고 검사에 충분한 데이터를 갖추어야 합니다. 검사 방식 · 점수를 높이기 위해 수정할 항목
- 소스 저장소 연결 및 접근 가능coding-dev-tools/json2sql is public and reachablegithub.com/coding-dev-tools/json2sql ↗통과
- 패키지가 이 저장소를 소스로 명시검사되지 않음
- 빌드 출처(Sigstore 증명)검사되지 않음
- 오픈 소스 라이선스 (OSI)MITspdx.org/licenses/MIT.html ↗통과
- 최근 1년 내 커밋 또는 릴리스Last commit or release 2026-10-24github.com/coding-dev-tools/json2sql ↗통과
- OpenSSF Scorecard검사되지 않음
- 패키지 이름이 인기 패키지와 유사하지 않음검사되지 않음
- 패키지 및 해당 종속성에 중요한 보안 권고 없음검사되지 않음
- 모델에 대한 숨겨진 지침 없음0 tool descriptions and the README read; no override phrases, credential paths or hidden characters통과
- 파괴적인 도구에 라벨 표시됨검사되지 않음
- 원격 엔드포인트가 MCP 핸드셰이크에 응답검사되지 않음
README
GitHub에서 보기json2sql
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 질문
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.