PHPackages                             steveorevo/mysql2json - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. steveorevo/mysql2json

ActiveLibrary[Database & ORM](/categories/database)

steveorevo/mysql2json
=====================

MySQL2JSON is a database to JSON export tool with support for serialized PHP.

2.1.3(3y ago)2101[1 issues](https://github.com/Steveorevo/mysql2json/issues)MITPHP

Since Nov 21Pushed 3y ago1 watchersCompare

[ Source](https://github.com/Steveorevo/mysql2json)[ Packagist](https://packagist.org/packages/steveorevo/mysql2json)[ RSS](/packages/steveorevo-mysql2json/feed)WikiDiscussions master Synced 1mo ago

READMEChangelog (8)Dependencies (2)Versions (9)Used By (0)

mysql2json
==========

[](#mysql2json)

Database to JSON object conversion tool with support for PHP serialization.

### About

[](#about)

This command line tool will export the specified database to a "pretty print" JSON object. Auto-detection of PHP serialized strings will also be converted to a JSON object. This tool allows for simple line-by-line representation of a MySQL database and is perfect for viewing content in text based comparison tools. Re-import can be performed using the companion tool, [json2mysql](https://github.com/steveorevo/json2mysql).

#### Help

[](#help)

Type mysql2json --help

```
MySQL2JSON is a database to JSON export tool with support for serialized PHP.
Version 2.1.3

Usage: mysql2json [-x, --exclude] [-?, --help] [-h host, --hose host (default: localhost)] [-l, --list] [-o output, --output output] [-p password, --password password] [-P port, --port port] [-q, --quiet] [-t tables, --tables tables] [-u user, --user user (default: root)] [-v, --version] [database]

Optional Arguments:
        -?, --help
                print this help
        -h host, --hose host (default: localhost)
                host name or IP address (default: localhost)
        -l, --list
                list databases & tables available for export
        -x, --exclude
                excludes rows with _transient_ in option_name column (WordPress)
        -o output, --output output
                path & file (default is db name in current folder)
        -p password, --password password
                password to connect with (default is none)
        -P port, --port port
                the TCP/IP port number to connect to
        -t tables, --tables tables
                a comma delimited list of tables (default empty for all)
        -u user, --user user (default: root)
                username to connect as (default: root)
        -q, --quiet
                quiet (no output)
        -v, --version
                output version number
        database
                the database to export

```

###  Health Score

26

—

LowBetter than 43% of packages

Maintenance10

Infrequent updates — may be unmaintained

Popularity9

Limited adoption so far

Community8

Small or concentrated contributor base

Maturity66

Established project with proven stability

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~182 days

Recently: every ~92 days

Total

8

Last Release

1454d ago

Major Versions

1.1.2 → 2.0.02021-05-25

### Community

Maintainers

![](https://www.gravatar.com/avatar/80aa2d4f020f7e366be786aaf3e1c25308f66a63cc62c66d10cb6bea13915d4a?d=identicon)[Steveorevo](/maintainers/Steveorevo)

---

Top Contributors

[![Steveorevo](https://avatars.githubusercontent.com/u/635399?v=4)](https://github.com/Steveorevo "Steveorevo (39 commits)")

---

Tags

databasejsonmysqlmysql2jsonphp-serialphp-serialization

### Embed Badge

![Health badge](/badges/steveorevo-mysql2json/health.svg)

```
[![Health](https://phpackages.com/badges/steveorevo-mysql2json/health.svg)](https://phpackages.com/packages/steveorevo-mysql2json)
```

###  Alternatives

[doctrine/orm

Object-Relational-Mapper for PHP

10.2k285.3M6.2k](/packages/doctrine-orm)[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k115.1M102](/packages/jdorn-sql-formatter)[illuminate/database

The Illuminate Database package.

2.8k52.4M9.3k](/packages/illuminate-database)[mongodb/mongodb

MongoDB driver library

1.6k64.0M543](/packages/mongodb-mongodb)[getgrav/grav

Modern, Crazy Fast, Ridiculously Easy and Amazingly Powerful Flat-File CMS

15.4k84.1k1](/packages/getgrav-grav)[ramsey/uuid-doctrine

Use ramsey/uuid as a Doctrine field type.

90340.3M209](/packages/ramsey-uuid-doctrine)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)