ai-context-engineering/prompts.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 provides an overview of AI context engineering prompts, including their purpose, target audience, and validation status. Use the table below to explore and evaluate individual prompts and their associated metadata.' as contents;

   
     
-- Add CSS styling for validation status colors
SELECT 'html' as component,
'<style>
  /* Target the validation status column specifically */
  ._col_validation_status a {
    text-decoration: none;
  }
 
  /* Success styling for validation status column */
  .rowClass-success ._col_validation_status a {
    color: #28a745 !important;
    font-weight: bold;
  }
 
  /* Failure styling for validation status column */
  .rowClass-failure ._col_validation_status a {
    color: #dc3545 !important;
    font-weight: bold;
  }
</style>' as html;
 
SELECT
  'table' as component,
  TRUE AS sort,
  TRUE AS search,
  "title" as markdown,
  "validation status" as markdown;
     
SELECT
  '[' || title || '](' || sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/ai-context-engineering/prompt-detail.sql' || '?uniform_resource_id=' || uniform_resource_id || ')' as "title",
  CASE
    WHEN validation_status = 'success' THEN
      '[success](' || sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/ai-context-engineering/validation-detail.sql' || '?uniform_resource_id=' || uniform_resource_id || ')'
    WHEN validation_status IN ('failure', 'failed') THEN
      '[failure](' || sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/ai-context-engineering/validation-detail.sql' || '?uniform_resource_id=' || uniform_resource_id || ')'
    ELSE
      '[' || validation_status || '](' || sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/ai-context-engineering/validation-detail.sql' || '?uniform_resource_id=' || uniform_resource_id || ')'
  END as "validation status",
 
  frontmatter_artifact_nature as "Artifact nature",
  frontmatter_function as "Function",
  frontmatter_audience as "Audience",
  frontmatter_summary as "Summary",
  uri as "URI",
 
  -- Add CSS class based on validation status
  CASE
    WHEN validation_status = 'success' THEN 'rowClass-success'
    WHEN validation_status IN ('failure', 'failed') THEN 'rowClass-failure'
    ELSE NULL
  END as _sqlpage_css_class
 
FROM ai_ctxe_uniform_resource_frontmatter_view
;