craftcms/query

Execute database queries from the Control Panel

3.1.0 2024-03-19 23:20 UTC

Requires

• craftcms/cms: ^4.0.0-RC3|^5.0.0-beta.1

Requires (Dev)

• craftcms/ecs: dev-main
• craftcms/phpstan: dev-main
• craftcms/rector: dev-main

MIT

• Pixel & Tonic

• database
• db
• cms
• yii2
• craftcms

README

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+.

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

Usage

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