Frequently Asked Questions
What are the databases supported?
Please check Supported Databases page for the details. We are looking at supporting more databases in the future. Let us know if you want support for certain database.
How do I select specific fields from a table and query on specific condition and order?
You can use the wizard option to select the fields from a table, apply filters and set sort order before executing the query.
Can I update records from table using Database Browser?
Yes, you can update records using "Edit" feature in Database Browser add-on. Note that this is a pro feature.
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.
Can I run complex queries joining multiple tables?
Yes, you can write direct custom SQL and execute it in Database Browser. Note that this is a pro feature.
Do I need to keep the Google Sheet open to have my queries execute in the background?
No. The background process runs automatically even if you have not opened the Google Sheet.
I have setup everything but why Automatic Schedule is not getting executed?
How many rows can I generate with Pro license?
The free plan has a max results limited to 10 records.
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).