Query your Database and edit from Google sheet.
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.
► Microsoft SQL Server
► Google Cloud SQL
► Google BigQuery
► mLab - MongoDB
► MongoDB (any includes Atlas)
► 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.
► 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
► 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
► 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 FREE to start.
Advanced features like Edit, Automatic (background) Execution and enhanced quota are available for paid plans
For more details refer http://databasebrowser.jivrus.com/
Contact us at http://www.jivrus.com/about/contact-us or email firstname.lastname@example.org for any query or feature request