How to delete old builds

[slavus]

Until this feature is implemented, how can we manually delete old builds? Which tables should be deleted?
Does anybody have SQL I could run that would delete all builds and their logs beside last 10 builds

[anbraten]

There is an api endpoint for it AFAIK. Might even be included in the cli already.

[slavus]

There is a cli command to purge log. But only one specific log. My question is abaut maintance and to delete not only logs but also old builds. As far I can see there is no API to delete pipeline or to see which pipelines have deleted logs.

[qwerty287]

There is an API in next: #3506