ai_ctxe_uniform_resource_summary

CREATE VIEW ai_ctxe_uniform_resource_summary AS
SELECT
  COUNT(*) AS total_files_seen, -- Total files seen
  COUNT(*) FILTER (WHERE content IS NOT NULL AND LENGTH(TRIM(content)) > 0) AS files_with_content, -- Files with content
  COUNT(*) FILTER (WHERE frontmatter IS NOT NULL AND LENGTH(TRIM(frontmatter)) > 0) AS files_with_frontmatter, -- Files with frontmatter
  MIN(last_modified_at) AS oldest_modified_at, -- Oldest modified date
  MAX(last_modified_at) AS youngest_modified_at -- Youngest modified date
FROM uniform_resource
WHERE uri IS NOT NULL