Title: [Security/Medium]: SQL injection in realtime API via unescaped tags parameter · Issue #3739 · triggerdotdev/trigger.dev · GitHub
Open Graph Title: [Security/Medium]: SQL injection in realtime API via unescaped tags parameter · Issue #3739 · triggerdotdev/trigger.dev
X Title: [Security/Medium]: SQL injection in realtime API via unescaped tags parameter · Issue #3739 · triggerdotdev/trigger.dev
Description: Description The realtime streams API endpoint (realtime.v1.runs) constructs a PostgreSQL WHERE clause by directly interpolating user-provided tags without SQL escaping. This creates a SQL injection vulnerability in the /realtime/v1/runs ...
Open Graph Description: Description The realtime streams API endpoint (realtime.v1.runs) constructs a PostgreSQL WHERE clause by directly interpolating user-provided tags without SQL escaping. This creates a SQL injection...
X Description: Description The realtime streams API endpoint (realtime.v1.runs) constructs a PostgreSQL WHERE clause by directly interpolating user-provided tags without SQL escaping. This creates a SQL injection...
Opengraph URL: https://github.com/triggerdotdev/trigger.dev/issues/3739
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"[Security/Medium]: SQL injection in realtime API via unescaped tags parameter","articleBody":"## Description\n\nThe realtime streams API endpoint (realtime.v1.runs) constructs a PostgreSQL WHERE clause by directly interpolating user-provided tags without SQL escaping. This creates a SQL injection vulnerability in the `/realtime/v1/runs` endpoint.\n\n## Vulnerability Details\n\n**File**: `apps/webapp/app/services/realtimeClient.server.ts`\n\n**Function**: `streamRuns()`\n\n**Vulnerable code (line 171)**:\n```typescript\nif (params.tags) {\n whereClauses.push(`\"runTags\" @> ARRAY[${params.tags.map((t) => `'${t}'`).join(\",\")}]`);\n}\n```\n\nThe tags array from user-provided search parameters is mapped to wrapped strings without escaping, allowing injection of SQL characters.\n\n## Steps to Reproduce\n\n1. Trigger a request to `/realtime/v1/runs?tags=\u003cpayload>` with valid authentication\n2. Observe that the tags parameter is used to construct a SQL WHERE clause\n3. The unescaped tags are then sent to Electric (PostgreSQL) in the query parameter `where`\n\nExample malicious payload (demonstrates syntax injection):\n```\n?tags=test' OR '1'='1\n```\n\nThis would construct:\n```sql\n\"runTags\" @> ARRAY['test' OR '1'='1']\n```\n\n## Impact\n\n- **SQL injection** in realtime streams API\n- Potential to manipulate query logic beyond intended tag filtering\n- Could lead to information disclosure or denial of service\n- Affects authenticated users with `read:tags` or `read:runs` permissions\n\n**Mitigating factors**:\n- Requires valid JWT authentication with appropriate permissions\n- The WHERE clause is within an ARRAY literal context and uses the `@>` (array contains) operator, which limits but does not prevent injection\n- Tags parameter is validated through Zod schema as `string().optional()` before use\n\n## Suggested Fix\n\nUse parameterized queries or proper SQL escaping. Two approaches:\n\n**Option 1: Escape tags using a proper SQL escape function**\n```typescript\nif (params.tags) {\n const escapedTags = params.tags.map((t) => `'${t.replace(/'/g, \"''\")}'`).join(\",\");\n whereClauses.push(`\"runTags\" @> ARRAY[${escapedTags}]`);\n}\n```\n\n**Option 2: Use parameterized queries (if Electric supports them)**\n```typescript\n// Electric/Sync implementation would need to support parameterized WHERE clauses\n// This is the preferred approach but may require backend changes\n```\n\n**Option 3: Validate and sanitize tags**\n```typescript\nif (params.tags) {\n // Ensure tags only contain safe characters\n const sanitizedTags = params.tags.filter(t => /^[a-zA-Z0-9_-]+$/.test(t));\n whereClauses.push(`\"runTags\" @> ARRAY[${sanitizedTags.map((t) => `'${t}'`).join(\",\")}]`);\n}\n```\n\nRecommend implementing Option 1 as an immediate fix and Option 2 for long-term security.\n\n## Environment\n- Version: 3.0.0 (commit 596a9bb90ce9723eec60308c238c1021051cc9f1)\n- OS: macOS (review environment)\n- Node.js: v25.9.0\n\n## Additional Notes\n\nSimilar patterns may exist in other realtime endpoints (`realtime.v1.runs.$runId`, `realtime.v1.batches.$batchId`). A code-wide audit of whereClause construction is recommended.","author":{"url":"https://github.com/sulthonzh","@type":"Person","name":"sulthonzh"},"datePublished":"2026-05-24T15:56:09Z","url":"https://github.com/triggerdotdev/trigger.dev/issues/3739"}
| react-profiling | 0 |
| react-import-map | react,react-dom,react-dom/client,react-dom/profiling,react-is,react-reconciler,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@d5750093facf |
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:619acb2a-844b-6aa4-0535-a75e616cd3ae |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | BABE:3FB6A5:4AA6E78:65F54F4:6AFB083B |
| html-safe-nonce | b91d1ca2f1d7c45ab2909420097e3bc1ada8dd8e97f5c11a02ee0abb7d13fa76 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCQUJFOjNGQjZBNTo0QUE2RTc4OjY1RjU0RjQ6NkFGQjA4M0IiLCJ2aXNpdG9yX2lkIjoiNDA5ODU3ODkwODg2NzkyMTk3OSIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9 |
| visitor-hmac | 357c071ab0442ed34c19f9c7bbd5d48bad4aa8251c36c07344a2ca14c0d2b9f3 |
| hovercard-subject-tag | issue:4512140003 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/triggerdotdev/trigger.dev/3739/issue_layout |
| twitter:image | https://opengraph.githubassets.com/235f1bd2ee44f0b9e15a0b18c80a844c76d05ef16af4324417c8554295b755f7/triggerdotdev/trigger.dev/issues/3739 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/235f1bd2ee44f0b9e15a0b18c80a844c76d05ef16af4324417c8554295b755f7/triggerdotdev/trigger.dev/issues/3739 |
| og:image:alt | Description The realtime streams API endpoint (realtime.v1.runs) constructs a PostgreSQL WHERE clause by directly interpolating user-provided tags without SQL escaping. This creates a SQL injection... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | sulthonzh |
| hostname | github.com |
| expected-hostname | github.com |
| None | 76fb13cb43f1834708971f45a9cfcab5df3177a7582086613d7cdc6e98c4bfde |
| turbo-cache-control | no-preview |
| go-import | github.com/triggerdotdev/trigger.dev git https://github.com/triggerdotdev/trigger.dev.git |
| octolytics-dimension-user_id | 95297378 |
| octolytics-dimension-user_login | triggerdotdev |
| octolytics-dimension-repository_id | 572570113 |
| octolytics-dimension-repository_nwo | triggerdotdev/trigger.dev |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 572570113 |
| octolytics-dimension-repository_network_root_nwo | triggerdotdev/trigger.dev |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | afc998826cdd963c8f91a96ae5372809ab5e296b |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | issues |
Links:
Viewport: width=device-width