SQL EDITOR - Private Queries Delete

[yeshwanthraotharkeswar-gif]

Trying to clean up Private Queries list inside the Supabase SQL Editor dashboard. I have around 449 queries and clear all these queries in one go. Is there any SQL query or delete option? My account is FREE

[garczx]

Hey! There is no SQL command for this because Private Queries are stored as SQL Editor metadata, not as rows in your project database.

The SQL Editor does support deleting multiple selected private queries at once:

1. Open SQL Editor
2. Go to Private queries
3. Select the queries you want to remove
4. Use the delete action and confirm

The confirmation dialog should show the number of selected queries, so you should not need to delete all 449 one by one.

If the current dashboard view does not expose multi-select clearly, try refreshing or switching to the latest SQL Editor interface. This is handled through the Dashboard UI, not through SQL or the CLI.

[yeshwanthraotharkeswar-gif]

Thanks @garczx, I will try and keep you updated.

[yeshwanthraotharkeswar-gif]

To select multiple queries

1. SQL Editor
2. Go to Private queries
3. Select 1st query
4. Scroll to last row or wherever you want
5. Hold the key CTRL+Shift and Click - Rows selected
6. Right click and select 'Delete selected'
7. The confirm dialogue shows the number of deleted rows

Once again thanks @garczx

[garczx]

Glad it worked! Thanks for confirming the exact steps.

[harrysun2006]

There's no SQL for this, because saved SQL Editor snippets don't live in your Postgres database — they're stored in the Supabase platform (per user), so there's no table you can DELETE from. The dashboard only lets you remove them one at a time.

If you want to bulk-delete them, script it against the platform content API. The dashboard itself issues a request like DELETE https://api.supabase.com/.../projects/{ref}/content?id=<snippetId> — open your browser devtools → Network tab while you delete a single snippet, copy that request, and loop it over the IDs with a personal access token.

A proper bulk-delete option would be a good Feature Request.

[yeshwanthraotharkeswar-gif]

Thanks @harrysun2006, Did the multiple private queries deletion? Please refer the steps in my previous reply to @garczx.

[yakubka]

There is no bulk-delete button in the SQL editor UI for private queries on the free plan, but you can remove them through the Supabase Management API.

First, get your project ref and a personal access token from app.supabase.com/account/tokens.

Then list your snippets:

curl -s https://api.supabase.com/v1/projects/{project-ref}/snippets
-H "Authorization: Bearer YOUR_TOKEN" | jq '.[].id'

Delete each snippet by id:

curl -X DELETE https://api.supabase.com/v1/projects/{project-ref}/snippets/{snippet-id}
-H "Authorization: Bearer YOUR_TOKEN"

To delete all of them in one go with bash:

IDS=$(curl -s https://api.supabase.com/v1/projects/{project-ref}/snippets
-H "Authorization: Bearer YOUR_TOKEN" | jq -r '.[].id')
for id in $IDS; do
curl -X DELETE https://api.supabase.com/v1/projects/{project-ref}/snippets/$id
-H "Authorization: Bearer YOUR_TOKEN"
done

Replace {project-ref} with your project reference (found in project settings). 449 queries will take about a minute to delete this way.

[yeshwanthraotharkeswar-gif]

Thanks @yakubka, Did the multiple private queries deletion? Please refer the steps in my previous reply to @garczx.