Play with Databases right from Google Sheets
Never feel out of data.
Connect, run queries, edit data with rich set of databases and prepare dashboard in your favourite Google Sheet.
What is Database Browser ?
Database Browser is a Google GSuite add-on that makes Google Sheet an awesome new way of browsing your database (RDBMS like MySQL, Oracle, MS SQL Server and noSQL services like mLab - MongoDB).
You can connect to the database, list the tables, query records of table into Google Sheet with an intuitive and vibrant GUI.
It is product from Jivrus Technologies
Who needs Database Browser ?
- Database Browser is created for making things easier for developers, admin, testers, customers or any one who wants to query/edit database without any coding and display/ store results into Google Sheet.
- This “Database Browser” add-on provides an easy GUI for establishing connection with databases, browsing tables and querying records out to Google Sheet.
- Key Features are
- 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 - Edit the data in the database directly from Google Sheet and saving into database
We are on a mission to make it easy to explore databases at the comfort of Google Sheet.
Why Database Browser Stands above?
This “Database Browser” add-on provides an easy GUI for establishing connection with databases, browsing tables and querying records out to Google Sheet.
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 edit data directly from Google sheet
"Found this tool when trying to connect MS SQL server and Google Data Studio. Had to contact support for a very small issue. Support was very responsive and full helpful. My issue was solved quickly. (Make sure you're using the account in Google Sheets you downloaded the add-on with and signed out of other Google accounts.) This tool is great and very well done. Big Add-on for a small price. Worth every penny!!"
- Wally Green
with 5 star rating
"Best function and price -- better than all of the other options of Google Scripts and Add-Ons that I've tried for connecting to a MySQL database. And the developers were on it when I made a suggestion and they improved the product in under a day -- great work!"
- Bwana Bill
with 5 star rating