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

firebase firebase-realtime-database firebase-console

40,487

Solution 1

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).

Solution 2

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.

Solution 3

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.

40,487

Author by

mohan mishra

Updated on July 05, 2022

Comments

mohan mishra almost 2 years

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
Plugie about 7 years

is firebase admin trusted ?
Konrad Kiss about 7 years

The source is available at github.com/codefoxes/firebase-admin - so you can make sure it's safe.
user2078023 almost 7 years

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.
Frank van Puffelen almost 7 years

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 stackoverflow.com/questions/37482366/…
Yaroslav almost 7 years

This app is unstable and doesn't work properly.
ankur agrawal over 6 years

Docs link on this site is dead.
Fox5150 about 6 years

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.
alex_1948511 about 6 years

Cloud Firestore isn't seems working
Yogi about 6 years

Agree with @Fox5150. I was able to run FireBase Admin and connect, but the app doesn't appear to do anything useful.
Yogi about 6 years

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.
Milan almost 6 years

does not work with Firestore , works fine with realtime db
Vasco over 5 years

Currently the firebase console for firestore supports this feature.It supports sorting and applying filters to listing of a collection.
Frank van Puffelen over 5 years

Good point. I added that.
Konstantin Konopko over 5 years

It also seems to the website is under virus
Leonardo G. almost 5 years

Firestore support is in current development, I have just tried it out: github.com/JoeRoddy/firestation#firestore
Aman Kumar about 4 years

Firestation don't work for firestore
Patrick about 4 years

Looks like it's no longer in development for Firestore.
Wesley Barnes about 3 years

Just saw this new tool - firestudio.app, cant do much but looks like its still new
lazydevpro almost 3 years

This link is also dead