Database Browser Support
Frequently Asked Questions (FAQs)
What are the databases supported?
Currently, the following databases are supported
We are looking at supporting more databases in the future
I want to use Database Browser for DB2. How do I go about it?
Google add-ons do not directly support connecting with DB2 (and other databases). If you are seriously looking for connectivity to certain database and willing to pay for the integration, please contact us at the coordinates below.
Can I delete records from table using Database Browser?
To avoid accidental mistakes or misuses, Database Browser does not allow any deletion of data from database/ tables.
Is there a test database to check Database Browser?
Yes, you can use the test database details to play with Database Browser add-on. Please note that this is a sandbox test database environment and have maintenance and restarts without notice.
I get error when connecting to Google Cloud SQL inspite of giving all connection information correctly. What is wrong?
Please check whether Google Cloud SQL is configured to be connected from Apps Script. Refer "Setup for Google Cloud SQL" section in https://developers.google.com/apps-script/guides/jdbc
How do I specify a port in the connection?
You can specify the port in the IP address field with :<port> as a suffix. Please see the sample below.
Can I connect to databases running in my machine (localhost) or in LAN?
Remember that Google Sheet and the add-on is running in the cloud server. To connect a database from Database Browser add-on,
- the machine / instance where your database is running must be connected with Internet
- IP address / domain of the machine is exposed as public static IP and
- access to the port is enabled in the database.
If you make these configuration in your database machine, it can be connected.
How many rows can I generate with Pro license?
The free plan has a max results limited to 100.
There is no limit on the max results for Pro user. However, you need to consider the GSuite limitations on the number of cells, execution time, Spreadsheet usage limits etc when planning the max results. Approximately, 25000 records for a medium size table would be a safe maximum level.
How many spreadsheet can I use for 1 pro license?
There is no limit on the number of spreadsheets and number of queries. The underlying GSuite limits (Spreadsheet, Execution time, External query etc limits) are the limits. The license is attached to a GSuite/Gmail user (identified by email).