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?

Answer 1

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

Answer 2

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 /

Answer 3

I think there missing some hint - why missing delete button on root level or how can we do it and quickly anyway.

Alvin at Firebase Support was very helpful:

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.

Solution is very simply, just use REST. By their documentation Removing Data but they don't show how can I remove all.

For remove all data you can use by Alvin this:

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

and it means you can do this with every generated URL node in console only by adding JSON extension:

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

I hope this helps someone.

Answer 4

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.

Answer 5

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

Answer 6

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);
}

Answer 7

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 8

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();
}});
}}});
}