By the way, should Quarry be able to access the tools' databases when they have a _p suffix? I'm getting "Access denied for user 's52788'@'%' to database 's54020__wsexport_test_p'". Is it possible to give it access to both databases?

Not at the moment. T173511 did not go anywhere.

Mentioned in SAL (#wikimedia-cloud) [2019-08-30T16:19:24Z] <bd808> drop database s54020__wsexporttest_p; (T230758)

$ sudo become wsexporttest
$ sql toolsdb
...
MariaDB [(none)]> drop database `s54020__wsexporttest_p`;
Query OK, 0 rows affected (0.01 sec)

MariaDB [s54020__wsexport_test_p]> use s54020__wsexporttest_p;
ERROR 1049 (42000): Unknown database 's54020__wsexporttest_p'

I thought you should be able to do this as the tool account, but I wasn't 100% sure so I tried it. Turns out that yes a tool account has the ability to drop databases it has created.

I am sure I tried to do drop it myself before creating this task! I think I didn't try hard enough. Sorry to waste your time. :) Thanks for sorting it out, and thanks both of you for the information about Quarry access. (For the wsexport tool, we'll build custom reports of the data.)