skills.rest
shekerkamma
shekerkammaCOMMUNITY
Explore all skills by this author →
GitHub

pp-notion

Sync Notion workspaces to local SQLite for offline queries and change tracking.

Updated May 22, 2026
Search Tags:#cli#offline#sqlite#notion#change-tracking#workspace-sync#stale-pages
One-click install
npx skills add https://github.com/shekerkamma/peopletech-marketplace --skill pp-notion-shekerkamma
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: pp-notion
Source: https://github.com/shekerkamma/peopletech-marketplace/tree/main/plugins/integrations/skills/notion
Command: npx skills add https://github.com/shekerkamma/peopletech-marketplace --skill pp-notion-shekerkamma

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Notion's web UI cannot answer compound questions across multiple databases or track changes across a large workspace over time. This Skill provides a CLI-driven way to sync your entire Notion workspace to a local SQLite database, enabling offline queries, stale page detection, and change tracking that the UI simply cannot do efficiently.

Core Features & Use Cases

  • Offline Workspace Sync: Mirror your entire Notion workspace to a local SQLite store for fast, offline access and search.
  • Stale Page Detection: Identify pages and records not edited in N days, filterable by database, parent, or tag.
  • Change Tracking: See exactly what was added, edited, or deleted since your last sync or a given timestamp.
  • Use Case: A project manager can run a single command to find all project pages untouched for 30+ days across multiple workspaces, something impossible to do manually in Notion.

Quick Start

Use the pp-notion skill to sync your Notion workspace to a local SQLite database and list all pages that have not been edited in the last 30 days.

Frequently Asked Questions about pp-notion

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I query Notion workspaces offline?▼

You can query Notion workspaces offline by syncing the workspace to a local SQLite database. This enables fast offline access and cross-database joins without relying on the Notion web UI.

How do I find stale Notion pages that haven't been edited in 30 days?▼

To find stale Notion pages, you can use the stale page detection feature after syncing your workspace to SQLite. It identifies pages untouched for N days, filterable by database, parent, or tag.

Can I track changes across a Notion workspace over time?▼

Yes, you can track changes across a Notion workspace by syncing to a local SQLite database. This allows you to see exactly what was added, edited, or deleted since your last sync or a given timestamp.

Does this Notion sync tool require API credentials?▼

Yes, syncing your Notion workspace requires the notion-pp-cli binary and Notion API credentials. You must configure your environment with NOTION_BEARER_AUTH credentials to enable the local synchronization layer.

What is the best way to run cross-database joins for a Notion project audit?▼

The best way to run cross-database joins for a Notion project audit is by syncing your workspace to a local SQLite database. This CLI-driven approach bypasses the web UI limitations to execute compound queries efficiently.

Why does my Notion workspace audit fail in the web UI?▼

Your Notion workspace audit fails in the web UI because the interface cannot answer compound questions across multiple databases or track changes over time. Syncing to a local SQLite database solves this by enabling offline queries and change tracking.

Related Skills

Explore More Product & Management Skills→
zkcpkuzkcpku

notion

Create, retrieve, and modify Notion pages, databases, and blocks via API.

Community
Intermediate
pinion05pinion05
3

health-data

Query Apple Health SQLite data and export summaries as Markdown, JSON, or FHIR R4.

Community
Intermediate
dgethingsdgethings

atlassian-itsm

Automate Jira and Confluence ITSM workflows with human-in-the-loop governance.

Community
Advanced
automatedigitalautomatedigital
1

notion

Interact with Notion workspaces via curl and the Notion API.

Official
Intermediate