PHPackages                             davidlienhard/database-query-validator - 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. davidlienhard/database-query-validator

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

davidlienhard/database-query-validator
======================================

🐘 php tool to validate database queries

0.4.10(8mo ago)09.3k[1 PRs](https://github.com/davidlienhard/database-query-validator/pulls)MITPHPPHP ^8.4CI passing

Since Apr 6Pushed 1mo ago1 watchersCompare

[ Source](https://github.com/davidlienhard/database-query-validator)[ Packagist](https://packagist.org/packages/davidlienhard/database-query-validator)[ Docs](https://github.com/davidlienhard/database-query-validator/)[ RSS](/packages/davidlienhard-database-query-validator/feed)WikiDiscussions master Synced 2w ago

READMEChangelog (10)Dependencies (11)Versions (37)Used By (0)

davidlienhard/database-query-validator
======================================

[](#davidlienharddatabase-query-validator)

🐘 php tool to validate database queries written using [`davidlienhard/database`](https://github.com/davidlienhard/database)

[![Latest Stable Version](https://camo.githubusercontent.com/da0c44fe820d9f5d846bdad91bcb72b252529b140ad70a2824069e1329af4231/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f762f64617669646c69656e686172642f64617461626173652d71756572792d76616c696461746f722e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/davidlienhard/database-query-validator)[![Source Code](https://camo.githubusercontent.com/4bfc71ba32f5bfc645b4e6e0bc67147e67e7eaa2815c42ce79e7af964c8c7fa2/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f736f757263652d64617669646c69656e686172642f64617461626173652d2d71756572792d2d76616c696461746f722d626c75652e7376673f7374796c653d666c61742d737175617265)](https://github.com/davidlienhard/database-query-validator)[![Software License](https://camo.githubusercontent.com/55c0218c8f8009f06ad4ddae837ddd05301481fcf0dff8e0ed9dadda8780713e/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f6c6963656e73652d4d49542d627269676874677265656e2e7376673f7374796c653d666c61742d737175617265)](https://github.com/davidlienhard/database-query-validator/blob/master/LICENSE)[![Minimum PHP Version](https://camo.githubusercontent.com/7f91fd16f805b376c8b9137ddc479aabdc9f79d19807832f85606cb3b74409c4/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f7068702d253345253344253230382e302d3838393242462e7376673f7374796c653d666c61742d737175617265)](https://php.net/)[![CI Status](https://github.com/davidlienhard/database-query-validator/actions/workflows/check.yml/badge.svg)](https://github.com/davidlienhard/database-query-validator/actions/workflows/check.yml)

Configuration
-------------

[](#configuration)

This tool requires a file named `query-validator.json` in your main project directory. CLI arguments are not supported at the moment. The following configuration options are possible:

- **`paths`** (`array`): list of paths (folders or files) to scan.
- **`exclusions`** (`array`): list of paths to exclude from the scans
- **`dumpfile`** (`string`): path to a mysql dump file to use for type-checks
- **`parameters`** (`object`):
    - `ignoresyntax` (`bool`): whether or not to ignore syntax-errors in the queries
    - `strictinserts` (`bool`): checks if inserts contains all text-colums of table that are set to not null
    - `strictinsertsignoremissingtablenames` (`bool`): whether to ignore queries where the tablename could not be extracted on strict imports

All paths are relative to the path of the configuration file. If no configuration file can be found all the files in your currect folder will be scanned.

### Example Configuration-File

[](#example-configuration-file)

#### JSON

[](#json)

```
{
    "paths": [
        "src"
    ],
    "exclusions": [
        "**/exclude.php"
    ],
    "dumpfile": "dump.sql",
    "parameters": {
        "ignoresyntax": false,
        "strictinserts": false
    }
}
```

#### YAML

[](#yaml)

```
paths:
  - src
exclusions:
  - "**/exclude.php"
dumpfile: dump.sql
parameters:
  ignoresyntax: false
  strictinserts: false
```

Todo
----

[](#todo)

This project is still work in progress and there is a lot of work todo.

- improve validation of queries
- improve documentation (of course)
- add unit tests
- improve recognition of database-queries
- improve config
    - add support of CLI arguments

License
-------

[](#license)

The MIT License (MIT). Please see [LICENSE](https://github.com/davidlienhard/httpclient/blob/master/LICENSE) for more information.

###  Health Score

49

—

FairBetter than 94% of packages

Maintenance75

Regular maintenance activity

Popularity23

Limited adoption so far

Community9

Small or concentrated contributor base

Maturity72

Established project with proven stability

 Bus Factor1

Top contributor holds 52.3% 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 ~62 days

Recently: every ~283 days

Total

28

Last Release

262d ago

PHP version history (2 changes)0.0.1PHP ^8.0

0.4.10PHP ^8.4

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/43143441?v=4)[David Lienhard](/maintainers/davidlienhard)[@davidlienhard](https://github.com/davidlienhard)

---

Top Contributors

[![davidlienhard](https://avatars.githubusercontent.com/u/43143441?v=4)](https://github.com/davidlienhard "davidlienhard (124 commits)")[![dependabot[bot]](https://avatars.githubusercontent.com/in/29110?v=4)](https://github.com/dependabot[bot] "dependabot[bot] (113 commits)")

---

Tags

databaselibrarymysqlphpphpdatabaselibrarymysql

###  Code Quality

TestsPHPUnit

Static AnalysisPHPStan

Code StylePHP\_CodeSniffer

Type Coverage Yes

### Embed Badge

![Health badge](/badges/davidlienhard-database-query-validator/health.svg)

```
[![Health](https://phpackages.com/badges/davidlienhard-database-query-validator/health.svg)](https://phpackages.com/packages/davidlienhard-database-query-validator)
```

###  Alternatives

[tempest/framework

The PHP framework that gets out of your way.

2.3k37.6k21](/packages/tempest-framework)[contao/core-bundle

Contao Open Source CMS

1301.7M3.1k](/packages/contao-core-bundle)[ssch/typo3-rector

Instant fixes for your TYPO3 PHP code by using Rector.

2613.3M489](/packages/ssch-typo3-rector)[pimcore/pimcore

Content & Product Management Framework (CMS/PIM/E-Commerce)

3.8k3.9M535](/packages/pimcore-pimcore)[shopware/platform

The Shopware e-commerce core

3.4k1.5M3](/packages/shopware-platform)[shopware/core

Shopware platform is the core for all Shopware ecommerce products.

595.8M672](/packages/shopware-core)

PHPackages © 2026

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