PHPackages                             webmatch/wbm-query-manager - 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 &amp; ORM](/categories/database)
4. /
5. webmatch/wbm-query-manager

ActiveShopware-plugin[Database &amp; ORM](/categories/database)

webmatch/wbm-query-manager
==========================

Database-Management plugin for Shopware

2.0.4(7y ago)11443[1 issues](https://github.com/webmatch/WbmQueryManager/issues)[1 PRs](https://github.com/webmatch/WbmQueryManager/pulls)GPL3PHP

Since Mar 1Pushed 4y ago11 watchersCompare

[ Source](https://github.com/webmatch/WbmQueryManager)[ Packagist](https://packagist.org/packages/webmatch/wbm-query-manager)[ RSS](/packages/webmatch-wbm-query-manager/feed)WikiDiscussions master Synced yesterday

READMEChangelog (5)Dependencies (1)Versions (6)Used By (0)

WbmQueryManager - Database-Management plugin for Shopware
=========================================================

[](#wbmquerymanager---database-management-plugin-for-shopware)

[![Scrutinizer](https://camo.githubusercontent.com/626114916380b272594e5ce94612d51df10ae54ef90eec5e676fd5af667a13f9/68747470733a2f2f7363727574696e697a65722d63692e636f6d2f672f7765626d617463682f57626d51756572794d616e616765722f6261646765732f7175616c6974792d73636f72652e706e673f623d6d6173746572)](https://scrutinizer-ci.com/g/webmatch/WbmQueryManager/?branch=master)[![Travis CI](https://camo.githubusercontent.com/50df1b6b5d78e2276b311dbe6f87d71c523bc70da5b987cd4f60742212f71924/68747470733a2f2f7472617669732d63692e6f72672f7765626d617463682f57626d51756572794d616e616765722e7376673f6272616e63683d6d6173746572)](https://travis-ci.org/webmatch/WbmQueryManager)

This plugin integrates a new module within the [Shopware](https://www.shopware.de) backend that allows for a simple management of SQL queries and their manual or automated execution.

[![WbmQueryManager](https://camo.githubusercontent.com/7486e641accc86e9e490cbef8d1308005b2f6ef1f72687cf02454afb81ad8890/68747470733a2f2f7777772e7765626d617463682e64652f77702d636f6e74656e742f75706c6f6164732f323031372f30322f71756572795f6d616e616765725f73637265656e2e706e67)](https://camo.githubusercontent.com/7486e641accc86e9e490cbef8d1308005b2f6ef1f72687cf02454afb81ad8890/68747470733a2f2f7777772e7765626d617463682e64652f77702d636f6e74656e742f75706c6f6164732f323031372f30322f71756572795f6d616e616765725f73637265656e2e706e67)

The plugin offers the following features:

- Write, edit, delete, duplicate and run queries
- Shows fetched rows within backend immediately
- Download fetched rows as CSV format
- Execute queries in regular intervals as cron-jobs
- Cron-Jobs: Logging of fetched rows in CSV format
- Cron-Jobs: Send emails with attached log-files
- SQL syntax highlighting (Codemirror)
- Syntax and table structure autocompletion (Codemirror)

Requirements
------------

[](#requirements)

- Shopware &gt;= 5.2.0

**Optional:**

- MySQL Improved Extension (MySQLi)
    - enables the fetching of more than one rowsets per query by multiple statements (*multi\_query*)

Installation
============

[](#installation)

Clone this repository into a folder **WbmQueryManager** within the **custom/plugins** directory of the Shopware installation.

Install the plugin through the Plugin-Manager within the Shopware backend. Activate the plugin and when prompted allow for the clearing of the listed caches. Reload the backend to complete the installation.

Install with composer
---------------------

[](#install-with-composer)

- Change to your root Installation of shopware
- Run command `composer require webmatch/wbm-query-manager` and install and activate plugin with Plugin Manager

Usage
=====

[](#usage)

The module will be accessible in backend through a new menu point under the Settings menu tab.

The plugin comes with a few example queries which can be safely deleted.

Configuration
=============

[](#configuration)

The plugin offers a few basic configuration options:

- *Send CSV Exports to an E-Mail Address*
    - (see **Cron-Jobs** below)
- *CSV Field Separator*
    - (see **Cron-Jobs** below)
- *Active SQL Autocompletion*
    - if the autocompletion of syntax isn't desired it can be disabled

Cron-Jobs
=========

[](#cron-jobs)

To use the cron-job features of this plugin please first make sure the plugin **Cron** is installed in Plugin Manager and the Cron-Job **Query Manager** is activated in the cron job settings.

Shopware Cron-Jobs can be executed via request of the URL (e.g. ) or by console command **php bin/console sw:cron:run** (recommended)

Your server has to be setup accordingly to either request the cron URL or run the console command in regular intervals. This interval naturally also determines the minimum interval that Shopware cron-jobs can be executed at.

Fetched rows of SELECT statements executed through cron-jobs will be logged as CSV files in the directory **var/logs** of the Shopware installation. By specifying an email address in the plugin configuration logged files will also be transmitted by email.

License
=======

[](#license)

MIT

This plugin is also commercially available through Shopware's community store. While the code itself is released under MIT license, the commercial distribution includes support through Webmatch GmbH and continous auto-updates. You may use this plugin without purchase but please be aware that you may receive notifications through Shopware about missing the according license. We have no influence on those notifications.

###  Health Score

32

—

LowBetter than 69% of packages

Maintenance18

Infrequent updates — may be unmaintained

Popularity16

Limited adoption so far

Community17

Small or concentrated contributor base

Maturity67

Established project with proven stability

 Bus Factor1

Top contributor holds 80% 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 ~169 days

Total

5

Last Release

2731d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/69c1745bd6023c706f651e9bdb38515fc7678caf52b9580126141381168669cd?d=identicon)[dneustadt](/maintainers/dneustadt)

![](https://www.gravatar.com/avatar/daa48953cb1d431a19f5d2fd52474d67d8723822c5054ef407a99cfea09f94f4?d=identicon)[webmatch](/maintainers/webmatch)

---

Top Contributors

[![dneustadt](https://avatars.githubusercontent.com/u/9033214?v=4)](https://github.com/dneustadt "dneustadt (8 commits)")[![larsbo](https://avatars.githubusercontent.com/u/754074?v=4)](https://github.com/larsbo "larsbo (1 commits)")[![nicoanders](https://avatars.githubusercontent.com/u/17621904?v=4)](https://github.com/nicoanders "nicoanders (1 commits)")

---

Tags

databasequeryshopwareshopware-plugindatabaseshopwarequeryshopware-plugin

### Embed Badge

![Health badge](/badges/webmatch-wbm-query-manager/health.svg)

```
[![Health](https://phpackages.com/badges/webmatch-wbm-query-manager/health.svg)](https://phpackages.com/packages/webmatch-wbm-query-manager)
```

###  Alternatives

[aura/sqlquery

Object-oriented query builders for MySQL, Postgres, SQLite, and SQLServer; can be used with any database connection library.

4883.1M37](/packages/aura-sqlquery)[envms/fluentpdo

FluentPDO is a quick and light PHP library for rapid query building. It features a smart join builder, which automatically creates table joins.

922530.0k13](/packages/envms-fluentpdo)[lichtner/fluentpdo

FluentPDO is a quick and light PHP library for rapid query building. It features a smart join builder, which automatically creates table joins.

930286.0k6](/packages/lichtner-fluentpdo)[bvanhoekelen/performance

PHP performance tool analyser your script on time, memory usage and db query. Support Laravel and Composer for web, web console and command line interfaces.

522846.1k5](/packages/bvanhoekelen-performance)[fpdo/fluentpdo

FluentPDO is a quick and light PHP library for rapid query building. It features a smart join builder, which automatically creates table joins.

924251.8k8](/packages/fpdo-fluentpdo)[tpetry/laravel-query-expressions

Database-independent Query Expressions as a replacement to DB::raw calls

361609.7k3](/packages/tpetry-laravel-query-expressions)

PHPackages © 2026

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