Is there official documentation for the Lightroom catalog database schema?

There does not appear to be official Adobe documentation for Lightroom’s internal catalog schema. Community answers indicate Adobe doesn’t encourage direct catalog hacking, so most available information is unofficial.

Useful sources mentioned include community blog posts, Adobe forum threads with sample SQL, and unofficial schema references. One especially helpful clue is that AgHarvestedExifMetadata appears to link to the image table through an image field referencing Adobe_images.id_local, rather than directly to AgLibraryFile. A community Python project (openroom) models this as:

• AgHarvestedExifMetadata.id_local = primary key
• AgHarvestedExifMetadata.image → Adobe_images.id_local

So if you’re trying to reach file information, you may need to go through the image table first rather than joining EXIF directly to AgLibraryFile.

In short: no official schema docs are known, but unofficial references, example SQL, and reverse-engineered models are the practical way to understand Lightroom catalogs.