PHPackages                             milantex/mysql-tso - 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. milantex/mysql-tso

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

milantex/mysql-tso
==================

Creates a PHP object which describes the MySQL table structure for a specified table in the database.

1.0.1(9y ago)0211MITPHPPHP >=7.0.0

Since Apr 26Pushed 9y agoCompare

[ Source](https://github.com/Milantex/mysql-tso)[ Packagist](https://packagist.org/packages/milantex/mysql-tso)[ RSS](/packages/milantex-mysql-tso/feed)WikiDiscussions master Synced today

READMEChangelogDependencies (2)Versions (3)Used By (0)

[![Build Status](https://camo.githubusercontent.com/b02ca8ad9b31138eb28e23a38d59373d23ba3a6307e9673c71fbeccced00820d/68747470733a2f2f7472617669732d63692e6f72672f4d696c616e7465782f6d7973716c2d74736f2e7376673f6272616e63683d6d6173746572)](https://travis-ci.org/Milantex/mysql-tso)[![codecov](https://camo.githubusercontent.com/282d7d63153e3084c35e2167d7dba99aea834f8af9cc59b28349a7cb192cee34/68747470733a2f2f636f6465636f762e696f2f67682f4d696c616e7465782f6d7973716c2d74736f2f6272616e63682f6d61737465722f67726170682f62616467652e737667)](https://codecov.io/gh/Milantex/mysql-tso)[![Code Climate](https://camo.githubusercontent.com/1496064129578dcbd47d129d83136ee7d66e8eee5811bb11f8ea3eaa6ece5a26/68747470733a2f2f636f6465636c696d6174652e636f6d2f6769746875622f4d696c616e7465782f6d7973716c2d74736f2f6261646765732f6770612e737667)](https://codeclimate.com/github/Milantex/mysql-tso)[![Latest Stable Version](https://camo.githubusercontent.com/7f9eea2642b6d5326cfb3d6640f58ac8489c65d5f4744057e307f6aec8f1720f/68747470733a2f2f706f7365722e707567782e6f72672f6d696c616e7465782f6d7973716c2d74736f2f762f737461626c65)](https://packagist.org/packages/milantex/mysql-tso)[![Total Downloads](https://camo.githubusercontent.com/83d392f2ed60e8d25c9827ecb9ba1b7e2c1bb99372ac39ccbb0caf52360153a8/68747470733a2f2f706f7365722e707567782e6f72672f6d696c616e7465782f6d7973716c2d74736f2f646f776e6c6f616473)](https://packagist.org/packages/milantex/mysql-tso)[![License](https://camo.githubusercontent.com/6a2a81c849c7a6b16e920833d36bfb23d92685d401574589d7cda442448df2cf/68747470733a2f2f706f7365722e707567782e6f72672f6d696c616e7465782f6d7973716c2d74736f2f6c6963656e7365)](https://packagist.org/packages/milantex/mysql-tso)[![SensioLabsInsight](https://camo.githubusercontent.com/7c5ab9007101041bcc1ae78f0ae8d8ba91e2e2877668cd77bfc65d294ae1ce5c/68747470733a2f2f696e73696768742e73656e73696f6c6162732e636f6d2f70726f6a656374732f66373665313764392d386366612d346664352d616230302d3565613533636434666166352f6d696e692e706e67)](https://insight.sensiolabs.com/projects/f76e17d9-8cfa-4fd5-ab00-5ea53cd4faf5)

What is MySQL-TSO?
==================

[](#what-is-mysql-tso)

This package provides a mechanism that analyzes the structure of tables in a MySQL/MariaDB database. It might be better to see an example of how to use it instead of reading a lengthy description.

Installation
------------

[](#installation)

#### Using composer in the command line

[](#using-composer-in-the-command-line)

You can use composer to install the package using the following command from within your project's source directory:

`composer require milantex/mysql-tso`

Make sure to update your autoloader if needed:

`composer dump-autoload -o`

#### Requiring the package as a dependency in composer.json

[](#requiring-the-package-as-a-dependency-in-composerjson)

Add the following code to your composer.json. Here is an example of a composer.json file with the milantex/mysql-tso package required:

```
{
    "name": "your-name/your-project",
    "description": "Your project's description",
    "type": "project",
    "license": "MIT",
    "authors": [
        {
            "name": "Your Name",
            "email": "your@mail.tld"
        }
    ],
    "require": {
        "milantex/mysql-tso": "*"
    }
}
```

Make sure to run the composer command to install dependencies:

`composer install`

Using the library in your project
---------------------------------

[](#using-the-library-in-your-project)

```
    require_once '../vendor/autoload.php';

    use Milantex\DAW\DataBase;
    use Milantex\TSO\TableStructureDescriptor;

    # Enter database parameters
    $daw = new DataBase('localhost', 'demo', 'root', '');

    # Instantiate a table structure descriptor object
    $tso = new TableStructureDescriptor($daw);

    # Start the database analysis
    $tso->analyse();

    if ($tso->tableExists('page') &&
        $tso->getTableStructure('page')->fieldExists('title')) {
        echo 'Can page.title be null? ';
        if ($tso->getTableStructure('page')
                ->getFieldStructure('title')
                ->isNullable()) {
            echo 'Yes';
        } else {
            echo 'No';
        }
    }
```

###  Health Score

26

—

LowBetter than 41% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity7

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity59

Maturing project, gaining track record

 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 ~2 days

Total

2

Last Release

3349d ago

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/1736794?v=4)[Milan Tair](/maintainers/Milantex)[@Milantex](https://github.com/Milantex)

---

Top Contributors

[![Milantex](https://avatars.githubusercontent.com/u/1736794?v=4)](https://github.com/Milantex "Milantex (17 commits)")

###  Code Quality

TestsPHPUnit

### Embed Badge

![Health badge](/badges/milantex-mysql-tso/health.svg)

```
[![Health](https://phpackages.com/badges/milantex-mysql-tso/health.svg)](https://phpackages.com/packages/milantex-mysql-tso)
```

###  Alternatives

[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k116.5M113](/packages/jdorn-sql-formatter)[propel/propel1

Propel is an open-source Object-Relational Mapping (ORM) for PHP5.

8351.6M87](/packages/propel-propel1)[pgvector/pgvector

pgvector support for PHP

198628.3k10](/packages/pgvector-pgvector)

PHPackages © 2026

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