Ready to supercharge your AI agents?

Install any skill in seconds. Free to start, no credit card required.

Fetch and process · avizmarlon | DecimalAI

codingby avizmarlon

Fetch and process

avizmarlon/notion-batch-pattern

Source avizmarlon/agent-skills ↗License MIT

Use Notion REST API (not MCP) for batch operations (≥3 rows). Applies to database queries, batch updates, scans, pagination, file uploads, database creation, and page replication. MCP is acceptable only for single-page CRUD operations.

SkillScore92Maintained

Automatic

Coding pack

Last verified 8/3/2026

What it changes

Passed 22 of 24 test cases with the skill, and 17 of 24 without it.

Without skill71%

With skill92%

Checks it passed that the model alone missed

Explains that MCP rarely supports file upload operations.
Explains that MCP cannot perform reliable full database scans.
Explains that MCP lacks a pagination mechanism for search results.

and 3 more in the full report

5 fixed17 passed either way2 still failing0 broke

Pass-rate lift: +21 pp
Tokens: +109%
Agent turns: 0%
Response time: -28%

Model gemini-3.6-flashMeasured 8/3/2026v122 of 24 cases passed with skill

Tokens, turns and time describe resource use, not a dollar price.

Use this skill

Save it into your project's skills folder. Claude Code picks it up in its next session.

curl -fsSL --create-dirs -o .claude/skills/avizmarlon-notion-batch-pattern/SKILL.md https://app.decimal.ai/s/avizmarlon-notion-batch-pattern/SKILL.md

Want it pinned and updatable? pip install "decimalai>=0.15", then decimalai skills add avizmarlon-notion-batch-pattern, and start Claude Code with claude --plugin-dir "$(git rev-parse --show-toplevel)/.agents"

1 · One-time — install the CLI (docs ↗)

pip install "decimalai>=0.15"

2 · Get the skill — writes .agents/skills/avizmarlon-notion-batch-pattern/ and pins it in .decimal/skills.lock

decimalai skills add avizmarlon-notion-batch-pattern

No CLI? Get the same file — curl · raw file

curl -fsSL --create-dirs -o .claude/skills/avizmarlon-notion-batch-pattern/SKILL.md https://app.decimal.ai/s/avizmarlon-notion-batch-pattern/SKILL.md

Raw file: /s/avizmarlon-notion-batch-pattern/SKILL.md ↗ · machine-readable summary at /s/avizmarlon-notion-batch-pattern.json ↗

Safety checks: 3 of 3 passed

Code scan CleanIntent PassedContent Clean

See it in action

One of 5 test cases the skill fixed. Same model, same prompt, with and without the skill.

1 of 5

Prompt

A user wants an AI assistant to fetch and display the content of a single Notion page with ID page-123. An engineer proposes writing a custom Python script with bearer token authentication against HTTP endpoints. Which tool mechanism is recommended for this single-page read operation?

What was checked, without and with the skill
Checked	Without skill	With skill
Recommends using Model Context Protocol (MCP).	Passed	Passed
Explains that MCP has simpler setup and no auth management overhead for single-page CRUD.	Missed	Passed

case-02 · gemini-3.6-flash · 8/3/2026 · answers are capped and redacted

What's inside

The instructions your model reads when the skill loads.

SKILL.md145 linessingle file

When to use Notion API vs. MCP

Notion API (REST) is mandatory for batch operations; MCP (Model Context Protocol) is for single-page CRUD only.

The problem with MCP for batch work

Most Notion MCP implementations have critical limitations for scaled operations:

Hard cap on results: semantic search limited to ~25 results per query with no pagination mechanism
No full database scan: cannot iterate over all rows in a database reliably
Whack-a-mole pattern: multiple sequential queries required to retrieve complete data, leading to repeated context loading and inefficient execution
No file uploads: many MCP versions do not support file upload operations

Real-world impact: A task requiring batch standardization of 65+ rows may take 4+ separate API calls via MCP (each capped at 25 results, no pagination), whereas the same task via Notion REST API with proper pagination completes in a single pass.

Decision tree

Operation	Recommended Tool	Why
Create 1 page, read 1 page, update single entry, inline comment/annotation	MCP	Simpler setup, no auth management overhead
Query entire database, batch update (≥3 rows), full scan/inventory, any operation requiring pagination	Notion REST API	Full pagination support, no result caps, complete control
File upload (bulk or single)	Notion REST API	MCP rarely supports this; REST API has official file upload endpoints
Database creation or replication of page structure	Notion REST API	Programmatic structure building requires full API control

Using Notion REST API

Prerequisites

Notion API Token — create at https://www.notion.com/my-integrations and grant permissions to databases/pages you need.
Store securely — save the token in environment variables (e.g., NOTION_TOKEN) or a credential vault; never hardcode.
Pagination awareness — Notion returns max 100 items per request; use start_cursor and next_cursor for full retrieval.

Implementation pattern

The Notion REST API covers pages (CRUD), databases (query with pagination), blocks (children enumeration), users, and comments. Rate limits are typically 3 requests/second; include backoff for 429 responses. Check the official API reference for the current version.

Example: Query a database with pagination

import os

Track record

Benchmark

22 / 24

test cases passed, vs 17 / 24 without

Adoption

Users: 0
Times used: 0

Safety and source details

SkillSafety

✓ 3 of 3 passed

Code scan15 of 15 checks clean

0 critical · 0 warning · 0 info — scanner v4 — 8/1/2026

View 15 scanner checks

live_secretremote_code_executionreverse_shelldata_exfiltrationssrf_metadataagent_snoopinganti_refusaldestructive_commandsobfuscated_unicodeunicode_homoglyphopaque_blobsuspicious_urltool_overreachtrigger_abuseprompt_injection_phrasing

IntentSafe

LLM judge · does the skill do what it claims

ContentClean

LLM judge · policy & harmful-content review

Source

Imported

avizmarlon / agent-skills

skills/notion-batch-pattern/SKILL.md

View on GitHub ↗

License MITImported 8/1/2026Version v1

Other skills for the same job

Published skills whose descriptions closely match this one, with their headline benchmark lift.

avizmarlon/notion-apiUse Notion's REST API directly for batch database operations (querying, updating many rows, pagination, file uploads, creating databases). Auto-load when tasks mention Notion AND batch operations like "database", "update many", "iterate pages", "audit", "scan", or touch ≥3 rows. Prefer MCP (Notion search/create) for single-page CRUD only.Close match+45 pp pass-rate lift

More skills from the same source and nearby in the registry, with their headline benchmark lift.