[Notion connector] query_data_sources is advertised but backend returns -32602 "Tool not found"

[daniribeiroBR]

What version of the Codex App are you using?

ChatGPT/Codex Desktop: 26.715.70719 (build 5650)
Codex CLI: 0.144.4

What subscription do you have?

ChatGPT Pro (USD 200/month)

What platform are you using?

macOS 26.5 (build 25F71)
Apple Silicon / arm64

What issue are you seeing?

The Notion connector advertises the following callable tool:

mcp__codex_apps__notion_notion_query_data_sources

However, calling it with the documented request shape returns:

MCP error -32602: Tool notion-query-data-sources not found

This is not a general Notion authentication or workspace-permission failure:

• notion_fetch successfully reads a private Notion database and returns its complete schema.
• notion_search successfully returns pages from the same database.
• The database schema includes the properties used by the SQL query.
• Only notion_query_data_sources fails.
• The failure occurs at tool dispatch, before the query or database content is evaluated.

The Notion plugin was reconnected and the test was repeated in a newly created Codex thread. The result remained the same.

Steps to reproduce

1. Install and connect the Notion plugin in Codex Desktop.
2. Start a new Codex thread.
3. Fetch a Notion database using notion_fetch.
4. Confirm that fetch returns the database schema and a collection:// data-source URL.
5. Call the advertised notion_notion_query_data_sources tool:

{
  "data": {
    "mode": "sql",
    "data_source_urls": [
      "collection://REDACTED"
    ],
    "query": "SELECT \"Status\", COUNT(*) AS \"quantity\" FROM \"collection://REDACTED\" GROUP BY \"Status\""
  }
}

Actual result

RuntimeException: Error calling MCP tool:
MCP error -32602: Tool notion-query-data-sources not found

Structured error:

{
  "error_code": "INVALID_ARGUMENT",
  "error_data": {
    "type": "mcp_tool_execution_error",
    "result": {
      "content": [
        {
          "type": "text",
          "text": "MCP error -32602: Tool notion-query-data-sources not found"
        }
      ],
      "isError": true
    }
  }
}

Expected result

The advertised tool should execute the SQL query.

If the feature is unavailable because of plan, workspace policy, or connector configuration, Codex should return an explicit entitlement or permission error instead of advertising a backend method that does not exist.

Additional information

Observed on 2026-07-21 at approximately 18:08 UTC-03:00.

The diagnostic was read-only. No Notion content was created, updated, or deleted.

This may be a manifest/backend version mismatch:

• Codex exposes notion_notion_query_data_sources in the active tool catalog.
• The connector backend reports that the corresponding notion-query-data-sources method does not exist.

Potentially related reports:

• Codex MCP OAuth sessions expire and require application restart #32590 — stale Notion MCP tool registry after authentication
• Notion connector tools remain 401 after reconnect in Codex desktop #24848 — Notion tools discovered but unusable after reconnect

No private database IDs, workspace names, or private content are included in this report.

[u6tory]

same here

[DimitrijRees]

same here