I have successfully connected an external database using this mysql-adapter (https://github. com/wix/corvid-external-db-mysql-adapter). I am able to modify data and insert rows (by clicking the plus button at the bottom of the table) in Content Manager. However, I am not able to insert fields or delete rows. When I hover over the add fields button, I got “this is read-only collection” (but it’s not really read-only since I can modify and add rows…).
Does anyone know if external collection is “read-only” in general , or there is something missing in the adapter codes? For example, I know I don’t have an add-fields endpoint, that is probably why I can’t add fields. But I can’t find any spec of such end-point either, so I’m not sure what request payload to expect. Moreover, I guess whatever metadata of the table fetched by Wix already decides to disable the add-field button.
Currently any action is allowed regardless of the request role. I am the admin which has the permission to read, write, update and remove (I also can’t change the permission setting at all…). “allowedOperations” is set to [“get”, “find”, “count”, “update”, “insert”, “remove”].
Any help is appreciated 
