How to remove all data from a Firebase database?

Question

I started using a code that using Firebase realtime database. I implemented it to my solution. Connection and control was perfect, so I used it for the production environment.

After a while I was doing upgrade and I need remove all data again - but wait, there are no delete buttons in console anymore at highest root level and only allowed in one selected item at once:

https://console.firebase.google.com/project/{{project_name}}/database/data

In last update shown only this message and no steps what next:

Read-only & non-realtime mode activated to improve browser performance Select a key with fewer records to edit or view in realtime

Q how can I remove all data at once?

Possible duplicate of [Firebase : Read-only & non-realtime mode activated to improve browser performance](http://stackoverflow.com/questions/38651204/firebase-read-only-non-realtime-mode-activated-to-improve-browser-performanc) — Jay, Feb 12 '17 at 16:24
I marked this as a duplicate as the question is very similar to another question, just phrased differently. The other part of the answer, is that it would take literally one line of code ( Swift: *rootRef.setValue(nil)* ) to delete the database, assuming you authenticate as an admin. — Jay, Feb 12 '17 at 16:25
@Jay it is not duplicate because - # this has right title question for issue # this describe exactly fast simple solution. — Bruno, Feb 12 '17 at 19:34

Andrew Roberts · Answer 1 · 2018-02-18T16:54:10.830

68

You can manually create a JSON file that contains a single empty entry and import it, which will remove all existing entries.

edited Feb 18 '18 at 16:54

answered Sep 19 '17 at 12:58

Andrew Roberts

2,720
1
14
26

3

Thanks. Worth an uptick? – Andrew Roberts Sep 20 '17 at 19:16
1

super..:-) fastest way to clear the database..thanks – A B Vijay Kumar Sep 20 '18 at 03:12
1

Haha. NIce. The Firebase guys forgot to keep a feature to manually delete database objects. Thanks! – Vikas Yadav May 12 '20 at 19:13
If anyone is wondering, this works even for DB with high memory, for which the DELETE API fails stating too much data to be updated in one go. – ezvine Aug 18 '23 at 07:36

score 35 · Answer 2 · answered Jan 23 '18 at 20:09

35

A simple way to remove all data from a firebase database is to use the Firebase CLI.

Once the CLI is setted up you just need to use this command and your data will be removed :

firebase database:remove /

answered Jan 23 '18 at 20:09

Charlouze

461
5
4

2

This should be accepted as the correct answer IMO. Using curl / rest for this when there is the firebase CLI tool seems cumbersome and inefficient. – Thijs Koerselman Jul 13 '18 at 12:51
1

Project with multiple database instances can remove all data by specifying specific instance like so: `firebase --instance abcdef-r4566-45rty database:remove /` – Subrat Nov 06 '18 at 05:29

Bruno · Accepted Answer · 2022-03-07T23:25:53.840

Why missing Firebase remove button ?

Alvin from Firebase Support :

Record or node has too much data, which makes the data viewer switch to a read-only/non real time mode to increase the browser's performance.

Remove all data from Firebase from command line

Firebase documentation show Removing Data - just they don't show how remove all data.

For remove all data you can use REST command - which remove whole JSON output on that node level

curl -X DELETE "https://{{project_id}}.firebaseio.com/.json"

so you can do this on every generated "URL node in console" by adding JSON extension

https://{{project_id}}.firebaseio.com/{{path}}/{{path}}/{{path}}/.json

@AlecRust it should work uri auth "https://{{name}}:{{password}}@{{project_id}}.firebaseio.com" — Bruno, Sep 27 '17 at 14:40

score 5 · Answer 4 · edited Jan 15 '19 at 12:26

5

Solution 1: console From your project, click on the x button at the top level of the database.

then click delete

Solution 2: Programmatic

whatever the language you are using , call something like:

database.set('/', null)

Solution 3: Firebase CLI from your project folder (you already installed the firebase-tools) write the following in the terminal then hit Enter :

database:remove /

N.B:

Kindly consider to backup your data first.

edited Jan 15 '19 at 12:26

shifu

672
8
37

answered Apr 13 '18 at 20:54

tabebqena

1,204
1
13
23

FYI, Solution 1 (delete from the Forge), only works if you have a small enough database so that it can show the real-time view. – MandM Aug 26 '19 at 17:58
CLI did the job very well – Yoraco Gonzales Apr 05 '21 at 00:10

score 5 · Answer 5 · answered Jun 05 '19 at 09:36

I used

curl -X DELETE "https://<prject name>.firebaseio.com/.json?auth=<Firebase Database secret>"

This deletes the database also with the data which is blocked from firebase UI. Hope this helps. Thank you

FYI :

Your get Web API key is in https://console.firebase.google.com/project/<database name>/settings/serviceaccounts/databasesecrets

else you can go to Project overview settings >> project settings >> Service Accounts >> Database Secrets

Also I am wanted to comment it on the comments section but due to lack of stackoverflow point I am writing it as answer

score 3 · Answer 6 · edited Dec 16 '17 at 03:10

3

Programmatically you can implement a method, that puts an empty set of data on the main root of database - specifically you can insert a null.

In my Android project it looks like this:

void removeDataFromDatabase(){
    DatabaseReference root = FirebaseDatabase.getInstance().getReference();
    root.setValue(null);
}

edited Dec 16 '17 at 03:10

MechMK1

3,278
7
37
55

answered Dec 15 '17 at 20:21

Mateusz L.

31
3

score 1 · Answer 7 · answered Sep 08 '21 at 06:00

1

Create a new JSON file with content as {}. Go to firebase console click on the 3 dots on right, click on import JSON, choose the newly created JSON file and it will delete all data from the firebase database.

answered Sep 08 '21 at 06:00

IMRAN ABBAS

119
1
2

score 0 · Answer 8 · answered Feb 04 '20 at 16:18

This code helps to remove one by one of your object in firebase realtime database. by path name object removes all children.

FirebaseDatabase.getInstance().getReference("yourReferance").addChildEventListener(new ChildEventListener() {
            @Override
            public void onChildAdded(@NonNull DataSnapshot dataSnapshot, @Nullable String s) {
                for(DataSnapshot data : dataSnapshot.getChildren()) {
                    data.getRef().removeValue().addOnSuccessListener(new OnSuccessListener<Void>() {
                        @Override
                        public void onSuccess(Void aVoid) {
                            Toast.makeText(getContext(), "Successfully remove", Toast.LENGTH_SHORT).show();
                        }
                    });
                }
            }

            .....
        });

إياد الفواز · Answer 9 · 2019-08-05T01:45:40.233

-1

sloved :

public void removeDataFromFirebaseDatabae(){
FirebaseDatabase.getInstance().getRefrence().child("what you will remove").addChildEventListener(new onChildListener(){
@override
public void onChildAdded(DataSnapshot dp,String str){
for(DataSnapshot dx : dp.getChildren()){
dx.getRef().removeValue().addOnSuccessListener(new onSuccessListener<Void>(){
@override
public void onSuccess(Void pvoid){
Toast.makeText(this,"remove success",5000).show();
}});
}}});
}

edited Aug 05 '19 at 01:45

answered Jul 18 '19 at 14:39

إياد الفواز

29
4

1

Please format your code and create a minimal example with enough relevant context added so a normal programmer could understand what you did and how it solved the problem – Tarick Welling Jul 18 '19 at 14:41
حكيني عربي طارق مافهمت قصدك،هادا كود كامل – إياد الفواز Aug 16 '20 at 16:51

How to remove all data from a Firebase database?

9 Answers9

Why missing Firebase remove button ?

Remove all data from Firebase from command line

Linked