Database Browser

Description

Database Browser makes Google Sheet an awesome new way of browsing your database. Connect the database, list the tables, query records of table into Google Sheet with an intuitive and vibrant GUI.

This “Database Browser” add-on provides an easy GUI for establishing connection with databases, browsing tables and querying records out to Google Sheet.


SUPPORTED DATABASES

► MySQL

► Oracle

► Microsoft SQL Server

► Google Cloud SQL

► Google BigQuery

► mLab - MongoDB

► Firestore

► Datastore


KEY FEATURES

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

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

► Edit - Insert and Update records in database table by adding and changing data from Google sheet (this is a pro feature)

► Automatic execution of query in the background and execution history logs

We are on a mission to make it easy to explore databases at the comfort of Google Sheet.



MANAGE CONNECTIONS

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

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

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

► User can list, add, modify, 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 into Google Sheet

► User can list, add, modify, delete queries


EDIT

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

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


Basic features of “Database Browser” is always FREE.
Pro features like Edit, Automatic (background) Execution are available as paid features


SUPPORT

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