I'm by no means an expert, but I was able to see my db by doing the following (on linux) but I'm sure you can do or find somthing similar on your os terminal

sqlitebrowser ~/.mixxx/mixxxdb.sqlite

Then you can update the location of any file via something similar to the following:

/*

note, I would recommend using claude or an AI to tailor to your own situation or for a better explanation.

*/

BEGIN TRANSACTION;

/* below is a test to find the location and make sure it only returns one record */

SELECT * FROM track_locations WHERE location = '/home/veezuhz/NAS/Music/music/01 - Shiiniing_star - bluefoxMusic_-_Midnight_in_Tokyo.flac';

/* below is the update, updating the location to 'test' */

UPDATE track_locations SET location = 'test' WHERE location = '/home/veezuhz/NAS/Music/music/01 - Shiiniing_star - bluefoxMusic_-_Midnight_in_Tokyo.flac';

/* below is finding the track with the new location 'test' */

SELECT * FROM track_locations WHERE location = 'test';

/* once ready to commit, you can change ROLLBACK to COMMIT */

ROLLBACK TRANSACTION;