We are running Couchbase 4.5 on Windows. We’d like to provide developers and some business users access to run N1QL queries via the query tab in the admin console.

The new server roles won’t work for us as we are on Windows and the roles require LDAP integration which apparently does not work with Couchbase on Windows. The read only account does not provide access to the query tab.

It seems like the only option to allow N1QL access is to provide people with the admin password for the cluster which is not really an option.

Any other ideas for providing non-administrators access to use N1QL to query Couchbase buckets? Has anyone developed a query tool that works with Couchbase and does not require providing the administrator password?