Jivrus Technologies
•  127,442
Overview
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.


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 support@jivrus.com for any query or feature request.
Reviews
Language:
Sort by:
Profile Picture
A User of Database Browser
May 12, 2020
App does not work at all. I contacted support and they are non-responsive. I have a properly configured MySQL database with white-listed IP addresses and port-forwarding on firewall, but it still doesn't work. I have verified that the connection works from an external network using MySQL Workbench so it's something on Jivrus' end, since it is not working. I even provided them with test credentials at Jivrus' support request, but then they refused to assist me in resolving the issue. Don't waste your time with this plugin as it doesn't work and support will not help you.
Is this review helpful?
Yes
No
Profile Pciture
Michaes Subramanian
May 12, 2020
Google requires a range of IP addresses to be whitelisted on the database to connect from GSuite. Database Browser website documents these in detail on the "Connection Experience" page. The website also provides a test database for users to connect and play with queries. Configuring database correctly with IP whitelisting is to be taken care of by the user/ user's DB admins. The add-on has been used by thousands of users on a daily basis (see stats on the website). However, we do accept that establishing a connection for the first time is not straightforward despite the documentation. Also limitation in connecting to some databases (e.g. PostgreSQL cannot be connected). Implementing the whole connectivity in Jivrus Cloud instead of GSuite is expected to smoothen the connection experience and provide a wide variety of database connectivity. We will do that in the future. This would obviously be costly (due to the development and operational costs of our own cloud). So, as of today, users have the Database Browser as a low-cost tool that integrates between Google Sheets and databases with known limitations and user experiences. Thanks for understanding
Profile Picture
A User of Database Browser
May 4, 2020
It's a great plug-in, a must-have for our business. It's buggy at times but fixed by the developers fairly quickly.
Is this review helpful?
Yes
No
Profile Picture
A User of Database Browser
April 23, 2020
It was so good before problem started to occur from early this week. I have raised a ticket#111537 couple of days ago. Can someone look into that and fix it for us? The connection constantly reset all SQLs to limit 10 lines. Thanks,
Is this review helpful?
Yes
No
Profile Pciture
A user of Database Browser
April 30, 2020
Thanks. The team has been very helpful.
Profile Pciture
Michaes Subramanian
April 30, 2020
Thanks for providing details. This issue is resolved now.
Profile Picture
Adam Van Auken
April 11, 2020
This did exactly what I needed: sync data from a MySQL application to a Google Sheet. Price was reasonable. The most difficult part was establishing the initial connection as it requires whitelisting Google IP addresses. Jivrus has this well documented but this may take you a little while to get right.
Is this review helpful?
Yes
No
Profile Picture
Bruno Andrade, Blueprintt
March 18, 2020
Incredible app with great support!
Is this review helpful?
Yes
No
Profile Picture
Idan Kfir
December 3, 2019
Great app, very easy to use, saves me about an hour a day, god bless your developer team. Can't believe I didn't think of it earlier....
Is this review helpful?
Yes
No
Profile Picture
A User of Database Browser
November 30, 2019
Great tool!
Is this review helpful?
Yes
No
Profile Picture
A User of Database Browser
November 21, 2019
great add-on. but i have a concern, Is there any way to automate the Query every (X) minutes because its highly needed to track information's on the spot and the minimum available automation is 1 hour.
Is this review helpful?
Yes
No
Profile Pciture
A user of Database Browser
March 15, 2020
its a spy app
Profile Pciture
Michaes Subramanian
November 22, 2019
Thanks. We would love to provide minutes level interval for schedule but it is a GSuite (Google) restriction of minimum interval of 1 hour only for add-ons.
Profile Picture
Jesus Martin Escalada
September 6, 2019
Great add-on and great support, keep on working hard, well done!!
Is this review helpful?
Yes
No
Profile Pciture
A user of Database Browser
October 24, 2019
B.G.L.T what else would be REBIII
Profile Picture
A User of Database Browser
June 26, 2019
Great way to link database to google sheets for some additional formulas
Is this review helpful?
Yes
No
1-10 of 23
Additional information
Jivrus Technologies
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu