You're right in that the developer ought to have control over the kind of index that gets created. Having an ability to lint a DB and check for missing indexes

You're right in that the developer ought to have control over the kind of index that gets created. Having an ability to lint a DB and check for missing indexes would be useful, that could even be useful in a vanilla Postgres (however you want to provide it). Perhaps auto-creating them is a step too far. Note that your statement: "you just don't know what you are doing" comes off as unnecessarily arrogant and off-putting.