Spatial

What it does

When your agent uses it

• The user mentions locations
• Geographic names
• Spatial file formats (GeoJSON
• The user wants to find places

Example prompts

• “within”
• “closest”
• “/spatial”

Requirements

• Pre-approved tools (allowed-tools): Bash

Workflow steps

3 steps, taken from the step headings in SKILL.md.

1. 1Understand what the user needs
2. 2Write and run the query
3. 3Present results

What it can do on your machine

Read from SKILL.md and the folder at commit 7feda8e. It shows what the files ask for, not the result of running them.

• Tool permissions

  Pre-approves these tools, so the agent can use them without asking each time:

  • Bash

  From allowed-tools in the SKILL.md frontmatter.

• Runs code

  Shell commands in SKILL.md call:

  • duckdb

  From the folder's file list and the shell code blocks in SKILL.md.

• Network

  No URLs in SKILL.md.

  From URLs in SKILL.md, links to its own repository left out.

• Credentials

  Names no API keys, tokens, secrets or passwords.

  From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Spatial loads about 1k tokens when it runs, and up to ~3.9k if it reads all its reference files. Until then it costs about 133 tokens; SKILL.md has 413 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it

~133

When it runs · the whole SKILL.md, loaded when a task matches

~1k

With references · SKILL.md plus every file in references/, read only if the agent opens them

~3.9k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

• NotePre-approves every shell command (allowed-tools: Bash)SKILL.md

  allowed-tools: Bash

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from duckdb/duckdb-skills at commit 7feda8e, republished under its MIT licence (© duckdb). 413 words, ~1,026 tokens.

name

spatial

description

Answer questions about spatial data using DuckDB. Use when the user mentions locations, coordinates, lat/lng, distances, maps, addresses, "near", "within", "closest", geographic names, or spatial file formats (GeoJSON, Shapefile, GeoPackage, GPX, GeoParquet). Also triggers when the user wants to find places, buildings, or roads — Overture Maps provides free global data on S3 with zero API keys. Handles spatial joins, distance calculations, containment checks, density analysis, and format conversions for geographic data.

allowed-tools

Bash

argument-hint

<question or file> [additional context]

LOAD spatial;
SET geometry_always_xy = true;

ST_Point(ST_X(geometry), ST_Y(geometry))::POINT_2D

duckdb -c "
LOAD spatial;
<ADDITIONAL_SETUP>
<YOUR_QUERY>
"

© duckdb, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 2 other files (references) in skills/spatial of duckdb/duckdb-skills.

• SKILL.md
• references/functions.md
• references/overture.md

Open the folder on GitHubat commit 7feda8e

Used in 1 other repository

We found 1 copy of this SKILL.md (exact, near-identical or edited) in other folders, from 1 other GitHub owner. This page covers the copy in duckdb/duckdb-skills, which our catalogue first saw on October 7, 2026.

• ipea/geocodebr.claude/skills/spatial