Query for Craft CMS

This plugin lets users execute SQL queries and view their results in Craft CMS.

WARNING: This plugin is for development purposes only and should not be installed in a production environment.

Requirements

This plugin requires Craft CMS 4.0.0+ or 5.0.0+ or 6.0.0-beta.1+ with the craftcms/yii2-adapter package.

Installation

You can install this plugin from the Plugin Store or with Composer.

From the Plugin Store

Go to the Plugin Store in your project’s control panel and search for “Query”. Then press Install in its modal window.

With Composer

Open your terminal and run the following commands:

# go to the project directory
cd /path/to/my-project.test

# tell Composer to load the plugin
composer require craftcms/query

# tell Craft to install the plugin
./craft install/plugin query

On Craft CMS 6, install the craftcms/yii2-adapter package alongside the plugin, and install the plugin with Artisan:

composer require craftcms/yii2-adapter "craftcms/query:^3.0"
php artisan craft:plugin:install query

Usage

Execute SQL queries by navigating to Utilities → Query in the control panel.