PHPackages vcian/php-db-auditor - 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. vcian/php-db-auditor ActiveLibrary[Database & ORM](/categories/database) vcian/php-db-auditor ==================== Database DB Auditor provide leverage to audit your MySql database standards and also provide options to add constraints in table. v2.1.0(2y ago)48464MITPHPPHP ^8.1 Since Sep 29Pushed 2y ago1 watchersCompare [ Source](https://github.com/vcian/php-db-auditor)[ Packagist](https://packagist.org/packages/vcian/php-db-auditor)[ RSS](/packages/vcian-php-db-auditor/feed)WikiDiscussions main Synced 1mo ago READMEChangelog (5)Dependencies (3)Versions (7)Used By (0) [![Logo PHP DB Auditor](https://raw.githubusercontent.com/vcian/art/main/php-db-auditor/php-db-auditor-hr.svg)](https://raw.githubusercontent.com/vcian/art/main/php-db-auditor/php-db-auditor-hr.svg) [![Packagist License](https://camo.githubusercontent.com/f820476efd70fd7c34ce7944a9de1a59f9ff8ba6b43c9b4c859ae75d3fb68d68/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f6c2f766369616e2f7068702d64622d61756469746f72)](https://camo.githubusercontent.com/f820476efd70fd7c34ce7944a9de1a59f9ff8ba6b43c9b4c859ae75d3fb68d68/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f6c2f766369616e2f7068702d64622d61756469746f72)[![Total Downloads](https://camo.githubusercontent.com/69eb402e0f4750a6e8cbd817332cbb41e9ac0bdf51ec268f561948ca523112bf/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f766369616e2f7068702d64622d61756469746f72)](https://packagist.org/packages/vcian/php-db-auditor) Introduction ------------ [](#introduction) - Introducing "PHP DB Auditor" – your go-to solution for meticulous MySQL database system auditing. This powerful PHP package is your key to ensuring the utmost integrity and compliance with MySQL standards and constraints in your database. Dive into the world of database auditing with ease, thanks to its user-friendly command-line interface (CLI). Key Points ---------- [](#key-points) 1. Comprehensive Auditing: PHP DB Auditor is a specialized PHP package designed to perform comprehensive audits on MySQL database systems. 2. Thorough Evaluation: It conducts a thorough and detailed evaluation of the entire MySQL database structure. 3. Standards Compliance: The package employs advanced scanning techniques to assess the database's adherence to MySQL standards and constraints. 4. Command-Line Interface (CLI): Users can effortlessly interact with PHP DB Auditor through its intuitive command-line interface, making the auditing process seamless. 5. Constraint Management: PHP DB Auditor empowers you to add essential constraints directly to your MySQL database via the CLI. 6. Detailed Audit Report: Upon completion of the auditing process, the package generates a detailed report. 7. Identifying Non-Compliance: The audit report provides a comprehensive list of tables and columns that fall short of meeting established MySQL standards and constraints. 8. Database Integrity: With PHP DB Auditor, you can proactively maintain the integrity of your database and ensure it aligns with the necessary standards. Installation ------------ [](#installation) \*\*Requires [PHP 8.1+](https://php.net/releases/) #### **As a standalone project under linux** [](#as-a-standalone-project-under-linux) ``` # create directory (feel free to give your own) mkdir dbauditor cd dbauditor # install package composer require vcian/php-db-auditor # create symbolic links ln -s vendor/vcian/php-db-auditor/dbauditor dbauditor ln -s vendor/vcian/php-db-auditor/src/config.php config.php # edit config.php to configure the database settings ``` #### **As a standalone project under windows** [](#as-a-standalone-project-under-windows) ``` # create directory (feel free to give your own) mkdir dbauditor cd dbauditor # install package composer require vcian/php-db-auditor # create symbolic links mklink vendor/vcian/php-db-auditor/dbauditor dbauditor mklink vendor/vcian/php-db-auditor/src/config.php config.php # edit config.php to configure the database settings ``` Usage: ------ [](#usage) #### **See database information** [](#see-database-information) ``` php dbauditor db:summary ``` [![PHP DB Auditor Standard UI](https://raw.githubusercontent.com/vcian/art/main/php-db-auditor/db-auditor-summary.png)](https://raw.githubusercontent.com/vcian/art/main/php-db-auditor/db-auditor-summary.png) #### **See a list of table with standard follow indication** [](#see-a-list-of-table-with-standard-follow-indication) ``` php dbauditor db:standard ``` [![PHP DB Auditor Standard UI](https://raw.githubusercontent.com/vcian/art/main/php-db-auditor/db-standard-ui.png)](https://raw.githubusercontent.com/vcian/art/main/php-db-auditor/db-standard-ui.png) [![PHP DB Auditor Standard UI](https://raw.githubusercontent.com/vcian/art/main/php-db-auditor/db-standard-table-report-1.png)](https://raw.githubusercontent.com/vcian/art/main/php-db-auditor/db-standard-table-report-1.png) [![PHP DB Auditor Standard UI](https://raw.githubusercontent.com/vcian/art/main/php-db-auditor/db-standard-table-report-2.png)](https://raw.githubusercontent.com/vcian/art/main/php-db-auditor/db-standard-table-report-2.png) #### **See a list of tables with fields, primary, foreign, unique, index constraint.** [](#see-a-list-of-tables-with-fields-primary-foreign-unique-index-constraint) ``` php dbauditor db:constraint ``` [![PHP DB Auditor Constraint UI](https://raw.githubusercontent.com/vcian/art/main/php-db-auditor/db-constraint-ui.png)](https://raw.githubusercontent.com/vcian/art/main/php-db-auditor/db-constraint-ui.png) [![PHP DB Auditor Constraint UI](https://raw.githubusercontent.com/vcian/art/main/php-db-auditor/db-constraint-add.png)](https://raw.githubusercontent.com/vcian/art/main/php-db-auditor/db-constraint-add.png) You can add more constraint to a table. [![PHP DB Auditor Constraint UI](https://raw.githubusercontent.com/vcian/art/main/php-db-auditor/db-constraint-selection.png)](https://raw.githubusercontent.com/vcian/art/main/php-db-auditor/db-constraint-selection.png) [![PHP DB Auditor Constraint UI](https://raw.githubusercontent.com/vcian/art/main/php-db-auditor/db-constraint-result.png)](https://raw.githubusercontent.com/vcian/art/main/php-db-auditor/db-constraint-result.png) Changelog --------- [](#changelog) Please see [CHANGELOG](CHANGELOG.md) for more information what has changed recently. Contributing ------------ [](#contributing) Please see [CONTRIBUTING](CONTRIBUTING.md) for details. ``` We believe in 👇 ACT NOW PERFECT IT LATER CORRECT IT ON THE WAY. ``` Security -------- [](#security) If you discover any security-related issues, please email instead of using the issue tracker. Credits ------- [](#credits) - [All Contributors](../../contributors) License ------- [](#license) The MIT License (MIT). Please see [License File](LICENSE.md) for more information. ### Health Score 30 — LowBetter than 64% of packages Maintenance20 Infrequent updates — may be unmaintained Popularity20 Limited adoption so far Community13 Small or concentrated contributor base Maturity56 Maturing project, gaining track record Bus Factor1 Top contributor holds 51.7% 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 ~13 days Total 5 Last Release 907d ago Major Versions v1.2.0 → v2.0.02023-10-06 ### Community Maintainers ![](https://www.gravatar.com/avatar/f19733b75e0a9bb01c70ec6302be389d4440d8afce378f998ea371ac6cfbb17a?d=identicon)[vcian](/maintainers/vcian) --- Top Contributors [![ruchit288](https://avatars.githubusercontent.com/u/28095255?v=4)](https://github.com/ruchit288 "ruchit288 (31 commits)")[![vc-bharat](https://avatars.githubusercontent.com/u/127181427?v=4)](https://github.com/vc-bharat "vc-bharat (27 commits)")[![tdaguin](https://avatars.githubusercontent.com/u/6739615?v=4)](https://github.com/tdaguin "tdaguin (2 commits)") --- Tags auditdatabase-standarddbdbaudithacktoberfestmysqlphpphpdatabasemysqlDB AuditDB StandardsDB Constraints ### Embed Badge ![Health badge](/badges/vcian-php-db-auditor/health.svg) ``` [![Health](https://phpackages.com/badges/vcian-php-db-auditor/health.svg)](https://phpackages.com/packages/vcian-php-db-auditor) ``` ### Alternatives [vcian/laravel-db-auditor Database DB Auditor provide leverage to audit your MySql,sqlite, PostgreSQL database standards and also provide options to add constraints in table. 28535.1k1](/packages/vcian-laravel-db-auditor)[scienta/doctrine-json-functions A set of extensions to Doctrine that add support for json query functions. 58523.9M36](/packages/scienta-doctrine-json-functions)[clouddueling/mysqldump-php PHP version of mysqldump cli that comes with MySQL 1.3k22.9k](/packages/clouddueling-mysqldump-php)[awssat/laravel-sync-migration Laravel tool helps to sync migrations without refreshing the database 10923.2k](/packages/awssat-laravel-sync-migration)[stefangabos/zebra_database An advanced, compact and lightweight MySQL database wrapper library, built around PHP's MySQLi extension. 11812.0k](/packages/stefangabos-zebra-database)[popphp/pop-db Pop Db Component for Pop PHP Framework 1814.6k11](/packages/popphp-pop-db) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)