ai-context-engineering/prompts-anythingllm.sql

              SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
              -- not including breadcrumbs from sqlpage_aide_navigation
              -- not including page title from sqlpage_aide_navigation
              

              
      select
      'breadcrumb' as component;
     
      select
      'Home' as title,
      sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' as link;
     
      select
      'AI Context Engineering Overview' as title,
      sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/ai-context-engineering/index.sql' as link;
     
      select
      'Prompt' as title;
      SELECT 'title'AS component, 
     'Prompt' as contents;

      SELECT 'text' as component,
'This page lists AI context engineering prompts designed for use with AnythingLLM. Each entry includes metadata such as function, audience, and summary to help evaluate its suitability for specific LLM use cases.' as contents;

     
      SELECT
      'table' as component,
      TRUE AS sort,
      TRUE AS search,
      "title" as markdown;
     
      SELECT
      '[' || title || '](' || sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/ai-context-engineering/prompt-detail-anythingllm.sql' || '?uniform_resource_id=' || uniform_resource_id || ')' as "title",
      frontmatter_artifact_nature as "Artifact nature",
      frontmatter_function as "Function",
      frontmatter_audience as "Audience",
      frontmatter_summary as "Summary",
      uri as "URI"
      from ai_ctxe_uniform_resource_frontmatter_view_anythingllm;