In my startup, the customer support team frequently needs to retrieve certain information from our MongoDB database to assist customers. However, they have little to no coding experience and don’t know MongoDB queries.
Currently, they rely on developers to run queries and fetch the required data, creating a bottleneck. We want a better solution to give them direct access to the specific data they need without overburdening the dev team.
The challenge is we don’t want to grant the customer support team full access to the database, as some data is confidential. We need a way to limit their access to only the required datasets/collections.
Has anyone dealt with a similar situation? What approaches have you taken to provide restricted MongoDB data access to non-technical teams like customer support?

Currently I am searching for any solutions on the internet that might solve this issue.