App Icon
Jivrus Technologies
•  137,504
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

►  MongoDB (any includes Atlas)

►  PostgreSQL


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 FREE to start.
Advanced features like Edit, Automatic (background) Execution and enhanced quota are available for paid plans


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
September 13, 2020
Nice
Is this review helpful?
Yes
No
Profile Picture
Robert Chan
September 11, 2020
I reported these 3 days ago and had no response to these bugs: 1. "Unable to select connection within 'edit' mode." 2. "Unable to filter by date range" Also requested a fund, that had no response.
Is this review helpful?
Yes
No
Profile Pciture
Michaes Subramanian
September 17, 2020
These two features are not yet available on those 2 beta tagged databases (MongoDB and Postgre). These features will become available as the beta databases more into GA (Generally Available). It is a conscious decision of users to use or not to use a beta release (as it is clearly tagged) before the general release.
Profile Picture
A User of Database Browser
July 22, 2020
I was searching for an addon that should extract all my data from my SQL database and save it in my google sheet, so my friend suggested me Database Browser. I tried using this addon, it asked me to create a connection first. I didn't have any idea about it so I looked into their documentation where everything is explained neatly and from there no looking back it worked like a charm form me. Also I am able to schedule my queries which is an extra benefit for me. Thank you Database Browser.
Is this review helpful?
Yes
No
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
1-10 of 26
Additional information
Jivrus Technologies
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu