aiskillstore/marketplace / skills/2025emma/timescaledb
timescaledb
FlaggedTimescaleDB - PostgreSQL extension for high-performance time-series and event data analytics, hypertables, continuous aggregates, compression, and real-time analytics
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 2.9 KB |
| references/api.md | markdown | 65.3 KB |
| references/compression.md | markdown | 163.6 KB |
| references/continuous_aggregates.md | markdown | 88.8 KB |
| references/getting_started.md | markdown | 94.2 KB |
| references/hyperfunctions.md | markdown | 79.3 KB |
| references/hypertables.md | markdown | 338.9 KB |
| references/index.md | markdown | 694 B |
| references/installation.md | markdown | 148.6 KB |
| references/llms-full.md | markdown | 3.3 MB |
| references/llms.md | markdown | 31.1 KB |
| references/other.md | markdown | 1.5 MB |
| references/performance.md | markdown | 7.2 KB |
| references/time_buckets.md | markdown | 53.0 KB |
| references/tutorials.md | markdown | 50.2 KB |
| skill-report.json | config | 190.6 KB |
skill-report.json
View on GitHub{
"schema_version": "2.0",
"meta": {
"generated_at": "2026-07-04T16:18:11.855Z",
"slug": "2025emma-timescaledb",
"source_url": "https://github.com/2025Emma/vibe-coding-cn/tree/main/i18n/zh/skills/timescaledb",
"source_ref": "main",
"model": "codex",
"analysis_version": "3.0.0",
"source_type": "community",
"content_hash": "99c2a0a6e7c26d23011b94c2f7c985f91ae8d2c3b6c8f84283a5f225d90e9eb7",
"tree_hash": "d50aa4dac553d3c01da5d803cac50dc987e6a2de40d044eae76a086802ca56b1",
"provenance": {
"model_effective": "codex",
"fallback_chain": [
{
"agent": "codex",
"outcome": "success"
}
],
"analysis_version": "3.0.0"
}
},
"skill": {
"name": "timescaledb",
"description": "TimescaleDB guidance for PostgreSQL time-series development, including hypertables, continuous aggregates, compression, time buckets, and installation references.",
"summary": "Build and tune TimescaleDB time-series applications with bundled PostgreSQL reference material.",
"icon": "📦",
"version": "1.0.1",
"author": "2025Emma",
"license": "MIT",
"tags": [
"timescaledb",
"postgresql",
"time-series",
"hypertables",
"continuous-aggregates"
],
"supported_tools": [
"claude",
"codex",
"claude-code"
],
"risk_factors": [
"external_commands",
"network",
"env_access",
"scripts"
],
"category": "data"
},
"security_audit": {
"risk_level": "high",
"is_blocked": false,
"safe_to_publish": false,
"analysis_status": "ok",
"summary": "Most static findings are false positives caused by generated Markdown, SQL examples, and TimescaleDB documentation text. I confirmed user-visible privileged installation patterns, a curl-to-bash installer, and two oversized reference files that were not statically scanned. I also found a destructive DROP EXTENSION quick-reference example; no prompt injection evidence was found.",
"remediation": [
{
"issue": "Privileged installation commands appear in reference content.",
"suggestion": "Add clear warnings and require explicit user confirmation before suggesting sudo, dnf, apt, systemctl, or package source commands.",
"severity": "high"
},
{
"issue": "A curl-to-bash installer command is included.",
"suggestion": "Prefer package-manager instructions with source verification, checksums, or signed release guidance instead of direct remote script execution.",
"severity": "high"
},
{
"issue": "SKILL.md includes a destructive DROP EXTENSION example without warning.",
"suggestion": "Remove it from the quick reference or label it as a destructive recovery operation with backup and rollback prerequisites.",
"severity": "high"
},
{
"issue": "Two reference files were too large for static scanning.",
"suggestion": "Split oversized reference files into smaller topical files so automated and manual review can cover all content reliably.",
"severity": "low"
}
],
"risk_factor_evidence": [
{
"factor": "external_commands",
"evidence": [
{
"file": "references/api.md",
"line_start": 531,
"line_end": 531
},
{
"file": "references/compression.md",
"line_start": 2651,
"line_end": 2652
},
{
"file": "references/continuous_aggregates.md",
"line_start": 118,
"line_end": 119
},
{
"file": "references/continuous_aggregates.md",
"line_start": 123,
"line_end": 128
},
{
"file": "references/continuous_aggregates.md",
"line_start": 128,
"line_end": 129
},
{
"file": "references/continuous_aggregates.md",
"line_start": 129,
"line_end": 138
},
{
"file": "references/continuous_aggregates.md",
"line_start": 138,
"line_end": 139
},
{
"file": "references/continuous_aggregates.md",
"line_start": 139,
"line_end": 147
},
{
"file": "references/getting_started.md",
"line_start": 742,
"line_end": 742
},
{
"file": "references/hypertables.md",
"line_start": 4508,
"line_end": 4509
},
{
"file": "references/hypertables.md",
"line_start": 7024,
"line_end": 7026
},
{
"file": "references/hypertables.md",
"line_start": 7026,
"line_end": 7030
},
{
"file": "references/hypertables.md",
"line_start": 7034,
"line_end": 7036
},
{
"file": "references/hypertables.md",
"line_start": 7471,
"line_end": 7472
},
{
"file": "references/installation.md",
"line_start": 1795,
"line_end": 1795
},
{
"file": "references/installation.md",
"line_start": 1201,
"line_end": 1201
},
{
"file": "references/installation.md",
"line_start": 3767,
"line_end": 3767
},
{
"file": "references/installation.md",
"line_start": 1201,
"line_end": 1201
},
{
"file": "references/installation.md",
"line_start": 2049,
"line_end": 2049
},
{
"file": "references/installation.md",
"line_start": 564,
"line_end": 564
},
{
"file": "references/installation.md",
"line_start": 2716,
"line_end": 2716
},
{
"file": "references/installation.md",
"line_start": 2721,
"line_end": 2721
},
{
"file": "references/installation.md",
"line_start": 3359,
"line_end": 3359
},
{
"file": "references/installation.md",
"line_start": 3390,
"line_end": 3390
},
{
"file": "references/installation.md",
"line_start": 3532,
"line_end": 3532
},
{
"file": "references/installation.md",
"line_start": 3538,
"line_end": 3538
},
{
"file": "references/installation.md",
"line_start": 3558,
"line_end": 3558
},
{
"file": "references/installation.md",
"line_start": 3566,
"line_end": 3566
},
{
"file": "references/installation.md",
"line_start": 3572,
"line_end": 3572
},
{
"file": "references/installation.md",
"line_start": 3600,
"line_end": 3600
},
{
"file": "references/installation.md",
"line_start": 3637,
"line_end": 3637
},
{
"file": "references/installation.md",
"line_start": 3757,
"line_end": 3757
},
{
"file": "references/installation.md",
"line_start": 3762,
"line_end": 3762
},
{
"file": "references/installation.md",
"line_start": 3767,
"line_end": 3767
},
{
"file": "references/installation.md",
"line_start": 3772,
"line_end": 3772
},
{
"file": "SKILL.md",
"line_start": 28,
"line_end": 31
},
{
"file": "SKILL.md",
"line_start": 31,
"line_end": 34
},
{
"file": "SKILL.md",
"line_start": 34,
"line_end": 36
},
{
"file": "SKILL.md",
"line_start": 36,
"line_end": 39
},
{
"file": "SKILL.md",
"line_start": 39,
"line_end": 41
},
{
"file": "SKILL.md",
"line_start": 41,
"line_end": 44
},
{
"file": "SKILL.md",
"line_start": 44,
"line_end": 46
},
{
"file": "SKILL.md",
"line_start": 46,
"line_end": 49
},
{
"file": "SKILL.md",
"line_start": 49,
"line_end": 51
},
{
"file": "SKILL.md",
"line_start": 51,
"line_end": 55
},
{
"file": "SKILL.md",
"line_start": 55,
"line_end": 69
}
]
},
{
"factor": "network",
"evidence": [
{
"file": "references/api.md",
"line_start": 530,
"line_end": 530
},
{
"file": "references/api.md",
"line_start": 2123,
"line_end": 2123
},
{
"file": "references/compression.md",
"line_start": 1705,
"line_end": 1705
},
{
"file": "references/getting_started.md",
"line_start": 2088,
"line_end": 2088
},
{
"file": "references/installation.md",
"line_start": 1201,
"line_end": 1201
},
{
"file": "references/installation.md",
"line_start": 1376,
"line_end": 1376
},
{
"file": "references/installation.md",
"line_start": 3767,
"line_end": 3767
},
{
"file": "references/installation.md",
"line_start": 3772,
"line_end": 3772
},
{
"file": "references/installation.md",
"line_start": 3861,
"line_end": 3861
},
{
"file": "references/llms.md",
"line_start": 381,
"line_end": 381
},
{
"file": "references/time_buckets.md",
"line_start": 929,
"line_end": 929
}
]
},
{
"factor": "env_access",
"evidence": [
{
"file": "references/api.md",
"line_start": 525,
"line_end": 525
},
{
"file": "references/api.md",
"line_start": 531,
"line_end": 531
},
{
"file": "references/getting_started.md",
"line_start": 60,
"line_end": 60
},
{
"file": "references/getting_started.md",
"line_start": 62,
"line_end": 62
},
{
"file": "references/getting_started.md",
"line_start": 2089,
"line_end": 2089
}
]
},
{
"factor": "scripts",
"evidence": [
{
"file": "references/compression.md",
"line_start": 2086,
"line_end": 2086
}
]
}
],
"static_findings": [
{
"id": "external_commands:references/api.md:531:shell-command-substitution",
"category": "external_commands",
"severity": "medium",
"pattern": "Shell command substitution",
"file": "references/api.md",
"line_start": 531,
"line_end": 531,
"snippet": "-H \"Authorization: Basic $(echo -n 'your_access_key:your_secret_key' | base64)\""
},
{
"id": "network:references/api.md:530:hardcoded-url",
"category": "network",
"severity": "low",
"pattern": "Hardcoded URL",
"file": "references/api.md",
"line_start": 530,
"line_end": 530,
"snippet": "curl -X GET \"https://console.cloud.timescale.com/public/api/v1/projects/{project_id}/services\" \\"
},
{
"id": "network:references/api.md:2123:hardcoded-url",
"category": "network",
"severity": "low",
"pattern": "Hardcoded URL",
"file": "references/api.md",
"line_start": 2123,
"line_end": 2123,
"snippet": "curl -s -H \"Authorization: aivenv1 $MST_API_TOKEN\" https://api.aiven.io/v1/me|json_pp"
},
{
"id": "env_access:references/api.md:525:generic-api-secret-keys",
"category": "env_access",
"severity": "high",
"pattern": "Generic API/secret keys",
"file": "references/api.md",
"line_start": 525,
"line_end": 525,
"snippet": "Authorization: Basic <base64(access_key:secret_key)>"
},
{
"id": "env_access:references/api.md:531:generic-api-secret-keys",
"category": "env_access",
"severity": "high",
"pattern": "Generic API/secret keys",
"file": "references/api.md",
"line_start": 531,
"line_end": 531,
"snippet": "-H \"Authorization: Basic $(echo -n 'your_access_key:your_secret_key' | base64)\""
},
{
"id": "blocker:references/api.md:26:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/api.md",
"line_start": 26,
"line_end": 26,
"snippet": "- **Easy keyset pagination**: `WHERE id > :cursor` and natural sharding."
},
{
"id": "blocker:references/api.md:80:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/api.md",
"line_start": 80,
"line_end": 80,
"snippet": "WHERE e.event_id >= to_uuidv7_boundary(ref.t0 - INTERVAL '2 days')"
},
{
"id": "blocker:references/api.md:85:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/api.md",
"line_start": 85,
"line_end": 85,
"snippet": "SELECT count(*) FROM logs WHERE id >= to_uuidv7_boundary(now() - interval '1 hour');"
},
{
"id": "blocker:references/api.md:90:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/api.md",
"line_start": 90,
"line_end": 90,
"snippet": "SELECT * FROM logs WHERE id > to_uuidv7($last_seen'::timestamptz, true) ORDER BY id LIMIT 1000;"
},
{
"id": "blocker:references/api.md:510:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/api.md",
"line_start": 510,
"line_end": 510,
"snippet": "- `400 Bad Request`: Invalid request parameters or malformed JSON"
},
{
"id": "blocker:references/api.md:511:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/api.md",
"line_start": 511,
"line_end": 511,
"snippet": "- `401 Unauthorized`: Missing or invalid authentication credentials"
},
{
"id": "blocker:references/api.md:823:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/api.md",
"line_start": 823,
"line_end": 823,
"snippet": "CREATE FUNCTION <function_name> (job_id INT DEFAULT NULL, config JSONB DEFAULT NULL)"
},
{
"id": "blocker:references/api.md:835:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/api.md",
"line_start": 835,
"line_end": 835,
"snippet": "CREATE FUNCTION reindex_mytable(job_id INT DEFAULT NULL, config JSONB DEFAULT NULL)"
},
{
"id": "blocker:references/api.md:1555:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/api.md",
"line_start": 1555,
"line_end": 1555,
"snippet": "mutators, they can make the syntax clearer by getting rid of nested functions."
},
{
"id": "blocker:references/api.md:1645:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/api.md",
"line_start": 1645,
"line_end": 1645,
"snippet": "`format_string`. The format string can use any valid Tera template"
},
{
"id": "blocker:references/api.md:1769:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/api.md",
"line_start": 1769,
"line_end": 1769,
"snippet": "* When did the highest price occur for this stock?"
},
{
"id": "scripts:references/compression.md:2086:dynamic-import-expression",
"category": "scripts",
"severity": "medium",
"pattern": "Dynamic import() expression",
"file": "references/compression.md",
"line_start": 2086,
"line_end": 2086,
"snippet": "The enhanced Postgres import instructions now offer several options: single table import, schema-onl"
},
{
"id": "external_commands:references/compression.md:2651:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "references/compression.md",
"line_start": 2651,
"line_end": 2652,
"snippet": "segmented using the `device_id` for greater performance."
},
{
"id": "network:references/compression.md:1705:python-http-libraries",
"category": "network",
"severity": "low",
"pattern": "Python HTTP libraries",
"file": "references/compression.md",
"line_start": 1705,
"line_end": 1705,
"snippet": "* Hypertables support triggers for transition tables, which is one of the most upvoted community fea"
},
{
"id": "sensitive:references/compression.md:1276:terraform-state-may-contain-secrets",
"category": "sensitive",
"severity": "high",
"pattern": "Terraform state (may contain secrets)",
"file": "references/compression.md",
"line_start": 1276,
"line_end": 1276,
"snippet": "Check the [Timescale Terraform provider documentation](https://registry.terraform.io/providers/times"
},
{
"id": "blocker:references/compression.md:18:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/compression.md",
"line_start": 18,
"line_end": 18,
"snippet": "To avoid large scale conversion, filter on the columns you use to `segementby` and `orderby`. This f"
},
{
"id": "blocker:references/compression.md:95:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/compression.md",
"line_start": 95,
"line_end": 95,
"snippet": "job_id | 1001"
},
{
"id": "blocker:references/compression.md:118:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/compression.md",
"line_start": 118,
"line_end": 118,
"snippet": "job_id | 1002"
},
{
"id": "blocker:references/compression.md:140:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/compression.md",
"line_start": 140,
"line_end": 140,
"snippet": "job_id | 1002"
},
{
"id": "blocker:references/compression.md:162:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/compression.md",
"line_start": 162,
"line_end": 162,
"snippet": "job_id | 1003"
},
{
"id": "blocker:references/compression.md:179:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/compression.md",
"line_start": 179,
"line_end": 179,
"snippet": "job_id | 1004"
},
{
"id": "blocker:references/compression.md:234:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/compression.md",
"line_start": 234,
"line_end": 234,
"snippet": "avoid incurring additional cost."
},
{
"id": "blocker:references/compression.md:280:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/compression.md",
"line_start": 280,
"line_end": 280,
"snippet": "To avoid running the compression step each time you have some data to"
},
{
"id": "blocker:references/compression.md:518:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/compression.md",
"line_start": 518,
"line_end": 518,
"snippet": "WHERE time = '2000-01-01' AND device_id = 1"
},
{
"id": "blocker:references/compression.md:521:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/compression.md",
"line_start": 521,
"line_end": 522,
"snippet": "tableoid"
},
{
"id": "blocker:references/compression.md:1262:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/compression.md",
"line_start": 1262,
"line_end": 1262,
"snippet": "The new service creation flow makes the choice of service type clearer. You can now create distinct "
},
{
"id": "blocker:references/compression.md:1706:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/compression.md",
"line_start": 1706,
"line_end": 1706,
"snippet": "* Updated methods to manage Timescale's hybrid row-columnar store (hypercore). These methods highlig"
},
{
"id": "blocker:references/compression.md:2233:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/compression.md",
"line_start": 2233,
"line_end": 2233,
"snippet": "- Now uses pgcopydb for initial data copy for PG to TSDB migrations also (already did for TS to TS) "
},
{
"id": "blocker:references/compression.md:2499:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/compression.md",
"line_start": 2499,
"line_end": 2499,
"snippet": "to save space and avoid incurring additional cost."
},
{
"id": "blocker:references/compression.md:2576:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/compression.md",
"line_start": 2576,
"line_end": 2576,
"snippet": "SELECT block_id FROM transactions"
},
{
"id": "blocker:references/compression.md:2586:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/compression.md",
"line_start": 2586,
"line_end": 2586,
"snippet": "INNER JOIN recent_blocks b ON b.block_id = t.block_id"
},
{
"id": "blocker:references/compression.md:2954:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/compression.md",
"line_start": 2954,
"line_end": 2954,
"snippet": "avoid incurring additional cost."
},
{
"id": "blocker:references/compression.md:3001:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/compression.md",
"line_start": 3001,
"line_end": 3001,
"snippet": "To avoid running the compression step each time you have some data to"
},
{
"id": "blocker:references/compression.md:3153:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/compression.md",
"line_start": 3153,
"line_end": 3153,
"snippet": "ALTER TABLE conditions ADD COLUMN device_id integer;"
},
{
"id": "blocker:references/compression.md:3164:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/compression.md",
"line_start": 3164,
"line_end": 3164,
"snippet": "ALTER TABLE conditions ADD COLUMN device_id integer"
},
{
"id": "external_commands:references/continuous_aggregates.md:118:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "references/continuous_aggregates.md",
"line_start": 118,
"line_end": 119,
"snippet": "`<select_query>` is of the form:"
},
{
"id": "external_commands:references/continuous_aggregates.md:123:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "references/continuous_aggregates.md",
"line_start": 123,
"line_end": 128,
"snippet": "The continuous aggregate view defaults to `WITH DATA`. This means that when the"
},
{
"id": "external_commands:references/continuous_aggregates.md:128:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "references/continuous_aggregates.md",
"line_start": 128,
"line_end": 129,
"snippet": "`WITH NO DATA` parameter. For more information, see"
},
{
"id": "external_commands:references/continuous_aggregates.md:129:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "references/continuous_aggregates.md",
"line_start": 129,
"line_end": 138,
"snippet": "[`refresh_continuous_aggregate`][refresh-cagg]."
},
{
"id": "external_commands:references/continuous_aggregates.md:138:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "references/continuous_aggregates.md",
"line_start": 138,
"line_end": 139,
"snippet": "Logs (WAL), set the`timescaledb.enable_merge_on_cagg_refresh`"
},
{
"id": "external_commands:references/continuous_aggregates.md:139:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "references/continuous_aggregates.md",
"line_start": 139,
"line_end": 147,
"snippet": "configuration parameter to `TRUE`. This enables continuous aggregate"
},
{
"id": "blocker:references/continuous_aggregates.md:193:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/continuous_aggregates.md",
"line_start": 193,
"line_end": 193,
"snippet": "ERROR: invalid continuous aggregate view"
},
{
"id": "blocker:references/continuous_aggregates.md:200:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/continuous_aggregates.md",
"line_start": 200,
"line_end": 200,
"snippet": "symbol_id uuid NOT NULL,"
},
{
"id": "blocker:references/continuous_aggregates.md:411:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/continuous_aggregates.md",
"line_start": 411,
"line_end": 411,
"snippet": "refresh the compressed regions of a continuous aggregate. To avoid conflicts"
},
{
"id": "blocker:references/continuous_aggregates.md:983:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/continuous_aggregates.md",
"line_start": 983,
"line_end": 983,
"snippet": "ensure valid time-bucketing:"
},
{
"id": "blocker:references/continuous_aggregates.md:1135:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/continuous_aggregates.md",
"line_start": 1135,
"line_end": 1135,
"snippet": "SELECT id FROM _timescaledb_catalog.hypertable"
},
{
"id": "blocker:references/continuous_aggregates.md:1391:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/continuous_aggregates.md",
"line_start": 1391,
"line_end": 1391,
"snippet": "id TEXT PRIMARY KEY,"
},
{
"id": "blocker:references/continuous_aggregates.md:1396:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/continuous_aggregates.md",
"line_start": 1396,
"line_end": 1396,
"snippet": "id SERIAL PRIMARY KEY,"
},
{
"id": "blocker:references/continuous_aggregates.md:1397:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/continuous_aggregates.md",
"line_start": 1397,
"line_end": 1397,
"snippet": "location_id TEXT,"
},
{
"id": "blocker:references/continuous_aggregates.md:1403:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/continuous_aggregates.md",
"line_start": 1403,
"line_end": 1403,
"snippet": "device_id INTEGER,"
},
{
"id": "blocker:references/continuous_aggregates.md:1416:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/continuous_aggregates.md",
"line_start": 1416,
"line_end": 1416,
"snippet": "JOIN devices ON devices.id = conditions.device_id"
},
{
"id": "blocker:references/continuous_aggregates.md:1426:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/continuous_aggregates.md",
"line_start": 1426,
"line_end": 1426,
"snippet": "JOIN devices ON devices.id = conditions.device_id"
},
{
"id": "blocker:references/continuous_aggregates.md:1427:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/continuous_aggregates.md",
"line_start": 1427,
"line_end": 1427,
"snippet": "WHERE devices.location_id = 'location123'"
},
{
"id": "blocker:references/continuous_aggregates.md:1437:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/continuous_aggregates.md",
"line_start": 1437,
"line_end": 1437,
"snippet": "WHERE devices.id = conditions.device_id"
},
{
"id": "blocker:references/continuous_aggregates.md:1842:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/continuous_aggregates.md",
"line_start": 1842,
"line_end": 1842,
"snippet": "Follow the logic used by automated refresh policies and avoid refreshing time buckets that are likel"
},
{
"id": "external_commands:references/getting_started.md:742:sudo-privilege-escalation",
"category": "external_commands",
"severity": "high",
"pattern": "sudo privilege escalation",
"file": "references/getting_started.md",
"line_start": 742,
"line_end": 742,
"snippet": "`sudo dnf -qy module disable postgresql`"
},
{
"id": "network:references/getting_started.md:2088:fetch-api-call",
"category": "network",
"severity": "low",
"pattern": "Fetch API call",
"file": "references/getting_started.md",
"line_start": 2088,
"line_end": 2088,
"snippet": "pool: <%= ENV.fetch(\"RAILS_MAX_THREADS\") { 5 } %>"
},
{
"id": "env_access:references/getting_started.md:60:database-connection-strings",
"category": "env_access",
"severity": "high",
"pattern": "Database connection strings",
"file": "references/getting_started.md",
"line_start": 60,
"line_end": 60,
"snippet": "by adding `url: <%= ENV['DATABASE_URL'] %>` to the default configuration:"
},
{
"id": "env_access:references/getting_started.md:62:database-connection-strings",
"category": "env_access",
"severity": "high",
"pattern": "Database connection strings",
"file": "references/getting_started.md",
"line_start": 62,
"line_end": 62,
"snippet": "1. Set the environment variable for `DATABASE_URL` to the value of `Service URL` from"
},
{
"id": "env_access:references/getting_started.md:2089:database-connection-strings",
"category": "env_access",
"severity": "high",
"pattern": "Database connection strings",
"file": "references/getting_started.md",
"line_start": 2089,
"line_end": 2089,
"snippet": "url: <%= ENV['DATABASE_URL'] %>"
},
{
"id": "blocker:references/getting_started.md:100:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/getting_started.md",
"line_start": 100,
"line_end": 100,
"snippet": "Rails model includes a `PRIMARY KEY` index for id by default: either remove the column or make sure "
},
{
"id": "blocker:references/getting_started.md:321:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/getting_started.md",
"line_start": 321,
"line_end": 321,
"snippet": "To avoid errors, **do not** install TimescaleDB Apache 2 Edition and TimescaleDB Community Edition a"
},
{
"id": "blocker:references/getting_started.md:500:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/getting_started.md",
"line_start": 500,
"line_end": 500,
"snippet": "Avoid using connection strings that route through connection poolers like PgBouncer or similar tools"
},
{
"id": "blocker:references/getting_started.md:715:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/getting_started.md",
"line_start": 715,
"line_end": 715,
"snippet": "disconnection your app from your database you avoid and possible data loss."
},
{
"id": "blocker:references/getting_started.md:734:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/getting_started.md",
"line_start": 734,
"line_end": 734,
"snippet": "To avoid errors, **do not** install TimescaleDB Apache 2 Edition and TimescaleDB Community Edition a"
},
{
"id": "blocker:references/getting_started.md:806:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/getting_started.md",
"line_start": 806,
"line_end": 806,
"snippet": "[Hypercore][hypercore] is the hybrid row-columnar storage engine in TimescaleDB used by hypertables."
},
{
"id": "blocker:references/getting_started.md:973:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/getting_started.md",
"line_start": 973,
"line_end": 973,
"snippet": "details like your password, hostname, and port number."
},
{
"id": "blocker:references/getting_started.md:1102:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/getting_started.md",
"line_start": 1102,
"line_end": 1102,
"snippet": "[Hypercore][hypercore] is the hybrid row-columnar storage engine in TimescaleDB used by hypertables."
},
{
"id": "blocker:references/getting_started.md:1340:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/getting_started.md",
"line_start": 1340,
"line_end": 1340,
"snippet": "| ts | sensor_id | value |"
},
{
"id": "blocker:references/getting_started.md:1346:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/getting_started.md",
"line_start": 1346,
"line_end": 1346,
"snippet": "| sensor_id | sensor_name | units |"
},
{
"id": "blocker:references/getting_started.md:1356:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/getting_started.md",
"line_start": 1356,
"line_end": 1356,
"snippet": "| ts | sensor_id | d | i | b | t | j |"
},
{
"id": "blocker:references/getting_started.md:1665:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/getting_started.md",
"line_start": 1665,
"line_end": 1665,
"snippet": "wrong foreign key. To avoid these issues, best practice is to follow"
},
{
"id": "blocker:references/getting_started.md:2003:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/getting_started.md",
"line_start": 2003,
"line_end": 2003,
"snippet": "[Hypercore][hypercore] is the hybrid row-columnar storage engine in TimescaleDB used by hypertables."
},
{
"id": "blocker:references/hyperfunctions.md:40:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hyperfunctions.md",
"line_start": 40,
"line_end": 40,
"snippet": "|`job_id` | INTEGER | The id of the background job created to implement the policy |"
},
{
"id": "blocker:references/hyperfunctions.md:44:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hyperfunctions.md",
"line_start": 44,
"line_end": 44,
"snippet": "|`job_status`| TEXT | Status of the job. Valid values are 'Running', 'Scheduled' and 'Paused'|"
},
{
"id": "blocker:references/hyperfunctions.md:62:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hyperfunctions.md",
"line_start": 62,
"line_end": 62,
"snippet": "job_id | total_runs | total_failures | total_successes"
},
{
"id": "blocker:references/hyperfunctions.md:252:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hyperfunctions.md",
"line_start": 252,
"line_end": 252,
"snippet": "[Hypercore][hypercore] is the hybrid row-columnar storage engine in TimescaleDB used by hypertables."
},
{
"id": "blocker:references/hyperfunctions.md:494:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hyperfunctions.md",
"line_start": 494,
"line_end": 494,
"snippet": "vendor_id TEXT,"
},
{
"id": "blocker:references/hyperfunctions.md:785:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hyperfunctions.md",
"line_start": 785,
"line_end": 785,
"snippet": "[Hypercore][hypercore] is the hybrid row-columnar storage engine in TimescaleDB used by hypertables."
},
{
"id": "blocker:references/hyperfunctions.md:988:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hyperfunctions.md",
"line_start": 988,
"line_end": 988,
"snippet": "type_id integer not null,"
},
{
"id": "blocker:references/hyperfunctions.md:1008:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hyperfunctions.md",
"line_start": 1008,
"line_end": 1008,
"snippet": "WHERE type_id = 5"
},
{
"id": "blocker:references/hyperfunctions.md:1138:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hyperfunctions.md",
"line_start": 1138,
"line_end": 1138,
"snippet": "with the Postgres ecosystem and enhances it with automatic time-based partitioning, hybrid row-colum"
},
{
"id": "blocker:references/hyperfunctions.md:1191:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hyperfunctions.md",
"line_start": 1191,
"line_end": 1191,
"snippet": "Today's applications demand a database that can handle real-time analytics and transactional queries"
},
{
"id": "blocker:references/hyperfunctions.md:1238:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hyperfunctions.md",
"line_start": 1238,
"line_end": 1238,
"snippet": "TimescaleDB uses columnar collocation and columnar compression within row-based storage to optimize "
},
{
"id": "blocker:references/hyperfunctions.md:1282:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hyperfunctions.md",
"line_start": 1282,
"line_end": 1282,
"snippet": "Hypercore navigates these trade-offs with a hybrid approach that enables immediate updates without m"
},
{
"id": "blocker:references/hyperfunctions.md:1423:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hyperfunctions.md",
"line_start": 1423,
"line_end": 1423,
"snippet": "Continuous aggregates also avoid the time-consuming and error-prone process of maintaining manual ro"
},
{
"id": "blocker:references/hyperfunctions.md:1523:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hyperfunctions.md",
"line_start": 1523,
"line_end": 1523,
"snippet": "Real-time analytics is critical for modern applications, but traditional databases struggle to balan"
},
{
"id": "external_commands:references/hypertables.md:4508:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "references/hypertables.md",
"line_start": 4508,
"line_end": 4509,
"snippet": "Decompress all compressed chunks in a hypertable named `metrics`:"
},
{
"id": "external_commands:references/hypertables.md:7024:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "references/hypertables.md",
"line_start": 7024,
"line_end": 7026,
"snippet": "Note above that when `compress_after` is used then the time data range"
},
{
"id": "external_commands:references/hypertables.md:7026:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "references/hypertables.md",
"line_start": 7026,
"line_end": 7030,
"snippet": "chunks. Whereas, when `compress_created_before` is used then the chunks"
},
{
"id": "external_commands:references/hypertables.md:7034:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "references/hypertables.md",
"line_start": 7034,
"line_end": 7036,
"snippet": "Add a policy to compress chunks of a continuous aggregate called `cpu_weekly`, that are"
},
{
"id": "external_commands:references/hypertables.md:7471:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "references/hypertables.md",
"line_start": 7471,
"line_end": 7472,
"snippet": "- **Remove the columnstore policy from the `cpu_weekly` continuous aggregate**:"
},
{
"id": "blocker:references/hypertables.md:149:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 149,
"line_end": 149,
"snippet": "| `timezone` |TEXT| UTC. However, daylight savings time(DST) changes may shift th"
},
{
"id": "blocker:references/hypertables.md:525:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 525,
"line_end": 525,
"snippet": "|`if_not_exists`|BOOLEAN| Set to `true` to avoid an error if the `reorder_policy` already exists. A "
},
{
"id": "blocker:references/hypertables.md:527:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 527,
"line_end": 527,
"snippet": "|`timezone`|TEXT| A valid time zone. If `initial_start` is also specified, subsequent runs of the re"
},
{
"id": "blocker:references/hypertables.md:641:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 641,
"line_end": 641,
"snippet": "metrics | _timescaledb_internal._hyper_2_3_chunk | metric_id | \"time\""
},
{
"id": "blocker:references/hypertables.md:815:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 815,
"line_end": 815,
"snippet": "[Hypercore][hypercore] is the hybrid row-columnar storage engine in TimescaleDB used by hypertables."
},
{
"id": "blocker:references/hypertables.md:1234:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 1234,
"line_end": 1234,
"snippet": "| `if_exists` | BOOLEAN | Set to true to avoid throwing an error if the policy does not exist. Defa"
},
{
"id": "blocker:references/hypertables.md:1462:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 1462,
"line_end": 1462,
"snippet": "|`tsdb.sparse_index`| TEXT | TimescaleDB evaluates the columns you already have indexed, checks whic"
},
{
"id": "blocker:references/hypertables.md:1509:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 1509,
"line_end": 1509,
"snippet": "id uuid PRIMARY KEY DEFAULT generate_uuidv7(),"
},
{
"id": "blocker:references/hypertables.md:1618:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 1618,
"line_end": 1618,
"snippet": "ON j.job_id = js.job_id"
},
{
"id": "blocker:references/hypertables.md:1626:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 1626,
"line_end": 1626,
"snippet": "job_id | 1000"
},
{
"id": "blocker:references/hypertables.md:1926:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 1926,
"line_end": 1926,
"snippet": "( SELECT device_uuid, sensor_id FROM public.device_readings"
},
{
"id": "blocker:references/hypertables.md:1928:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 1928,
"line_end": 1928,
"snippet": "GROUP BY device_uuid, sensor_id ) q;"
},
{
"id": "blocker:references/hypertables.md:1934:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 1934,
"line_end": 1935,
"snippet": "Group Key: osm_chunk_1.device_uuid, osm_chunk_1.sensor_id"
},
{
"id": "blocker:references/hypertables.md:2212:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 2212,
"line_end": 2212,
"snippet": "|`timescaledb.sparse_index`| TEXT | TimescaleDB evaluates the columns you already have indexed, c"
},
{
"id": "blocker:references/hypertables.md:2474:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 2474,
"line_end": 2474,
"snippet": "- You can use a column as a filter to narrow down on what data you select. The column `device_type` "
},
{
"id": "blocker:references/hypertables.md:2548:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 2548,
"line_end": 2548,
"snippet": "For example, If you want to access a single device using a specific `device_id` value (either all re"
},
{
"id": "blocker:references/hypertables.md:2555:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 2555,
"line_end": 2555,
"snippet": "WHERE device_id = 5"
},
{
"id": "blocker:references/hypertables.md:2587:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 2587,
"line_end": 2587,
"snippet": "WHERE device_id = 5"
},
{
"id": "blocker:references/hypertables.md:2589:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 2589,
"line_end": 2589,
"snippet": "device_id | avg_cpu | avg_disk_io"
},
{
"id": "blocker:references/hypertables.md:2612:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 2612,
"line_end": 2612,
"snippet": "WHERE device_id = 5"
},
{
"id": "blocker:references/hypertables.md:2614:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 2614,
"line_end": 2614,
"snippet": "device_id | avg_cpu | avg_disk_io"
},
{
"id": "blocker:references/hypertables.md:3136:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 3136,
"line_end": 3136,
"snippet": "|`if_not_exists`|BOOLEAN|Set to true to avoid throwing an error if a dimension for the column alread"
},
{
"id": "blocker:references/hypertables.md:3571:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 3571,
"line_end": 3571,
"snippet": "[integer_now_func][set_integer_now_func] to match your data. If you are seeing `invalid value` issue"
},
{
"id": "blocker:references/hypertables.md:3591:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 3591,
"line_end": 3591,
"snippet": "|`timezone`|TEXT|`NULL`|✖| A valid time zone. If `initial_start` is also specified, subsequent execu"
},
{
"id": "blocker:references/hypertables.md:3592:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 3592,
"line_end": 3592,
"snippet": "|`if_not_exists`|BOOLEAN|`false`|✖| Set to `true` to avoid an error if the `drop_chunks_policy` alre"
},
{
"id": "blocker:references/hypertables.md:3696:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 3696,
"line_end": 3697,
"snippet": "segmentby | metric_id"
},
{
"id": "blocker:references/hypertables.md:4050:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 4050,
"line_end": 4050,
"snippet": "[Hypercore][hypercore] is the hybrid row-columnar storage engine in TimescaleDB used by hypertables."
},
{
"id": "blocker:references/hypertables.md:4183:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 4183,
"line_end": 4183,
"snippet": "type_id integer not null,"
},
{
"id": "blocker:references/hypertables.md:4203:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 4203,
"line_end": 4203,
"snippet": "created | type_id | value"
},
{
"id": "blocker:references/hypertables.md:4757:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 4757,
"line_end": 4757,
"snippet": "user_id BIGINT,"
},
{
"id": "blocker:references/hypertables.md:4758:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 4758,
"line_end": 4758,
"snippet": "device_id BIGINT,"
},
{
"id": "blocker:references/hypertables.md:4784:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 4784,
"line_end": 4784,
"snippet": "user_id BIGINT,"
},
{
"id": "blocker:references/hypertables.md:4785:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 4785,
"line_end": 4785,
"snippet": "device_id BIGINT,"
},
{
"id": "blocker:references/hypertables.md:5004:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 5004,
"line_end": 5004,
"snippet": "device_id integer,"
},
{
"id": "blocker:references/hypertables.md:5065:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 5065,
"line_end": 5066,
"snippet": "segmentby | metric_id"
},
{
"id": "blocker:references/hypertables.md:5274:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 5274,
"line_end": 5274,
"snippet": "You can also use the following query to find all invalid indexes:"
},
{
"id": "blocker:references/hypertables.md:5289:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 5289,
"line_end": 5289,
"snippet": "SELECT * FROM pg_index i WHERE i.indisvalid IS FALSE;"
},
{
"id": "blocker:references/hypertables.md:5479:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 5479,
"line_end": 5479,
"snippet": "device_id int,"
},
{
"id": "blocker:references/hypertables.md:5481:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 5481,
"line_end": 5481,
"snippet": "store_id int,"
},
{
"id": "blocker:references/hypertables.md:5897:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 5897,
"line_end": 5897,
"snippet": "TimescaleDB uses several optimizations to avoid these limitations, and push down"
},
{
"id": "blocker:references/hypertables.md:6197:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 6197,
"line_end": 6197,
"snippet": "Set `timescaledb.compress_orderby = 'time ASC'` to avoid this penalty."
},
{
"id": "blocker:references/hypertables.md:6335:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 6335,
"line_end": 6336,
"snippet": "segmentby | metric_id"
},
{
"id": "blocker:references/hypertables.md:6688:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 6688,
"line_end": 6688,
"snippet": "from entering invalid data into your database. When you create, change, or"
},
{
"id": "blocker:references/hypertables.md:6726:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 6726,
"line_end": 6726,
"snippet": "device_id INTEGER CHECK (device_id > 0),"
},
{
"id": "blocker:references/hypertables.md:6768:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 6768,
"line_end": 6768,
"snippet": "The valid types for the `chunk_time_interval` depend on the type used for the"
},
{
"id": "blocker:references/hypertables.md:7007:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 7007,
"line_end": 7007,
"snippet": "|`timezone`|TEXT|A valid time zone. If `initial_start` is also specified, subsequent executions of t"
},
{
"id": "blocker:references/hypertables.md:7315:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 7315,
"line_end": 7315,
"snippet": "| `if_not_attached` | BOOLEAN |Set to true to avoid throwing an error if the tablespace is already a"
},
{
"id": "blocker:references/hypertables.md:7336:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 7336,
"line_end": 7336,
"snippet": "- Avoid processing a trigger multiple times"
},
{
"id": "blocker:references/hypertables.md:7380:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 7380,
"line_end": 7380,
"snippet": "## Avoid processing a trigger multiple times"
},
{
"id": "blocker:references/hypertables.md:7383:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 7383,
"line_end": 7383,
"snippet": "the trigger fires multiple times. To avoid repetitive firing, you can set the"
},
{
"id": "blocker:references/hypertables.md:7678:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/hypertables.md",
"line_start": 7678,
"line_end": 7678,
"snippet": "| `if_attached` | BOOLEAN | Set to true to avoid throwing an error if the tablespace is not attached"
},
{
"id": "blocker:references/hypertables.md:6133:network-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "Network reconnaissance",
"file": "references/hypertables.md",
"line_start": 6133,
"line_end": 6134,
"snippet": "- Selecting chunks to compress"
},
{
"id": "external_commands:references/installation.md:1795:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "references/installation.md",
"line_start": 1795,
"line_end": 1795,
"snippet": "In the following command, replace `` with the name of the table you just created, and `<COLUMN_NAME>"
},
{
"id": "external_commands:references/installation.md:1201:shell-command-substitution",
"category": "external_commands",
"severity": "medium",
"pattern": "Shell command substitution",
"file": "references/installation.md",
"line_start": 1201,
"line_end": 1201,
"snippet": "/bin/bash -c \"$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)\""
},
{
"id": "external_commands:references/installation.md:3767:shell-command-substitution",
"category": "external_commands",
"severity": "medium",
"pattern": "Shell command substitution",
"file": "references/installation.md",
"line_start": 3767,
"line_end": 3767,
"snippet": "echo \"deb https://packagecloud.io/timescale/timescaledb/debian/ $(lsb_release -c -s) main\" | sudo te"
},
{
"id": "external_commands:references/installation.md:1201:unix-shell-invocation",
"category": "external_commands",
"severity": "medium",
"pattern": "Unix shell invocation",
"file": "references/installation.md",
"line_start": 1201,
"line_end": 1201,
"snippet": "/bin/bash -c \"$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)\""
},
{
"id": "external_commands:references/installation.md:2049:unix-shell-invocation",
"category": "external_commands",
"severity": "medium",
"pattern": "Unix shell invocation",
"file": "references/installation.md",
"line_start": 2049,
"line_end": 2049,
"snippet": "docker exec -i -t timescaledb /bin/bash"
},
{
"id": "external_commands:references/installation.md:564:sudo-privilege-escalation",
"category": "external_commands",
"severity": "high",
"pattern": "sudo privilege escalation",
"file": "references/installation.md",
"line_start": 564,
"line_end": 564,
"snippet": "sudo -u postgres psql"
},
{
"id": "external_commands:references/installation.md:2716:sudo-privilege-escalation",
"category": "external_commands",
"severity": "high",
"pattern": "sudo privilege escalation",
"file": "references/installation.md",
"line_start": 2716,
"line_end": 2716,
"snippet": "sudo apt update"
},
{
"id": "external_commands:references/installation.md:2721:sudo-privilege-escalation",
"category": "external_commands",
"severity": "high",
"pattern": "sudo privilege escalation",
"file": "references/installation.md",
"line_start": 2721,
"line_end": 2721,
"snippet": "sudo apt install timescaledb-toolkit-postgresql-17"
},
{
"id": "external_commands:references/installation.md:3359:sudo-privilege-escalation",
"category": "external_commands",
"severity": "high",
"pattern": "sudo privilege escalation",
"file": "references/installation.md",
"line_start": 3359,
"line_end": 3359,
"snippet": "run `sudo systemctl restart postgresql.service`."
},
{
"id": "external_commands:references/installation.md:3390:sudo-privilege-escalation",
"category": "external_commands",
"severity": "high",
"pattern": "sudo privilege escalation",
"file": "references/installation.md",
"line_start": 3390,
"line_end": 3390,
"snippet": "sudo -u postgres psql"
},
{
"id": "external_commands:references/installation.md:3532:sudo-privilege-escalation",
"category": "external_commands",
"severity": "high",
"pattern": "sudo privilege escalation",
"file": "references/installation.md",
"line_start": 3532,
"line_end": 3532,
"snippet": "`sudo apt-get install timescaledb-2-postgresql-14='2.6.0*' timescaledb-2-loader-postgresql-14='2.6.0"
},
{
"id": "external_commands:references/installation.md:3538:sudo-privilege-escalation",
"category": "external_commands",
"severity": "high",
"pattern": "sudo privilege escalation",
"file": "references/installation.md",
"line_start": 3538,
"line_end": 3538,
"snippet": "By default, this script is included with the `timescaledb-tools` package when you install TimescaleD"
},
{
"id": "external_commands:references/installation.md:3558:sudo-privilege-escalation",
"category": "external_commands",
"severity": "high",
"pattern": "sudo privilege escalation",
"file": "references/installation.md",
"line_start": 3558,
"line_end": 3558,
"snippet": "`wget --quiet -O - https://packagecloud.io/timescale/timescaledb/gpgkey | sudo apt-key add -`"
},
{
"id": "external_commands:references/installation.md:3566:sudo-privilege-escalation",
"category": "external_commands",
"severity": "high",
"pattern": "sudo privilege escalation",
"file": "references/installation.md",
"line_start": 3566,
"line_end": 3566,
"snippet": "`sudo apt-get install timescaledb-2-postgresql-14='2.6.0*' timescaledb-2-loader-postgresql-14='2.6.0"
},
{
"id": "external_commands:references/installation.md:3572:sudo-privilege-escalation",
"category": "external_commands",
"severity": "high",
"pattern": "sudo privilege escalation",
"file": "references/installation.md",
"line_start": 3572,
"line_end": 3572,
"snippet": "By default, this script is included with the `timescaledb-tools` package when you install TimescaleD"
},
{
"id": "external_commands:references/installation.md:3600:sudo-privilege-escalation",
"category": "external_commands",
"severity": "high",
"pattern": "sudo privilege escalation",
"file": "references/installation.md",
"line_start": 3600,
"line_end": 3600,
"snippet": "`sudo dnf -qy module disable postgresql`"
},
{
"id": "external_commands:references/installation.md:3637:sudo-privilege-escalation",
"category": "external_commands",
"severity": "high",
"pattern": "sudo privilege escalation",
"file": "references/installation.md",
"line_start": 3637,
"line_end": 3637,
"snippet": "`sudo dnf -qy module disable postgresql`"
},
{
"id": "external_commands:references/installation.md:3757:sudo-privilege-escalation",
"category": "external_commands",
"severity": "high",
"pattern": "sudo privilege escalation",
"file": "references/installation.md",
"line_start": 3757,
"line_end": 3757,
"snippet": "sudo apt install gnupg postgresql-common apt-transport-https lsb-release wget"
},
{
"id": "external_commands:references/installation.md:3762:sudo-privilege-escalation",
"category": "external_commands",
"severity": "high",
"pattern": "sudo privilege escalation",
"file": "references/installation.md",
"line_start": 3762,
"line_end": 3762,
"snippet": "sudo /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh"
},
{
"id": "external_commands:references/installation.md:3767:sudo-privilege-escalation",
"category": "external_commands",
"severity": "high",
"pattern": "sudo privilege escalation",
"file": "references/installation.md",
"line_start": 3767,
"line_end": 3767,
"snippet": "echo \"deb https://packagecloud.io/timescale/timescaledb/debian/ $(lsb_release -c -s) main\" | sudo te"
},
{
"id": "external_commands:references/installation.md:3772:sudo-privilege-escalation",
"category": "external_commands",
"severity": "high",
"pattern": "sudo privilege escalation",
"file": "references/installation.md",
"line_start": 3772,
"line_end": 3772,
"snippet": "wget --quiet -O - https://packagecloud.io/timescale/timescaledb/gpgkey | sudo gpg --dearmor -o /etc/"
},
{
"id": "network:references/installation.md:1201:hardcoded-url",
"category": "network",
"severity": "low",
"pattern": "Hardcoded URL",
"file": "references/installation.md",
"line_start": 1201,
"line_end": 1201,
"snippet": "/bin/bash -c \"$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)\""
},
{
"id": "network:references/installation.md:1376:hardcoded-url",
"category": "network",
"severity": "low",
"pattern": "Hardcoded URL",
"file": "references/installation.md",
"line_start": 1376,
"line_end": 1376,
"snippet": "git clone https://github.com/timescale/timescaledb"
},
{
"id": "network:references/installation.md:3767:hardcoded-url",
"category": "network",
"severity": "low",
"pattern": "Hardcoded URL",
"file": "references/installation.md",
"line_start": 3767,
"line_end": 3767,
"snippet": "echo \"deb https://packagecloud.io/timescale/timescaledb/debian/ $(lsb_release -c -s) main\" | sudo te"
},
{
"id": "network:references/installation.md:3772:hardcoded-url",
"category": "network",
"severity": "low",
"pattern": "Hardcoded URL",
"file": "references/installation.md",
"line_start": 3772,
"line_end": 3772,
"snippet": "wget --quiet -O - https://packagecloud.io/timescale/timescaledb/gpgkey | sudo gpg --dearmor -o /etc/"
},
{
"id": "network:references/installation.md:3861:hardcoded-ip-address",
"category": "network",
"severity": "medium",
"pattern": "Hardcoded IP address",
"file": "references/installation.md",
"line_start": 3861,
"line_end": 3861,
"snippet": "INSERT INTO example VALUES ('2020-12-14 13:45', 1, '1.2.3.4');"
},
{
"id": "blocker:references/installation.md:371:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/installation.md",
"line_start": 371,
"line_end": 371,
"snippet": "disconnecting your app from your database, you avoid possible data loss."
},
{
"id": "blocker:references/installation.md:871:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/installation.md",
"line_start": 871,
"line_end": 871,
"snippet": "If you want to access the container from the host but avoid exposing it to the"
},
{
"id": "blocker:references/installation.md:919:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/installation.md",
"line_start": 919,
"line_end": 919,
"snippet": "If you want to access the container from the host but avoid exposing it to the"
},
{
"id": "blocker:references/installation.md:1467:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/installation.md",
"line_start": 1467,
"line_end": 1467,
"snippet": "capabilities of multi-node TimescaleDB to avoid having to"
},
{
"id": "blocker:references/installation.md:2181:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/installation.md",
"line_start": 2181,
"line_end": 2181,
"snippet": "target. In the following example, you replace `<exporter-host>` with the hostname or IP address of t"
},
{
"id": "blocker:references/installation.md:2464:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/installation.md",
"line_start": 2464,
"line_end": 2464,
"snippet": "target. In the following example, you replace `<exporter-host>` with the hostname or IP address of t"
},
{
"id": "blocker:references/installation.md:2867:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/installation.md",
"line_start": 2867,
"line_end": 2867,
"snippet": "Postgres user `repuser` with a valid password. `REPLICATION_HOST_IP` can"
},
{
"id": "blocker:references/installation.md:3592:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/installation.md",
"line_start": 3592,
"line_end": 3592,
"snippet": "To avoid errors, **do not** install TimescaleDB Apache 2 Edition and TimescaleDB Community Edition a"
},
{
"id": "blocker:references/installation.md:3629:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/installation.md",
"line_start": 3629,
"line_end": 3629,
"snippet": "To avoid errors, **do not** install TimescaleDB Apache 2 Edition and TimescaleDB Community Edition a"
},
{
"id": "blocker:references/installation.md:3672:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/installation.md",
"line_start": 3672,
"line_end": 3672,
"snippet": "To avoid errors, **do not** install TimescaleDB Apache 2 Edition and TimescaleDB Community Edition a"
},
{
"id": "blocker:references/installation.md:3825:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/installation.md",
"line_start": 3825,
"line_end": 3825,
"snippet": "1. On the access node (AN), run this command and provide the hostname of the"
},
{
"id": "network:references/llms.md:381:python-http-libraries",
"category": "network",
"severity": "low",
"pattern": "Python HTTP libraries",
"file": "references/llms.md",
"line_start": 381,
"line_end": 381,
"snippet": "The documentation is built using Gatsby and automatically generates preview links for pull requests."
},
{
"id": "blocker:references/performance.md:148:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/performance.md",
"line_start": 148,
"line_end": 148,
"snippet": "user_id INT,"
},
{
"id": "blocker:references/performance.md:149:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/performance.md",
"line_start": 149,
"line_end": 149,
"snippet": "device_id INT,"
},
{
"id": "blocker:references/performance.md:161:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/performance.md",
"line_start": 161,
"line_end": 161,
"snippet": "WHERE device_id = 5"
},
{
"id": "blocker:references/performance.md:167:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/performance.md",
"line_start": 167,
"line_end": 167,
"snippet": "device_id | avg_cpu | avg_disk_io"
},
{
"id": "network:references/time_buckets.md:929:python-http-libraries",
"category": "network",
"severity": "low",
"pattern": "Python HTTP libraries",
"file": "references/time_buckets.md",
"line_start": 929,
"line_end": 929,
"snippet": "- Summarize the latest GitHub pull requests."
},
{
"id": "blocker:references/time_buckets.md:325:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/time_buckets.md",
"line_start": 325,
"line_end": 325,
"snippet": "|`timezone`|TEXT|A valid time zone. If you specify `initial_start`, subsequent executions of the ref"
},
{
"id": "blocker:references/time_buckets.md:538:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/time_buckets.md",
"line_start": 538,
"line_end": 539,
"snippet": "a non-month component. For example, `1 month` and `3 months` are both valid"
},
{
"id": "blocker:references/time_buckets.md:927:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/time_buckets.md",
"line_start": 927,
"line_end": 927,
"snippet": "- What did we ship last week?"
},
{
"id": "blocker:references/time_buckets.md:1044:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/time_buckets.md",
"line_start": 1044,
"line_end": 1044,
"snippet": "Follow the same procedure as you did for the ingest Slack app."
},
{
"id": "blocker:references/tutorials.md:303:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/tutorials.md",
"line_start": 303,
"line_end": 303,
"snippet": "vendor_id TEXT,"
},
{
"id": "blocker:references/tutorials.md:769:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/tutorials.md",
"line_start": 769,
"line_end": 769,
"snippet": "paid by each passenger."
},
{
"id": "blocker:references/tutorials.md:775:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/tutorials.md",
"line_start": 775,
"line_end": 775,
"snippet": "week of January 2016, and return the average fare paid on each day:"
},
{
"id": "blocker:references/tutorials.md:1021:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/tutorials.md",
"line_start": 1021,
"line_end": 1021,
"snippet": "vendor_id TEXT,"
},
{
"id": "blocker:references/tutorials.md:1188:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/tutorials.md",
"line_start": 1188,
"line_end": 1188,
"snippet": "id SERIAL PRIMARY KEY,"
},
{
"id": "blocker:references/tutorials.md:1198:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/tutorials.md",
"line_start": 1198,
"line_end": 1198,
"snippet": "sensor_id INTEGER,"
},
{
"id": "external_commands:SKILL.md:28:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "SKILL.md",
"line_start": 28,
"line_end": 31,
"snippet": "```bash"
},
{
"id": "external_commands:SKILL.md:31:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "SKILL.md",
"line_start": 31,
"line_end": 34,
"snippet": "```"
},
{
"id": "external_commands:SKILL.md:34:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "SKILL.md",
"line_start": 34,
"line_end": 36,
"snippet": "```ruby"
},
{
"id": "external_commands:SKILL.md:36:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "SKILL.md",
"line_start": 36,
"line_end": 39,
"snippet": "```"
},
{
"id": "external_commands:SKILL.md:39:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "SKILL.md",
"line_start": 39,
"line_end": 41,
"snippet": "```shell"
},
{
"id": "external_commands:SKILL.md:41:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "SKILL.md",
"line_start": 41,
"line_end": 44,
"snippet": "```"
},
{
"id": "external_commands:SKILL.md:44:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "SKILL.md",
"line_start": 44,
"line_end": 46,
"snippet": "```shell"
},
{
"id": "external_commands:SKILL.md:46:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "SKILL.md",
"line_start": 46,
"line_end": 49,
"snippet": "```"
},
{
"id": "external_commands:SKILL.md:49:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "SKILL.md",
"line_start": 49,
"line_end": 51,
"snippet": "```sql"
},
{
"id": "external_commands:SKILL.md:51:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "SKILL.md",
"line_start": 51,
"line_end": 55,
"snippet": "```"
},
{
"id": "external_commands:SKILL.md:55:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "SKILL.md",
"line_start": 55,
"line_end": 69,
"snippet": "This skill includes comprehensive documentation in `references/`:"
},
{
"id": "metadata:references/llms-full.md:1:unscanned-file-too-large-manual-review-required",
"category": "metadata",
"severity": "low",
"pattern": "Unscanned file (too_large) — manual review required",
"file": "references/llms-full.md",
"line_start": 1,
"line_end": 1,
"snippet": "[unscanned: too_large]"
},
{
"id": "metadata:references/other.md:1:unscanned-file-too-large-manual-review-required",
"category": "metadata",
"severity": "low",
"pattern": "Unscanned file (too_large) — manual review required",
"file": "references/other.md",
"line_start": 1,
"line_end": 1,
"snippet": "[unscanned: too_large]"
},
{
"id": "obfuscation:references/api.md:1:heuristic-multiple-bracket-chains-7-jsfuck-obfus",
"category": "obfuscation",
"severity": "high",
"pattern": "[HEURISTIC] Multiple bracket chains (7) - JSFuck/obfuscation pattern",
"file": "references/api.md",
"line_start": 1,
"line_end": 1,
"snippet": "()][, ()][, ()]["
},
{
"id": "obfuscation:references/installation.md:1:heuristic-multiple-bracket-chains-6-jsfuck-obfus",
"category": "obfuscation",
"severity": "high",
"pattern": "[HEURISTIC] Multiple bracket chains (6) - JSFuck/obfuscation pattern",
"file": "references/installation.md",
"line_start": 1,
"line_end": 1,
"snippet": "}}{{, }}{{, }}{{"
}
],
"finding_verdicts": [
{
"id": "external_commands:references/api.md:531:shell-command-substitution",
"verdict": "false_positive",
"confidence": 0.79,
"reason": "The command substitution is a visible curl example for encoding placeholder credentials. The skill does not execute it or interpolate user-controlled input."
},
{
"id": "network:references/api.md:530:hardcoded-url",
"verdict": "false_positive",
"confidence": 0.88,
"reason": "The URL appears in a visible API documentation example. It does not execute automatically or send hidden data from the user environment."
},
{
"id": "network:references/api.md:2123:hardcoded-url",
"verdict": "false_positive",
"confidence": 0.88,
"reason": "The URL appears in a visible API documentation example. It does not execute automatically or send hidden data from the user environment."
},
{
"id": "env_access:references/api.md:525:generic-api-secret-keys",
"verdict": "false_positive",
"confidence": 0.84,
"reason": "The line shows placeholder API credential syntax in documentation. No real secret is embedded, and the skill does not send credentials anywhere."
},
{
"id": "env_access:references/api.md:531:generic-api-secret-keys",
"verdict": "false_positive",
"confidence": 0.84,
"reason": "The line shows placeholder API credential syntax in documentation. No real secret is embedded, and the skill does not send credentials anywhere."
},
{
"id": "blocker:references/api.md:26:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/api.md:80:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/api.md:85:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/api.md:90:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/api.md:510:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/api.md:511:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/api.md:823:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/api.md:835:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/api.md:1555:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/api.md:1645:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/api.md:1769:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "scripts:references/compression.md:2086:dynamic-import-expression",
"verdict": "false_positive",
"confidence": 0.93,
"reason": "The matched text refers to Postgres import instructions in prose. It is not a JavaScript dynamic import expression or executable loader."
},
{
"id": "external_commands:references/compression.md:2651:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.92,
"reason": "The matched backticks are Markdown formatting around TimescaleDB documentation. They are not shell backtick execution or a process-spawn path."
},
{
"id": "network:references/compression.md:1705:python-http-libraries",
"verdict": "false_positive",
"confidence": 0.91,
"reason": "The matched text is documentation prose or a visible reference link, not executable network code. No hidden outbound request is present."
},
{
"id": "sensitive:references/compression.md:1276:terraform-state-may-contain-secrets",
"verdict": "false_positive",
"confidence": 0.88,
"reason": "The line links to Terraform provider documentation and does not include a Terraform state file. No serialized secret material is present at this location."
},
{
"id": "blocker:references/compression.md:18:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/compression.md:95:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/compression.md:118:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/compression.md:140:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/compression.md:162:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/compression.md:179:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/compression.md:234:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/compression.md:280:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/compression.md:518:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/compression.md:521:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/compression.md:1262:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/compression.md:1706:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/compression.md:2233:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/compression.md:2499:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/compression.md:2576:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/compression.md:2586:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/compression.md:2954:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/compression.md:3001:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/compression.md:3153:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/compression.md:3164:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "external_commands:references/continuous_aggregates.md:118:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.92,
"reason": "The matched backticks are Markdown formatting around TimescaleDB documentation. They are not shell backtick execution or a process-spawn path."
},
{
"id": "external_commands:references/continuous_aggregates.md:123:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.92,
"reason": "The matched backticks are Markdown formatting around TimescaleDB documentation. They are not shell backtick execution or a process-spawn path."
},
{
"id": "external_commands:references/continuous_aggregates.md:128:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.92,
"reason": "The matched backticks are Markdown formatting around TimescaleDB documentation. They are not shell backtick execution or a process-spawn path."
},
{
"id": "external_commands:references/continuous_aggregates.md:129:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.92,
"reason": "The matched backticks are Markdown formatting around TimescaleDB documentation. They are not shell backtick execution or a process-spawn path."
},
{
"id": "external_commands:references/continuous_aggregates.md:138:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.92,
"reason": "The matched backticks are Markdown formatting around TimescaleDB documentation. They are not shell backtick execution or a process-spawn path."
},
{
"id": "external_commands:references/continuous_aggregates.md:139:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.92,
"reason": "The matched backticks are Markdown formatting around TimescaleDB documentation. They are not shell backtick execution or a process-spawn path."
},
{
"id": "blocker:references/continuous_aggregates.md:193:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/continuous_aggregates.md:200:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/continuous_aggregates.md:411:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/continuous_aggregates.md:983:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/continuous_aggregates.md:1135:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/continuous_aggregates.md:1391:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/continuous_aggregates.md:1396:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/continuous_aggregates.md:1397:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/continuous_aggregates.md:1403:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/continuous_aggregates.md:1416:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/continuous_aggregates.md:1426:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/continuous_aggregates.md:1427:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/continuous_aggregates.md:1437:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/continuous_aggregates.md:1842:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "external_commands:references/getting_started.md:742:sudo-privilege-escalation",
"verdict": "confirmed",
"confidence": 0.72,
"reason": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state.",
"severity": "high"
},
{
"id": "network:references/getting_started.md:2088:fetch-api-call",
"verdict": "false_positive",
"confidence": 0.91,
"reason": "The matched text is documentation prose or a visible reference link, not executable network code. No hidden outbound request is present."
},
{
"id": "env_access:references/getting_started.md:60:database-connection-strings",
"verdict": "false_positive",
"confidence": 0.9,
"reason": "The line shows application configuration reading DATABASE_URL from the environment. That is a standard secret-handling pattern and does not expose the value."
},
{
"id": "env_access:references/getting_started.md:62:database-connection-strings",
"verdict": "false_positive",
"confidence": 0.9,
"reason": "The line shows application configuration reading DATABASE_URL from the environment. That is a standard secret-handling pattern and does not expose the value."
},
{
"id": "env_access:references/getting_started.md:2089:database-connection-strings",
"verdict": "false_positive",
"confidence": 0.9,
"reason": "The line shows application configuration reading DATABASE_URL from the environment. That is a standard secret-handling pattern and does not expose the value."
},
{
"id": "blocker:references/getting_started.md:100:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/getting_started.md:321:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/getting_started.md:500:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/getting_started.md:715:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/getting_started.md:734:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/getting_started.md:806:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/getting_started.md:973:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/getting_started.md:1102:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/getting_started.md:1340:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/getting_started.md:1346:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/getting_started.md:1356:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/getting_started.md:1665:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/getting_started.md:2003:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hyperfunctions.md:40:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hyperfunctions.md:44:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hyperfunctions.md:62:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hyperfunctions.md:252:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hyperfunctions.md:494:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hyperfunctions.md:785:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hyperfunctions.md:988:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hyperfunctions.md:1008:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hyperfunctions.md:1138:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hyperfunctions.md:1191:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hyperfunctions.md:1238:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hyperfunctions.md:1282:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hyperfunctions.md:1423:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hyperfunctions.md:1523:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "external_commands:references/hypertables.md:4508:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.92,
"reason": "The matched backticks are Markdown formatting around TimescaleDB documentation. They are not shell backtick execution or a process-spawn path."
},
{
"id": "external_commands:references/hypertables.md:7024:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.92,
"reason": "The matched backticks are Markdown formatting around TimescaleDB documentation. They are not shell backtick execution or a process-spawn path."
},
{
"id": "external_commands:references/hypertables.md:7026:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.92,
"reason": "The matched backticks are Markdown formatting around TimescaleDB documentation. They are not shell backtick execution or a process-spawn path."
},
{
"id": "external_commands:references/hypertables.md:7034:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.92,
"reason": "The matched backticks are Markdown formatting around TimescaleDB documentation. They are not shell backtick execution or a process-spawn path."
},
{
"id": "external_commands:references/hypertables.md:7471:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.92,
"reason": "The matched backticks are Markdown formatting around TimescaleDB documentation. They are not shell backtick execution or a process-spawn path."
},
{
"id": "blocker:references/hypertables.md:149:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:525:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:527:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:641:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:815:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:1234:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:1462:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:1509:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:1618:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:1626:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:1926:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:1928:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:1934:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:2212:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:2474:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:2548:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:2555:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:2587:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:2589:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:2612:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:2614:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:3136:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:3571:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:3591:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:3592:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:3696:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:4050:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:4183:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:4203:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:4757:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:4758:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:4784:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:4785:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:5004:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:5065:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:5274:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:5289:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:5479:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:5481:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:5897:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:6197:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:6335:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:6688:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:6726:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:6768:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:7007:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:7315:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:7336:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:7380:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:7383:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:7678:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/hypertables.md:6133:network-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "external_commands:references/installation.md:1795:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.92,
"reason": "The matched backticks are Markdown formatting around TimescaleDB documentation. They are not shell backtick execution or a process-spawn path."
},
{
"id": "external_commands:references/installation.md:1201:shell-command-substitution",
"verdict": "confirmed",
"confidence": 0.82,
"reason": "The example downloads a remote installer and executes it with bash. It is visible documentation, but copying it blindly can run arbitrary remote code.",
"severity": "high"
},
{
"id": "external_commands:references/installation.md:3767:shell-command-substitution",
"verdict": "confirmed",
"confidence": 0.76,
"reason": "The command writes package repository configuration with elevated privileges. It is user-visible documentation, but it changes system package trust state.",
"severity": "high"
},
{
"id": "external_commands:references/installation.md:1201:unix-shell-invocation",
"verdict": "confirmed",
"confidence": 0.82,
"reason": "The example downloads a remote installer and executes it with bash. It is visible documentation, but copying it blindly can run arbitrary remote code.",
"severity": "high"
},
{
"id": "external_commands:references/installation.md:2049:unix-shell-invocation",
"verdict": "false_positive",
"confidence": 0.82,
"reason": "The command opens an interactive shell inside a named Docker container as part of installation documentation. It is not hidden execution by the skill."
},
{
"id": "external_commands:references/installation.md:564:sudo-privilege-escalation",
"verdict": "confirmed",
"confidence": 0.72,
"reason": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state.",
"severity": "high"
},
{
"id": "external_commands:references/installation.md:2716:sudo-privilege-escalation",
"verdict": "confirmed",
"confidence": 0.72,
"reason": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state.",
"severity": "high"
},
{
"id": "external_commands:references/installation.md:2721:sudo-privilege-escalation",
"verdict": "confirmed",
"confidence": 0.72,
"reason": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state.",
"severity": "high"
},
{
"id": "external_commands:references/installation.md:3359:sudo-privilege-escalation",
"verdict": "confirmed",
"confidence": 0.72,
"reason": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state.",
"severity": "high"
},
{
"id": "external_commands:references/installation.md:3390:sudo-privilege-escalation",
"verdict": "confirmed",
"confidence": 0.72,
"reason": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state.",
"severity": "high"
},
{
"id": "external_commands:references/installation.md:3532:sudo-privilege-escalation",
"verdict": "confirmed",
"confidence": 0.72,
"reason": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state.",
"severity": "high"
},
{
"id": "external_commands:references/installation.md:3538:sudo-privilege-escalation",
"verdict": "confirmed",
"confidence": 0.72,
"reason": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state.",
"severity": "high"
},
{
"id": "external_commands:references/installation.md:3558:sudo-privilege-escalation",
"verdict": "confirmed",
"confidence": 0.72,
"reason": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state.",
"severity": "high"
},
{
"id": "external_commands:references/installation.md:3566:sudo-privilege-escalation",
"verdict": "confirmed",
"confidence": 0.72,
"reason": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state.",
"severity": "high"
},
{
"id": "external_commands:references/installation.md:3572:sudo-privilege-escalation",
"verdict": "confirmed",
"confidence": 0.72,
"reason": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state.",
"severity": "high"
},
{
"id": "external_commands:references/installation.md:3600:sudo-privilege-escalation",
"verdict": "confirmed",
"confidence": 0.72,
"reason": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state.",
"severity": "high"
},
{
"id": "external_commands:references/installation.md:3637:sudo-privilege-escalation",
"verdict": "confirmed",
"confidence": 0.72,
"reason": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state.",
"severity": "high"
},
{
"id": "external_commands:references/installation.md:3757:sudo-privilege-escalation",
"verdict": "confirmed",
"confidence": 0.72,
"reason": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state.",
"severity": "high"
},
{
"id": "external_commands:references/installation.md:3762:sudo-privilege-escalation",
"verdict": "confirmed",
"confidence": 0.72,
"reason": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state.",
"severity": "high"
},
{
"id": "external_commands:references/installation.md:3767:sudo-privilege-escalation",
"verdict": "confirmed",
"confidence": 0.72,
"reason": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state.",
"severity": "high"
},
{
"id": "external_commands:references/installation.md:3772:sudo-privilege-escalation",
"verdict": "confirmed",
"confidence": 0.72,
"reason": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state.",
"severity": "high"
},
{
"id": "network:references/installation.md:1201:hardcoded-url",
"verdict": "confirmed",
"confidence": 0.82,
"reason": "The example downloads a remote installer and executes it with bash. It is visible documentation, but copying it blindly can run arbitrary remote code.",
"severity": "high"
},
{
"id": "network:references/installation.md:1376:hardcoded-url",
"verdict": "false_positive",
"confidence": 0.9,
"reason": "The URL is a documented git clone target for the TimescaleDB source repository. It is not a hidden outbound request or data exfiltration path."
},
{
"id": "network:references/installation.md:3767:hardcoded-url",
"verdict": "confirmed",
"confidence": 0.74,
"reason": "The URL is part of an installation step that modifies trusted package sources or keys. It is legitimate documentation, but users must verify the source before use.",
"severity": "medium"
},
{
"id": "network:references/installation.md:3772:hardcoded-url",
"verdict": "confirmed",
"confidence": 0.74,
"reason": "The URL is part of an installation step that modifies trusted package sources or keys. It is legitimate documentation, but users must verify the source before use.",
"severity": "medium"
},
{
"id": "network:references/installation.md:3861:hardcoded-ip-address",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The IP address is sample data inserted into an example table. It is not a live network target or beacon address."
},
{
"id": "blocker:references/installation.md:371:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/installation.md:871:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/installation.md:919:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/installation.md:1467:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/installation.md:2181:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/installation.md:2464:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/installation.md:2867:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/installation.md:3592:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/installation.md:3629:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/installation.md:3672:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/installation.md:3825:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "network:references/llms.md:381:python-http-libraries",
"verdict": "false_positive",
"confidence": 0.91,
"reason": "The matched text is documentation prose or a visible reference link, not executable network code. No hidden outbound request is present."
},
{
"id": "blocker:references/performance.md:148:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/performance.md:149:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/performance.md:161:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/performance.md:167:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "network:references/time_buckets.md:929:python-http-libraries",
"verdict": "false_positive",
"confidence": 0.91,
"reason": "The matched text is documentation prose or a visible reference link, not executable network code. No hidden outbound request is present."
},
{
"id": "blocker:references/time_buckets.md:325:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/time_buckets.md:538:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/time_buckets.md:927:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/time_buckets.md:1044:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/tutorials.md:303:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/tutorials.md:769:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/tutorials.md:775:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/tutorials.md:1021:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/tutorials.md:1188:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "blocker:references/tutorials.md:1198:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.94,
"reason": "The snippet is TimescaleDB documentation, SQL schema text, query output, or prose. It does not collect host, account, or network reconnaissance data."
},
{
"id": "external_commands:SKILL.md:28:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.92,
"reason": "The match is a Markdown code fence or reference-list text in SKILL.md. It is not Ruby backtick execution and no helper script runs there."
},
{
"id": "external_commands:SKILL.md:31:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.92,
"reason": "The match is a Markdown code fence or reference-list text in SKILL.md. It is not Ruby backtick execution and no helper script runs there."
},
{
"id": "external_commands:SKILL.md:34:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.92,
"reason": "The match is a Markdown code fence or reference-list text in SKILL.md. It is not Ruby backtick execution and no helper script runs there."
},
{
"id": "external_commands:SKILL.md:36:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.92,
"reason": "The match is a Markdown code fence or reference-list text in SKILL.md. It is not Ruby backtick execution and no helper script runs there."
},
{
"id": "external_commands:SKILL.md:39:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.92,
"reason": "The match is a Markdown code fence or reference-list text in SKILL.md. It is not Ruby backtick execution and no helper script runs there."
},
{
"id": "external_commands:SKILL.md:41:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.92,
"reason": "The match is a Markdown code fence or reference-list text in SKILL.md. It is not Ruby backtick execution and no helper script runs there."
},
{
"id": "external_commands:SKILL.md:44:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.92,
"reason": "The match is a Markdown code fence or reference-list text in SKILL.md. It is not Ruby backtick execution and no helper script runs there."
},
{
"id": "external_commands:SKILL.md:46:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.92,
"reason": "The match is a Markdown code fence or reference-list text in SKILL.md. It is not Ruby backtick execution and no helper script runs there."
},
{
"id": "external_commands:SKILL.md:49:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.92,
"reason": "The match is a Markdown code fence or reference-list text in SKILL.md. It is not Ruby backtick execution and no helper script runs there."
},
{
"id": "external_commands:SKILL.md:51:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.92,
"reason": "The match is a Markdown code fence or reference-list text in SKILL.md. It is not Ruby backtick execution and no helper script runs there."
},
{
"id": "external_commands:SKILL.md:55:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.92,
"reason": "The match is a Markdown code fence or reference-list text in SKILL.md. It is not Ruby backtick execution and no helper script runs there."
},
{
"id": "metadata:references/llms-full.md:1:unscanned-file-too-large-manual-review-required",
"verdict": "confirmed",
"confidence": 0.93,
"reason": "The file was not statically scanned because it is oversized, leaving a real audit blind spot. This is a reviewability issue, not evidence of malicious code.",
"severity": "low"
},
{
"id": "metadata:references/other.md:1:unscanned-file-too-large-manual-review-required",
"verdict": "confirmed",
"confidence": 0.93,
"reason": "The file was not statically scanned because it is oversized, leaving a real audit blind spot. This is a reviewability issue, not evidence of malicious code.",
"severity": "low"
},
{
"id": "obfuscation:references/api.md:1:heuristic-multiple-bracket-chains-7-jsfuck-obfus",
"verdict": "false_positive",
"confidence": 0.91,
"reason": "The inspected line is a plain Markdown document heading, not obfuscated JavaScript. The bracket-chain heuristic was triggered by generated documentation punctuation."
},
{
"id": "obfuscation:references/installation.md:1:heuristic-multiple-bracket-chains-6-jsfuck-obfus",
"verdict": "false_positive",
"confidence": 0.91,
"reason": "The inspected line is a plain Markdown document heading, not obfuscated JavaScript. The bracket-chain heuristic was triggered by generated documentation punctuation."
}
],
"semantic_findings": [
{
"title": "Destructive SQL Example Presented Without Warning",
"description": "SKILL.md presents a DROP EXTENSION TimescaleDB statement as a generic quick-reference example. This can remove the extension or break dependent database objects if copied into a live database.",
"severity": "high",
"locations": [
{
"file": "SKILL.md",
"line_start": 49,
"line_end": 53
}
],
"confidence": 0.86,
"confidence_reasoning": "The quick reference labels the statement as an example code pattern without a warning. The SQL operation is inherently destructive in a TimescaleDB database."
}
],
"critical_findings": [],
"high_findings": [
{
"title": "sudo privilege escalation",
"description": "`sudo dnf -qy module disable postgresql`",
"locations": [
{
"file": "references/getting_started.md",
"line_start": 742,
"line_end": 742
}
],
"review_kind": "capability",
"source_category": "external_commands",
"source_severity": "high",
"confidence": 0.72,
"confidence_reasoning": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state."
},
{
"title": "Shell command substitution",
"description": "/bin/bash -c \"$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)\"",
"locations": [
{
"file": "references/installation.md",
"line_start": 1201,
"line_end": 1201
}
],
"review_kind": "capability",
"source_category": "external_commands",
"source_severity": "medium",
"confidence": 0.82,
"confidence_reasoning": "The example downloads a remote installer and executes it with bash. It is visible documentation, but copying it blindly can run arbitrary remote code."
},
{
"title": "Shell command substitution",
"description": "echo \"deb https://packagecloud.io/timescale/timescaledb/debian/ $(lsb_release -c -s) main\" | sudo te",
"locations": [
{
"file": "references/installation.md",
"line_start": 3767,
"line_end": 3767
}
],
"review_kind": "capability",
"source_category": "external_commands",
"source_severity": "medium",
"confidence": 0.76,
"confidence_reasoning": "The command writes package repository configuration with elevated privileges. It is user-visible documentation, but it changes system package trust state."
},
{
"title": "Unix shell invocation",
"description": "/bin/bash -c \"$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)\"",
"locations": [
{
"file": "references/installation.md",
"line_start": 1201,
"line_end": 1201
}
],
"review_kind": "capability",
"source_category": "external_commands",
"source_severity": "medium",
"confidence": 0.82,
"confidence_reasoning": "The example downloads a remote installer and executes it with bash. It is visible documentation, but copying it blindly can run arbitrary remote code."
},
{
"title": "sudo privilege escalation",
"description": "sudo -u postgres psql",
"locations": [
{
"file": "references/installation.md",
"line_start": 564,
"line_end": 564
}
],
"review_kind": "capability",
"source_category": "external_commands",
"source_severity": "high",
"confidence": 0.72,
"confidence_reasoning": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state."
},
{
"title": "sudo privilege escalation",
"description": "sudo apt update",
"locations": [
{
"file": "references/installation.md",
"line_start": 2716,
"line_end": 2716
}
],
"review_kind": "capability",
"source_category": "external_commands",
"source_severity": "high",
"confidence": 0.72,
"confidence_reasoning": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state."
},
{
"title": "sudo privilege escalation",
"description": "sudo apt install timescaledb-toolkit-postgresql-17",
"locations": [
{
"file": "references/installation.md",
"line_start": 2721,
"line_end": 2721
}
],
"review_kind": "capability",
"source_category": "external_commands",
"source_severity": "high",
"confidence": 0.72,
"confidence_reasoning": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state."
},
{
"title": "sudo privilege escalation",
"description": "run `sudo systemctl restart postgresql.service`.",
"locations": [
{
"file": "references/installation.md",
"line_start": 3359,
"line_end": 3359
}
],
"review_kind": "capability",
"source_category": "external_commands",
"source_severity": "high",
"confidence": 0.72,
"confidence_reasoning": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state."
},
{
"title": "sudo privilege escalation",
"description": "sudo -u postgres psql",
"locations": [
{
"file": "references/installation.md",
"line_start": 3390,
"line_end": 3390
}
],
"review_kind": "capability",
"source_category": "external_commands",
"source_severity": "high",
"confidence": 0.72,
"confidence_reasoning": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state."
},
{
"title": "sudo privilege escalation",
"description": "`sudo apt-get install timescaledb-2-postgresql-14='2.6.0*' timescaledb-2-loader-postgresql-14='2.6.0",
"locations": [
{
"file": "references/installation.md",
"line_start": 3532,
"line_end": 3532
}
],
"review_kind": "capability",
"source_category": "external_commands",
"source_severity": "high",
"confidence": 0.72,
"confidence_reasoning": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state."
},
{
"title": "sudo privilege escalation",
"description": "By default, this script is included with the `timescaledb-tools` package when you install TimescaleD",
"locations": [
{
"file": "references/installation.md",
"line_start": 3538,
"line_end": 3538
}
],
"review_kind": "capability",
"source_category": "external_commands",
"source_severity": "high",
"confidence": 0.72,
"confidence_reasoning": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state."
},
{
"title": "sudo privilege escalation",
"description": "`wget --quiet -O - https://packagecloud.io/timescale/timescaledb/gpgkey | sudo apt-key add -`",
"locations": [
{
"file": "references/installation.md",
"line_start": 3558,
"line_end": 3558
}
],
"review_kind": "capability",
"source_category": "external_commands",
"source_severity": "high",
"confidence": 0.72,
"confidence_reasoning": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state."
},
{
"title": "sudo privilege escalation",
"description": "`sudo apt-get install timescaledb-2-postgresql-14='2.6.0*' timescaledb-2-loader-postgresql-14='2.6.0",
"locations": [
{
"file": "references/installation.md",
"line_start": 3566,
"line_end": 3566
}
],
"review_kind": "capability",
"source_category": "external_commands",
"source_severity": "high",
"confidence": 0.72,
"confidence_reasoning": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state."
},
{
"title": "sudo privilege escalation",
"description": "By default, this script is included with the `timescaledb-tools` package when you install TimescaleD",
"locations": [
{
"file": "references/installation.md",
"line_start": 3572,
"line_end": 3572
}
],
"review_kind": "capability",
"source_category": "external_commands",
"source_severity": "high",
"confidence": 0.72,
"confidence_reasoning": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state."
},
{
"title": "sudo privilege escalation",
"description": "`sudo dnf -qy module disable postgresql`",
"locations": [
{
"file": "references/installation.md",
"line_start": 3600,
"line_end": 3600
}
],
"review_kind": "capability",
"source_category": "external_commands",
"source_severity": "high",
"confidence": 0.72,
"confidence_reasoning": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state."
},
{
"title": "sudo privilege escalation",
"description": "`sudo dnf -qy module disable postgresql`",
"locations": [
{
"file": "references/installation.md",
"line_start": 3637,
"line_end": 3637
}
],
"review_kind": "capability",
"source_category": "external_commands",
"source_severity": "high",
"confidence": 0.72,
"confidence_reasoning": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state."
},
{
"title": "sudo privilege escalation",
"description": "sudo apt install gnupg postgresql-common apt-transport-https lsb-release wget",
"locations": [
{
"file": "references/installation.md",
"line_start": 3757,
"line_end": 3757
}
],
"review_kind": "capability",
"source_category": "external_commands",
"source_severity": "high",
"confidence": 0.72,
"confidence_reasoning": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state."
},
{
"title": "sudo privilege escalation",
"description": "sudo /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh",
"locations": [
{
"file": "references/installation.md",
"line_start": 3762,
"line_end": 3762
}
],
"review_kind": "capability",
"source_category": "external_commands",
"source_severity": "high",
"confidence": 0.72,
"confidence_reasoning": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state."
},
{
"title": "sudo privilege escalation",
"description": "echo \"deb https://packagecloud.io/timescale/timescaledb/debian/ $(lsb_release -c -s) main\" | sudo te",
"locations": [
{
"file": "references/installation.md",
"line_start": 3767,
"line_end": 3767
}
],
"review_kind": "capability",
"source_category": "external_commands",
"source_severity": "high",
"confidence": 0.72,
"confidence_reasoning": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state."
},
{
"title": "sudo privilege escalation",
"description": "wget --quiet -O - https://packagecloud.io/timescale/timescaledb/gpgkey | sudo gpg --dearmor -o /etc/",
"locations": [
{
"file": "references/installation.md",
"line_start": 3772,
"line_end": 3772
}
],
"review_kind": "capability",
"source_category": "external_commands",
"source_severity": "high",
"confidence": 0.72,
"confidence_reasoning": "The line contains a privileged installation or administration command. It is legitimate TimescaleDB documentation, but it can alter system or database state."
},
{
"title": "Hardcoded URL",
"description": "/bin/bash -c \"$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)\"",
"locations": [
{
"file": "references/installation.md",
"line_start": 1201,
"line_end": 1201
}
],
"review_kind": "capability",
"source_category": "network",
"source_severity": "low",
"confidence": 0.82,
"confidence_reasoning": "The example downloads a remote installer and executes it with bash. It is visible documentation, but copying it blindly can run arbitrary remote code."
},
{
"title": "Destructive SQL Example Presented Without Warning",
"description": "SKILL.md presents a DROP EXTENSION TimescaleDB statement as a generic quick-reference example. This can remove the extension or break dependent database objects if copied into a live database.",
"locations": [
{
"file": "SKILL.md",
"line_start": 49,
"line_end": 53
}
],
"review_kind": "security",
"source_category": "semantic",
"source_severity": "high",
"confidence": 0.86,
"confidence_reasoning": "The quick reference labels the statement as an example code pattern without a warning. The SQL operation is inherently destructive in a TimescaleDB database."
}
],
"medium_findings": [
{
"title": "Hardcoded URL",
"description": "echo \"deb https://packagecloud.io/timescale/timescaledb/debian/ $(lsb_release -c -s) main\" | sudo te",
"locations": [
{
"file": "references/installation.md",
"line_start": 3767,
"line_end": 3767
}
],
"review_kind": "capability",
"source_category": "network",
"source_severity": "low",
"confidence": 0.74,
"confidence_reasoning": "The URL is part of an installation step that modifies trusted package sources or keys. It is legitimate documentation, but users must verify the source before use."
},
{
"title": "Hardcoded URL",
"description": "wget --quiet -O - https://packagecloud.io/timescale/timescaledb/gpgkey | sudo gpg --dearmor -o /etc/",
"locations": [
{
"file": "references/installation.md",
"line_start": 3772,
"line_end": 3772
}
],
"review_kind": "capability",
"source_category": "network",
"source_severity": "low",
"confidence": 0.74,
"confidence_reasoning": "The URL is part of an installation step that modifies trusted package sources or keys. It is legitimate documentation, but users must verify the source before use."
}
],
"low_findings": [
{
"title": "Unscanned file (too_large) — manual review required",
"description": "[unscanned: too_large]",
"locations": [
{
"file": "references/llms-full.md",
"line_start": 1,
"line_end": 1
}
],
"review_kind": "security",
"source_category": "metadata",
"source_severity": "low",
"confidence": 0.93,
"confidence_reasoning": "The file was not statically scanned because it is oversized, leaving a real audit blind spot. This is a reviewability issue, not evidence of malicious code."
},
{
"title": "Unscanned file (too_large) — manual review required",
"description": "[unscanned: too_large]",
"locations": [
{
"file": "references/other.md",
"line_start": 1,
"line_end": 1
}
],
"review_kind": "security",
"source_category": "metadata",
"source_severity": "low",
"confidence": 0.93,
"confidence_reasoning": "The file was not statically scanned because it is oversized, leaving a real audit blind spot. This is a reviewability issue, not evidence of malicious code."
}
],
"dangerous_patterns": [],
"files_scanned": 13,
"total_lines": 26361,
"audit_model": "codex",
"audited_at": "2026-07-04T16:18:11.855Z",
"agent_auto_install_policy": "confirmation_required",
"manual_install_policy": "allowed"
},
"content": {
"user_title": "Build TimescaleDB Time-Series Apps",
"value_statement": "Time-series data work needs correct schema, retention, and aggregation choices. This skill gives TimescaleDB reference guidance for PostgreSQL developers and database teams.",
"seo_keywords": [
"TimescaleDB",
"time-series database",
"PostgreSQL extension",
"hypertables",
"continuous aggregates",
"time buckets",
"database compression",
"Claude",
"Codex",
"Claude Code"
],
"actual_capabilities": [
"Explains hypertables and time partitioning for PostgreSQL time-series data.",
"Guides continuous aggregates, refresh policies, and real-time aggregate behavior.",
"Provides compression and hypercore guidance for storage and query performance.",
"Helps write TimescaleDB SQL for time buckets, retention, and analytics.",
"Summarizes installation, Rails integration, Docker, Kubernetes, and package setup references.",
"Points users to API, performance, and tutorial sections in bundled references."
],
"limitations": [
"Does not connect to databases or execute SQL by itself.",
"Contains generated documentation snapshots, which may lag current TimescaleDB releases.",
"Some examples include privileged shell commands that need human review before use.",
"Large reference files may be hard to audit manually."
],
"use_cases": [
{
"title": "Design Time-Series Schemas",
"description": "Choose hypertable dimensions, indexes, and chunk intervals for event, metric, or sensor workloads.",
"target_user": "Application developers"
},
{
"title": "Improve Analytics Performance",
"description": "Plan continuous aggregates, compression policies, and time bucket queries for faster dashboards.",
"target_user": "Data engineers"
},
{
"title": "Operate TimescaleDB Deployments",
"description": "Review installation, configuration, migration, and maintenance guidance before changing environments.",
"target_user": "Database administrators"
}
],
"prompt_templates": [
{
"title": "Explain a Hypertable",
"scenario": "Beginner learning task",
"prompt": "Explain how a TimescaleDB hypertable works for a simple sensor readings table. Include when to use time and space dimensions."
},
{
"title": "Plan a Schema",
"scenario": "Intermediate design task",
"prompt": "Help me design a TimescaleDB schema for application events with tenant IDs, timestamps, and retention requirements. Explain the tradeoffs."
},
{
"title": "Tune Aggregates",
"scenario": "Advanced performance task",
"prompt": "Review my continuous aggregate plan for hourly metrics. Suggest refresh windows, indexes, compression choices, and risks to test."
},
{
"title": "Review Installation Steps",
"scenario": "Advanced operations task",
"prompt": "Create a cautious TimescaleDB installation checklist for Ubuntu. Separate commands that require elevated privileges from verification steps."
}
],
"output_examples": [
{
"input": "I need to store sensor readings every second for several devices.",
"output": "A schema plan with a hypertable, recommended partition dimensions, index guidance, and retention considerations."
},
{
"input": "My dashboard query over daily metrics is slow.",
"output": "A troubleshooting path covering time buckets, continuous aggregates, refresh policy timing, and compression effects."
},
{
"input": "I want to install TimescaleDB on a Linux server.",
"output": "A staged checklist that highlights privileged commands, package source changes, and post-install verification."
}
],
"best_practices": [
"Confirm TimescaleDB version and PostgreSQL version before applying reference commands.",
"Test schema, compression, and retention changes on staging data before production use.",
"Review every privileged shell command before running it on a workstation or server."
],
"anti_patterns": [
"Do not paste generated installation commands into production without checking package sources.",
"Do not use continuous aggregates without validating refresh windows and late-arriving data behavior.",
"Do not drop extensions, chunks, or policies unless you have a rollback plan."
],
"faq": [
{
"question": "Does this skill execute database commands?",
"answer": "No. It provides guidance and reference material. Users decide whether to run any SQL or shell command."
},
{
"question": "Can it help with hypertable design?",
"answer": "Yes. It can explain dimensions, chunk sizing, indexes, and common tradeoffs for time-series tables."
},
{
"question": "Can it tune continuous aggregates?",
"answer": "Yes. It can suggest refresh policies, bucket choices, and query patterns based on the included references."
},
{
"question": "Does it cover installation?",
"answer": "Yes. It includes installation references, but privileged commands should be reviewed before use."
},
{
"question": "Is the documentation current?",
"answer": "It is a generated documentation snapshot. Check official TimescaleDB documentation for release-specific changes."
},
{
"question": "Which tools can use this skill?",
"answer": "The report lists support for Claude, Codex, and Claude Code."
}
]
},
"file_structure": [
{
"name": "references",
"type": "dir",
"path": "references",
"children": [
{
"name": "api.md",
"type": "file",
"path": "references/api.md",
"lines": 2196
},
{
"name": "compression.md",
"type": "file",
"path": "references/compression.md",
"lines": 3227
},
{
"name": "continuous_aggregates.md",
"type": "file",
"path": "references/continuous_aggregates.md",
"lines": 1881
},
{
"name": "getting_started.md",
"type": "file",
"path": "references/getting_started.md",
"lines": 2099
},
{
"name": "hyperfunctions.md",
"type": "file",
"path": "references/hyperfunctions.md",
"lines": 1629
},
{
"name": "hypertables.md",
"type": "file",
"path": "references/hypertables.md",
"lines": 7900
},
{
"name": "index.md",
"type": "file",
"path": "references/index.md",
"lines": 48
},
{
"name": "installation.md",
"type": "file",
"path": "references/installation.md",
"lines": 4020
},
{
"name": "llms-full.md",
"type": "file",
"path": "references/llms-full.md",
"lines": 79541
},
{
"name": "llms.md",
"type": "file",
"path": "references/llms.md",
"lines": 382
},
{
"name": "other.md",
"type": "file",
"path": "references/other.md",
"lines": 31381
},
{
"name": "performance.md",
"type": "file",
"path": "references/performance.md",
"lines": 184
},
{
"name": "time_buckets.md",
"type": "file",
"path": "references/time_buckets.md",
"lines": 1324
},
{
"name": "tutorials.md",
"type": "file",
"path": "references/tutorials.md",
"lines": 1362
}
]
},
{
"name": "SKILL.md",
"type": "file",
"path": "SKILL.md",
"lines": 109
}
]
}
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |
| agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |