Database Browser makes Google Sheet an awesome new way of connecting, browsing and querying your database right from the sheet.
This “Database Browser” add-on provides an easy GUI for establishing connection with databases, browsing tables and querying records out to Google Sheet.
► 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)
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
► 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 always free.
Pro features like Edit, Automatic (background) Execution are available as paid features
For more details refer http://www.jivrus.com/products/database-browser
Contact us at http://www.jivrus.com/contact-us or email email@example.com for any query or feature request.