New console command to execute a SELECT SQL query on the Piwik DB #12081
Labels
Enhancement
For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc.
Milestone
It would be useful to be able to execute
SELECT
SQL queries on a Piwik instance via a console command, for example./console core:sql "SELECT * FROM segments"
The command should be "safe" ie. we should not allow any SQL queries which include a
DELETE
orTRUNCATE
orUPDATE
orDROP
statement (not sure how we could detect this without false positives ie.SELECT * FROM segment WHERE deleted=0
should work although it containsdelete
)The text was updated successfully, but these errors were encountered: