Skip to content

[notion] Replace invalid SQLite CONTAINS query in progress-tracking reference #525

Description

@100yenadmin

Reproduction

Verified against openai/skills main at 49f948faa9258a0c61caceaf225e179651397431.

skills/.curated/notion-spec-to-implementation/reference/progress-tracking.md documents:

WHERE "Related Tasks" CONTAINS "plan-page-id"

The current Notion query_data_sources tool contract says SQL mode executes read-only SQLite queries. CONTAINS is not a SQLite infix operator, so this query fails before it can filter a relation property.

Expected

The example should use a parameterized predicate that is valid for the fetched SQLite schema and the actual serialized relation value.

Suggested narrow fix

  • Fetch the data-source schema first.
  • Replace CONTAINS with a supported, parameterized SQLite predicate appropriate to the relation representation.
  • Add a focused syntax/fixture test that executes the documented query against a representative relation value.

This was reproduced from tool schema and source only; no Notion workspace data was queried.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions