Ohh, actually the sql file was in the module folder, I thought is in the utils/kamctl/{mysql,postgres,...}. So it is in the wrong place.
Yes, the best is to create xml definition as for location (usrloc module), then you can do 'make dbschema' to get the sql files generated. You may need to update the Makefile in the schema folder.