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.
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► MongoDB (any includes Atlas)► PostgreSQLKEY 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 logsWe 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 connectionsMANAGE 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 queriesEDIT► 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 tableBasic features of “Database Browser” is FREE to start.Advanced features like Edit, Automatic (background) Execution and enhanced quota are available for paid plansSUPPORTFor 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