db-query
Execute SQL queries directly on Magento 2 database to retrieve, analyze, or modify data with output in table, JSON, or CSV format.
Instructions
Execute SQL queries directly on Magento 2 database
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| format | No | Output format | table |
| query | Yes | SQL query to execute |
Input Schema (JSON Schema)
{
"properties": {
"format": {
"default": "table",
"description": "Output format",
"enum": [
"table",
"json",
"csv"
],
"type": "string"
},
"query": {
"description": "SQL query to execute",
"type": "string"
}
},
"required": [
"query"
],
"type": "object"
}