How do you query Firestore from a local desktop GUI?

You query Firestore from a local desktop GUI by connecting a service account, opening a collection, and running a filter or a JavaScript snippet on your machine. AppoBase does that on macOS and Windows. Simple mode builds where-clauses with operators. JavaScript mode uses the Monaco editor. AppoBase stores history with scanned counts, filtered counts, and timing.

Read the docs

Table of contents

  1. Why query from the desktop?
  2. How does Simple mode work?
  3. How does JavaScript mode work?
  4. What does query history record?
  5. Query questions

Why query Firestore from a local desktop GUI?

You query Firestore from a local desktop GUI so the Admin SDK call stays on your computer with the service account. AppoBase keeps that key in the Electron main process. The Firebase console query form does not offer a JavaScript editor or a saved history of runs.

A local GUI also opens named databases in separate tabs. That matters when one Firebase project has more than the default database.

How does Simple query mode work in AppoBase?

Simple query mode in AppoBase works as a visual filter builder. You pick a field, an operator, and a value. Operators include ==, !=, >, <, array-contains, in, and not-in. Field suggestions come from documents already loaded for that collection.

Run the query from the builder. Results land in Tree, Table, List, or JSON. Export to JSON is included.

How does JavaScript query mode work in AppoBase?

JavaScript query mode in AppoBase works inside a Monaco editor with syntax colors and document-field autocomplete. Comment and uncomment with Ctrl+/ or Cmd+/. Use it when a visual filter cannot express the clause you need.

Execution logs report total documents scanned, filtered count, and time. Those numbers sit next to the editor after a run.

What does AppoBase query history record?

AppoBase query history records each run per collection. You can search the list, open a past query, and replay it with one click. The Firebase console does not keep that list. History is the reason to query Firestore from a local desktop GUI after the first week of use.

Background tasks track long exports so you can keep editing while a job runs. Progress stays in the app until the task finishes or fails.

Query questions

These questions repeat the same unique phrase used in the opening: query Firestore from a local desktop GUI. Answers stay inside AppoBase's two query modes, query history, and the emulator connection documented on the homepage FAQ.

Can AppoBase query the Firestore emulator?

AppoBase can query the Firestore emulator. Point the connection at the local emulator instance, typically localhost:8080 for Firestore, then run Simple or JavaScript queries the same way as production.

Does AppoBase include JavaScript query mode?

AppoBase includes JavaScript query mode in a Monaco editor. Simple mode remains the visual filter builder. History and replay sit next to both modes after a run.

You query Firestore from a local desktop GUI by connecting a service account and running Simple or JavaScript filters on your machine. AppoBase is that GUI for macOS and Windows, with history and logs. Download AppoBase from the homepage.

See pricing