✨ Organize Photos & Videos in seconds

Media Insight lets you filter images and videos using either the visual Query Builder or a manual SQL-like syntax in the search box. You can combine metadata, EXIF fields, GPS data, selections, collections, labels, and text conditions with precise operators such as AND, OR, LIKE, BETWEEN, and REGEXP.

📌 Query Builder

The Query Builder creates structured filters without writing SQL manually. Each block can be combined with AND or OR, and most rows also support NOT.

• Restricted → internal field csam
• Nudity → nudity
• Selected → selected
• Known material → known_material
• Face count → face_count
• Image width → exif_image_width
• Image height → exif_image_height
• Has EXIF data → exif_is_rich
• Has GPS → exif_has_gps
• Camera model → exif_camera_model
• Date range → exif_date_original / exif_date_digitized
• Text search → file_name, path, and exif_full_text
• Collections & Labels → collection:"Name" and label:"Name"

📌 Basic Field Filters

You can type manual filters using these fields:

• face_count > 1
• csam = 0
• nudity > 0
• known_material = 1
• selected = 1
• review_rank >= 2
• md5 = 'abcdef...'
• file_name LIKE '%jpg'
• path LIKE '%DCIM%'
• exif_full_text LIKE '%iPhone%'
• exif_camera_model LIKE '%Canon%'
• exif_has_gps = 1
• exif_is_rich = 1
• exif_image_width >= 1920
• exif_image_height >= 1080

📌 Date & EXIF Filters

EXIF dates can be filtered directly when available. Use them to find media captured or digitized within a specific time range.

• exif_date_original IS NOT NULL
• exif_date_digitized IS NOT NULL
• exif_date_original BETWEEN '2024-01-01' AND '2024-12-31'
• substr(exif_date_original, 1, 10) = '2024-05-20'
• exif_has_gps = 1 AND exif_date_original IS NOT NULL

📌 REGEXP Filters

REGEXP lets you use regular expressions for more powerful text matching than LIKE. This is useful for filenames, camera models, paths, MD5 values, and EXIF text.

• file_name REGEXP '^IMG_[0-9]{4}'
• file_name REGEXP '\.(jpg|jpeg|png)$'
• path REGEXP '(?i)dcim|camera|whatsapp'
• exif_camera_model REGEXP '(?i)iPhone|Pixel|Galaxy'
• exif_full_text REGEXP '(?i)adobe|photoshop|lightroom'
• md5 REGEXP '^[a-f0-9]{32}$'

Use (?i) inside the pattern for case-insensitive matching.

📌 Collections & Labels

Use shortcuts for taxonomy filters:

• collection:"Vacations"
• label:"People"
• collection:"Beach" AND label:"Family"
• NOT (collection:"Archived")
• label:"Portrait" OR label:"Street"

📌 Combining Conditions

You may use AND, OR, NOT, and parentheses to build advanced filters:

• nudity = 0 AND collection:"Travel"
• face_count > 0 AND exif_full_text LIKE '%2024%'
• label:"Portrait" OR label:"Street"
• (exif_has_gps = 1 OR exif_camera_model LIKE '%iPhone%') AND nudity = 0
• selected = 1 AND known_material = 0
• csam = 0 AND nudity = 0 AND face_count >= 1

📌 Supported Operators

You can use common SQL-style operators and helper functions:

• =, <>, >, >=, <, <=
• AND, OR, NOT
• LIKE for wildcard text search, for example file_name LIKE 'IMG_%'
• REGEXP for regular expressions
• BETWEEN ... AND ...
• IN (...)
• IS NULL and IS NOT NULL
• lower(), upper(), length(), substr(), instr()

📌 Free-Text Search

If your input is not recognized as a SQL-like expression, Media Insight performs a semantic and text search across:

• file names
• folder paths
• MD5 hashes
• full EXIF text
• collection names
• label names

Examples: beach sunset, canon lens, family 2023

✔ Practical Examples

• collection:"Holidays" AND nudity = 0
• label:"People" AND face_count > 1
• exif_full_text LIKE '%iPhone%' AND review_rank >= 2
• collection:"Beach" OR collection:"Lake"
• exif_has_gps = 1 AND path LIKE '%DCIM%'
• exif_image_width >= 3000 AND exif_image_height >= 2000
• exif_camera_model REGEXP '(?i)canon|nikon|sony'
• file_name REGEXP '^(IMG|DSC)_[0-9]+'
• lower(exif_full_text) LIKE '%photoshop%'
• exif_date_original BETWEEN '2023-01-01' AND '2023-12-31'

After an analysis is loaded from the database, the FAISS indices are (re)built in the background. From any thumbnail you can launch Show similar images or, if faces are present, Find similar faces. Results open as a paged view ranked by distance.

• Works with both face and global image embeddings.
• Runs only when the app is idle (not analyzing/loading) to keep the UX responsive.

You can bulk‑clean the auto‑created im-video-frames folders across all analyzed directories when you need to reclaim disk space.

You can manually set an item to Pornography, Restricted, or Safe from the menu. This immediately updates both the UI and the database.

When Media Insight is installed on an external USB drive, no data is written to the target device during a search and seizure of electronic devices/data, ensuring a clean and portable workflow for forensic use.

Media Insight checks for a valid license (or remaining trial) when you open a folder. If needed, a login dialog appears to activate access; background refresh keeps the session valid.

Restricted is a generic label meaning “content that may require special review or limited access.” It intentionally avoids naming any specific category so the software remains suitable for general‑purpose workflows.