Run any Skill in Manus with one click

$pwd:

duckdb-sql

Name: Duckdb Sql
Author: SignalPilot-Labs

// Load when hitting DuckDB syntax errors or writing DuckDB-specific SQL. Covers gotchas that differ from PostgreSQL/MySQL.

Run Skill in Manus

$ git log --oneline --stat

stars:462

forks:22

updated:April 20, 2026 at 19:13

SKILL.md

readonly

name	duckdb-sql
description	Load when hitting DuckDB syntax errors or writing DuckDB-specific SQL. Covers gotchas that differ from PostgreSQL/MySQL.
type	skill

DuckDB SQL — Key Differences from PostgreSQL/MySQL

Gotchas

Integer division truncates: 5/2 = 2. Fix: CAST(numerator AS DOUBLE) / denominator
DATE_TRUNC returns TIMESTAMP: Cast result if DATE needed: CAST(DATE_TRUNC('month', col) AS DATE)
INTERVAL syntax: INTERVAL '1' DAY (quoted), NOT INTERVAL 1 DAY
No DATEADD/DATEDIFF: Use col + INTERVAL '1' DAY and DATE_DIFF('day', start, end)
SUM(NULL) = NULL: Not 0. Use COALESCE(SUM(col), 0) if 0 is needed.
ROUND precision: If the YML specifies a decimal type like decimal(6,2), cast the FINAL output to match: CAST(ROUND(AVG(col), 2) AS DECIMAL(6,2)). Do NOT cast the input — cast the result after rounding.
Avoid CURRENT_DATE in models with historical data — use (SELECT MAX(date_col) FROM source) to anchor to the data's actual date range

Date Parsing

Non-ISO strings: STRPTIME(col, '%d/%m/%Y')::DATE
TRY_STRPTIME returns NULL on failure (safe)
Never CAST(date_str AS DATE) on non-ISO strings

QUALIFY Clause

Filter window function results without a subquery:

SELECT *, ROW_NUMBER() OVER (PARTITION BY group ORDER BY col DESC) AS rn
FROM table
QUALIFY rn <= 10

Date Spines

SELECT UNNEST(GENERATE_SERIES(min_date::DATE, max_date::DATE, INTERVAL '1' DAY)) AS date_day

Always use the primary fact table's max date as endpoint — call get_date_boundaries first.

Type Casting

CAST(x AS INTEGER), CAST(x AS DOUBLE), CAST(x AS VARCHAR), CAST(x AS DATE) TRY_CAST returns NULL on failure.

related-skills.json

same repository

notion-context.md

from "SignalPilot-Labs/SignalPilot"

Gather business context from Notion before dbt builds. Searches pages, extracts definitions/decisions/constraints, writes structured context for the build agent and notion-verify subagent.

2026-05-19462

dbt-workflow.md

from "SignalPilot-Labs/SignalPilot"

Load at Step 1 before exploring the project. Covers Notion context gathering, output shape inference, incremental model handling, and what to trust in YML.

2026-05-16462

dbt-debugging.md

from "SignalPilot-Labs/SignalPilot"

Load when dbt run or dbt parse fails. Covers YML duplicate patches, ref errors, passthrough model warnings, current_date fixes, DuckDB error messages, and zero-row diagnosis.

2026-04-20462

dbt-write.md

from "SignalPilot-Labs/SignalPilot"

Load at Step 4 when writing SQL models. Covers column naming, type preservation, JOIN defaults, lookup joins, sibling models, materialization, packages, and filtering rules.

2026-04-20462

bigquery-sql.md

from "SignalPilot-Labs/SignalPilot"

BigQuery-specific SQL patterns: UNNEST for array expansion, STRUCT, ARRAY_AGG, DATE_DIFF/DATE_ADD, backtick-quoted table references, EXCEPT/REPLACE in SELECT, approximate aggregation, partitioned and wildcard tables.

2026-04-14462

sql-workflow.md

from "SignalPilot-Labs/SignalPilot"

Use this skill before writing any SQL query. Covers: output shape inference (cardinality clues from the question), efficient schema exploration, iterative CTE-based query building, structured verification loop (row count, NULL audit, fan-out check, sample inspection), error recovery protocol, saving output to result.sql and result.csv, turn budget management, and common benchmark traps.

2026-04-14462

package.json

"author": "SignalPilot-Labs"

"repository": "SignalPilot-Labs/SignalPilot"

View GitHub Repository View Creator Repositories

$ install --global

$ download --local

Run Skill in Manus

$ useful --forSOC

Software DevelopersComputer and Mathematical Occupations15-1252L4

name	duckdb-sql
description	Load when hitting DuckDB syntax errors or writing DuckDB-specific SQL. Covers gotchas that differ from PostgreSQL/MySQL.
type	skill

DuckDB SQL — Key Differences from PostgreSQL/MySQL

Gotchas

Integer division truncates: 5/2 = 2. Fix: CAST(numerator AS DOUBLE) / denominator
DATE_TRUNC returns TIMESTAMP: Cast result if DATE needed: CAST(DATE_TRUNC('month', col) AS DATE)
INTERVAL syntax: INTERVAL '1' DAY (quoted), NOT INTERVAL 1 DAY
No DATEADD/DATEDIFF: Use col + INTERVAL '1' DAY and DATE_DIFF('day', start, end)
SUM(NULL) = NULL: Not 0. Use COALESCE(SUM(col), 0) if 0 is needed.
ROUND precision: If the YML specifies a decimal type like decimal(6,2), cast the FINAL output to match: CAST(ROUND(AVG(col), 2) AS DECIMAL(6,2)). Do NOT cast the input — cast the result after rounding.
Avoid CURRENT_DATE in models with historical data — use (SELECT MAX(date_col) FROM source) to anchor to the data's actual date range

Date Parsing

Non-ISO strings: STRPTIME(col, '%d/%m/%Y')::DATE
TRY_STRPTIME returns NULL on failure (safe)
Never CAST(date_str AS DATE) on non-ISO strings

QUALIFY Clause

Filter window function results without a subquery:

SELECT *, ROW_NUMBER() OVER (PARTITION BY group ORDER BY col DESC) AS rn
FROM table
QUALIFY rn <= 10

Date Spines

SELECT UNNEST(GENERATE_SERIES(min_date::DATE, max_date::DATE, INTERVAL '1' DAY)) AS date_day

Always use the primary fact table's max date as endpoint — call get_date_boundaries first.

Type Casting

CAST(x AS INTEGER), CAST(x AS DOUBLE), CAST(x AS VARCHAR), CAST(x AS DATE) TRY_CAST returns NULL on failure.

duckdb-sql

DuckDB SQL — Key Differences from PostgreSQL/MySQL

Gotchas

Date Parsing

QUALIFY Clause

Date Spines

Type Casting

More from this repository

More from this repository

DuckDB SQL — Key Differences from PostgreSQL/MySQL

Gotchas

Date Parsing

QUALIFY Clause

Date Spines

Type Casting