Cube to download a complete subset of data via SFTP (two strategies proposed) and remotely query the database. Check this link for the complete documentation.

This module allows remote quering in the database. It's available on pypi:

It provides meethods to script requests to a cubicweb database and inherits from the rql_download cube.

This module allows to setup a SFTP service on the server hosting your database. Thus, all query results are accessible (we use the python_fuse package or Twisted to build the filesystem) through a predefinite SFTP repository. Users can then access and download their data using the SFTP protocol.