README

A Pimcore bundle that adds Adminer as a database administration tool. Use it from Tools → System Info & Tools → Database Administration in the Pimcore admin.

Supports Pimcore 11 and Pimcore 12.

Features

Full Adminer UI (tables, SQL, export, etc.) using your Pimcore database credentials
Single sign-on: no separate Adminer login when logged into Pimcore admin
Optional integration with Pimcore Admin UI Classic (menu entry under System Info & Tools)
Optional Pimcore Studio plugin so the database explorer is available in the Studio UI
UI enhancements: floating table header, timestamp display, SQL suggestions, table filter

Requirements

Pimcore ^11.0 or ^12.0
PHP 8.1+
vrana/adminer (installed automatically by the bundle)

Installation

Install the bundle:

composer require rohit-raj-verma/pimcore-database-explorer

return [
    // ...
    PimcoreDatabaseExplorer\Bundle\DatabaseExplorerBundle\DatabaseExplorerBundle::class => ['all' => true],
];

Install assets:
```
bin/console assets:install --symlink
```
In Pimcore admin go to Tools → System Info & Tools → Database Administration to open the database explorer.

Configuration

The bundle uses your existing Pimcore database connection. No extra configuration is required.

CSRF protection is disabled for the database explorer route so Adminer can work correctly.

Pimcore Admin UI Classic

If you use pimcore/admin-ui-classic-bundle, the bundle registers a Database Administration item under Tools → System Info & Tools. No version constraint is enforced; use any compatible version of the admin UI classic bundle.

Pimcore Studio

If you use Pimcore Studio UI, the bundle can register a Studio plugin so the database explorer is available in the Studio interface. Use any compatible version of the Studio UI bundle.

Build Studio assets

Go to the bundle’s assets directory and install dependencies:

cd vendor/rohit-raj-verma/pimcore-database-explorer/assets
npm install

Build the Studio bundle (output goes to src/Resources/public/build/):
```
npm run build
```
Reinstall bundle assets in your Pimcore project if needed:
```
bin/console assets:install --symlink
```

For development you can run npm run dev in the assets directory for a watch build.

Repository

Git: git@github.com:rohit-raj-verma/pimcore-database-explorer.git
GitHub: https://github.com/rohit-raj-verma/pimcore-database-explorer

License

MIT. See LICENSE or LICENSE.md in this repository.

rohit-raj-verma / pimcore-database-explorer

Maintainers

Details