Database Browser makes Google Sheets™ an awesome new way of interacting with your databases. Connect the database, list the tables/objects, query records of tables into Google Sheets™, edit data, and automate with an intuitive and vibrant GUI.

This “Database Browser” add-on provides an easy GUI for establishing and maintaining connections with databases, extensive query features, simple editing, and automatically scheduled refreshes from Google Sheets™.


SUPPORTED DATABASES

►  MySQL

►  Oracle

►  PostgreSQL

►  Microsoft SQL Server

►  Google Cloud SQL

►  Google BigQuery

►  Firestore

►  Datastore

►  MongoDB (including Atlas Cloud)




KEY FEATURES

►  Manage Connections - Create, test, and save connections to any of your databases on the Internet and cloud.

►  Manage Queries - Build, execute, and save queries and query results into Google Sheets™.

►  Edit - Insert and Update records in the database table by adding and changing data from Google Sheets™ 

►  Automatic execution of the query in the background on a pre-scheduled time with detailed execution history logs

We are on a mission to make it easy to explore databases in the comfort of Google Sheets™.



MANAGE CONNECTIONS

►  User can prepare the connection by providing Database Type, Host IP Address, Database name, Username, Password, or other parameters

►  User can provide a name to the connection so that it can be referred to in the query

►  User can test whether a connection is successfully established for the given configuration

►  User can list, add, modify, and delete connections


MANAGE QUERIES

►  User can prepare the query by selecting connection, tables, and fields of the table

►  User can prepare the query where clause by visually selecting fields and forming conditions

►  User can provide a name to the query

►  User can execute a query and display/ store results in Google Sheets™

►  User can list, add, modify, and delete queries


EDIT

►  User can add a new row in the Google Sheets™ that gets added to the database table

►  User can update a row in Google Sheets™ that gets updated in the database table


AUTOMATE

►  User can schedule automatic execution of the query with an extensively designed scheduling: hourly, daily, weekly, monthly, multiple periods on any timezone

►  User can see the execution history with logs to show the status and details of the execution that happened in the background.


The basic features of “Database Browser” is FREE to start.
Advanced features like Edit, Automatic (background) Execution, and enhanced quota are available for paid plans


SUPPORT

For more details refer http://databasebrowser.jivrus.com/
Contact us at http://www.jivrus.com/about/contact-us or email support@jivrus.com for any query or feature request.