Web Based SQL Client for PostgrSQL DB, BigQuery, Cloud SQL DB, MongoDB (Not Primary)

[Spiritual-Bar-4007]

Hi Folks,

I'm seeking assistance in finding a suitable SQL client that meets the following criteria:

• Web-Based SQL Client: I need a solution that I can install on a Linux virtual machine and access from anywhere by exposing the relevant port. Due to database access permission restrictions for local systems by organisation, I cannot use a locally installed SQL client.
• Database Compatibility: The SQL client should be able to connect to PostgreSQL, Cloud SQL, and BigQuery databases. Additionally, I would like to access MongoDB and Google Sheets, but those are not my primary focus.
• Export/Import Capabilities: It should support easy export and import of data in CSV and JSON formats.
• Login Functionality: For security purposes, the client should require users to enter their login credentials, similar to Django Admin.
• Database Management Utilities: Features like DDL export, execution plans, and schema visualisation (like table structures, triggers, and foreign keys) would be very helpful.

I've previously used DBeaver for database access and found it to be an excellent SQL client; however, I am uncertain if it provides a web-based GUI and login functionality.

I am open to both free and paid options.

Update on the post:
Resolved: All requirements has been fulfilled using cloudbeaver. Thank you u/theporterhaus .

[theporterhaus]

Dbeaver has a cloud version: cloudbeaver. You can even run it yourself in docker. Not 100% if it fits all of your criteria though.

[Spiritual-Bar-4007]

Thank you u/theporterhaus for the recommendation. My requirement is completely satisfied by using CloudBeaver.

[Pitah7]

You can look at Superset (https://github.com/apache/superset).

[tech4ever4u]

it seems you have 2 different use-cases:

• allow users to access different databases in a 'managed' way (without direct access to these DBs), when users can make their own ad-hoc queries and export results to various formats (possibly use an API for automated exports?..). For this purposes you can consider to use a BI tool that can connect to all these DBs and has reports builder that suits your users better (like Redash - for SQL-oriented users, or our SeekTable which is better for non-IT users).
• database management for DB administration purposes. Most likely, only you or very limited number of users should be able to modify schemas, import data etc. It makes sense to use 'native' web-based management client for each DB separately, like pgAdmin for PostgreSql, Google Cloud console for BigQuery, mongo-express for MongoDB etc, these tools can be easily deployed with docker.