Davinci Resolve DB SQL explorer
This (bash script) commandline tool can be used to directly query (read-only so absolutely safe) any Davinci Resolve PostgreSQL database to extract information about the media assigned to any project.
If a project is used as input a full listing is made of all media and type assigned to this project (audio/video/fusion connect clips) as well as optional check if these media are physically accessible from the workstation that this script is ran from.
The output can be directly to the screen and or send to a .csv file for administrative purposes. If a single media clip name is used as input, the whole database is scanned and reported where (in which projects) this clip is used and its expected file path. (very useful for missing fusion connect clips) Next to these, there are several other option to list all projects in a database, all database on a server etc.
/<path>/resolve_sql_queries.sh [ options ]
–h show help
–menu interactive menu for selecting db/project
–csv output csv compatible
–audio scan project for audio clips only
–video scan project for video clips only
–vfx scan project for fusion connect based vfs clips only
–list list all project in the database
–dblist list all databases on postgresql server
–db=<db> change database from default
–check scan for and show clip access status and for vfx check if render version exists
Free Download HERE (password : DaVinci)