Is there any UI Console where I can query the Firebase Database?

Question

Is there any UI Console where I can query the Firebase Database?? Basically I wish to query the data just like we can query other databases using UI

Frank van Puffelen · Answer 1 · 2018-12-11T14:11:32.813

28

The Firebase Console has built-in support for sorting and filtering the data in a Firestore collection. Click the little filter icon at the top of the collection (next to the overflow menu ).

Many developers also use a local node.js script/REPL (such as in this video tutorial explaining Firebase Queries) or set up a jsfiddle/jsbin (such as in this question).

edited Dec 11 '18 at 14:11

answered Jul 17 '16 at 17:56

Frank van Puffelen

565,676
79
828
807

Isn't the web (jsbin) solution a security breach? Using the jsbin logic (web) allows anybody to get the credentials of the firebase db and view the entire database contents. – user2078023 Aug 21 '17 at 08:43
1

The configuration data in the jsbin are just project identifiers: they identify a Firebase project on the Google servers. They are not user credentials, which identify a user. You can share the configuration data, but still mark the database as only accessible to specific users. See https://stackoverflow.com/questions/37482366/is-it-safe-to-expose-firebase-apikey-to-the-public – Frank van Puffelen Aug 21 '17 at 09:41
1

Currently the firebase console for firestore supports this feature.It supports sorting and applying filters to listing of a collection. – Vasco Dec 11 '18 at 13:27
Good point. I added that. – Frank van Puffelen Dec 11 '18 at 14:11

Konrad Kiss · Answer 2 · 2019-03-18T09:10:51.657

17

EDIT: As mentioned in the comments, the docs link is currently dead. This project might be abandoned. Please try the next answer.

EDIT 2: I removed links to the software and docs since it looked like some phishing website took over the domain.

Original answer:

Check out Firebase Admin. It's a UI for Linux, OSX and Windows and it has a Query tab that lets you experiment with queries.

Read the docs on how to create the private key the app needs to connect to your project.

edited Mar 18 '19 at 09:10

answered Nov 03 '16 at 08:34

Konrad Kiss

6,856
1
20
21

1

is firebase admin trusted ? – Plugie Jun 01 '17 at 01:32
The source is available at https://github.com/codefoxes/firebase-admin - so you can make sure it's safe. – Konrad Kiss Jun 01 '17 at 15:14
4

This app is unstable and doesn't work properly. – Yaroslav Sep 03 '17 at 10:58
6

Docs link on this site is dead. – ankur agrawal Jan 22 '18 at 09:07
5

May 2018 , FireBase Admin latest release is 2016 ... The Docs link is still dead ... Don't loose your time trying to use this app ... It doesn't work. – Fox5150 May 20 '18 at 10:00
1

Agree with @Fox5150. I was able to run FireBase Admin and connect, but the app doesn't appear to do anything useful. – Yogi Jun 23 '18 at 06:28
It also seems to the website is under virus – Konstantin Konopko Mar 17 '19 at 12:36

score 13 · Answer 3 · edited Sep 21 '21 at 01:56

13

I found and have been using Firestation. Can be used on windows, mac, and linux. I would say to check it out. You can run sql queries against your firebase database.

You can view the source here.

edited Sep 21 '21 at 01:56

Community

1
1

answered Nov 16 '17 at 14:19

kelsheikh

1,278
3
17
37

5

Cloud Firestore isn't seems working – alex_1948511 Jun 15 '18 at 06:06
2

I was able to download and connect using Firestation. However, I didn't find it very useful. The features are about the same as Firebase Admin with the addition of sql like queries. – Yogi Jun 23 '18 at 06:42
2

does not work with Firestore , works fine with realtime db – Milan Sep 10 '18 at 05:12
2

Firestore support is in current development, I have just tried it out: https://github.com/JoeRoddy/firestation#firestore – Leonardo G. Aug 22 '19 at 00:27
1

Firestation don't work for firestore – Aman Kumar May 01 '20 at 23:32
Looks like it's no longer in development for Firestore. – Patrick May 14 '20 at 17:28
Just saw this new tool - https://firestudio.app/, cant do much but looks like its still new – Wesley Barnes Jun 06 '21 at 09:31
This link is also dead – lazydevpro Jul 22 '21 at 07:19

Is there any UI Console where I can query the Firebase Database?

3 Answers3

Linked