Google Firebase and SQLTabs

Google Firebase and SQLTabs

SQLTabs supports quieries to Google Cloud Firestore NoSQL database. So you can write your queries using javascript and view the results the similar way as it would be a usual table.

First let's connect to the Cloud Firestore. For that you need to get two things: a database URL and a service account file. Go to the Firebase Console, open the project and go to the Project Settings / Service accounts tab. You will find the database URL and the button for generating a new service account file in there.