Skip to main content

effect-sql-db

Provides patterns for integrating SQL databases with Effect, enabling typed errors, transactions, retries, and observability.

Install this skill

or
83/100

Security score

The effect-sql-db skill was audited on Feb 9, 2026 and we found 5 security issues across 3 threat categories. Review the findings below before installing.

Categories Tested

Security Issues

medium line 80

Template literal with variable interpolation in command context

SourceSKILL.md
80sql`COALESCE(${v === undefined ? sql`NULL` : v}, ${col})`
medium line 84

Template literal with variable interpolation in command context

SourceSKILL.md
84return sql<string | undefined>`JSON_UNQUOTE(JSON_EXTRACT(${column}, ${`$.${field}`}))`
medium line 105

Template literal with variable interpolation in command context

SourceSKILL.md
105Effect.tap(([d]) => Duration.toMillis(d) > thresholdMs ? Effect.logWarning(`slow query: ${Duration.toMillis(d)}ms`) : Effect.void),
low line 19

Access to .env file

SourceSKILL.md
19url: process.env.DATABASE_URL ?? ""
low line 175

External URL reference

SourceSKILL.md
175- Agent Skills overview: https://www.anthropic.com/news/skills
Scanned on Feb 9, 2026
View Security Dashboard
Installation guide →