g14wxz/rag-ingestion-trigger-pipeline
Configures database INSERT triggers that offload document chunking and embedding to Edge Functions.
75
94%
Does it follow best practices?
Run evals on this skill
Adds up to 20 points to the overall score
View guide
High
Do not use without reviewing
Security
1 high severity finding. You should review these findings carefully before considering using this skill.
W007: Insecure credential handling detected in skill instructions.
What this means
The skill handles credentials insecurely by requiring the agent to include secret values verbatim in its generated output. This exposes credentials in the agent’s context and conversation history, creating a risk of data exfiltration.
Why it was flagged
The SQL trigger template includes a placeholder that embeds the service role key directly into the pg_net HTTP headers ("Authorization: Bearer {SERVICE_ROLE_KEY}"), which would require outputting the secret verbatim into SQL/commands (high exfiltration risk), even though the Edge Function itself uses env vars.
Where we found it
[REDACTED]
secret · 1 site
The SQL trigger template embeds a placeholder for the service role key directly into pg_net HTTP headers, which would require outputting the secret verbatim into SQL/commands when an agent substitutes the placeholder.
SKILL.md
37
headers := '{"Authorization": "Bearer [REDACTED]"}'::jsonb
Low
Low-risk findings.
1 low severity finding. Worth noting, but not necessarily harmful.
W012: Unverifiable external dependency detected (runtime URL that controls agent).
What this means
The skill fetches instructions or code from an external URL at runtime, and the fetched content directly controls the agent’s prompts or executes code. This dynamic dependency allows the external source to modify the agent’s behavior without any changes to the skill itself.
Why it was flagged
The Edge Function template imports remote modules that are fetched and executed at runtime (https://deno.land/std@0.168.0/http/server.ts and https://esm.sh/@supabase/supabase-js@2), so these URLs are runtime external dependencies that directly cause execution of remote code.
Where we found it
https://deno.land/std@0.168.0/http/server.ts
dependency · 1 site
The Edge Function template imports a remote Deno standard library module that is fetched and executed at runtime.
SKILL.md
57
import { serve } from 'https://deno.land/std@0.168.0/http/server.ts';
https://esm.sh/@supabase/supabase-js@2
dependency · 1 site
The Edge Function template imports the Supabase JS client from esm.sh, which is fetched and executed at runtime.
SKILL.md
58
import { createClient } from 'https://esm.sh/@supabase/supabase-js@2';
- Audited
- Security analysis