codex - 💡(How to fix) Fix Notion connector exposes SQL query tool in schema, but runtime says tool not found [2 comments, 2 participants]

Official PRs (…)
ON THIS PAGE

Recommended Tools

×6

Utilities matched from this issue’s tags and category — try them while you read without losing context.

GitHub issue graph ai analysis

Paste a GitHub issue URL. We fetch that issue, discover linked issues from bodies/comments/timeline, collect linked pull requests, and produce a structured English report.

The report is written in English Markdown for sharing and archival.

Helpful · Quick feedback

Loading…
GitHub stats
openai/codex#19924Fetched 2026-04-29 06:25:21
View on GitHub
Comments
2
Participants
2
Timeline
6
Reactions
0
Author
Timeline (top)
labeled ×4commented ×2

Error Message

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

RAW_BUFFERClick to expand / collapse

What version of the Codex App are you using (From “About Codex” dialog)?

26.422.30944 (2080)

What subscription do you have?

Plus

What platform is your computer?

Darwin 25.4.0 arm64 arm

What issue are you seeing?

In Codex Desktop with the Notion connector enabled, the tool discovery/schema indicates that Notion supports querying data sources with SQL via notion_query_data_sources.

The tool description says it can:

  • query Notion databases using SQLite SQL
  • use collection://... data source URLs as table names
  • run queries like SELECT * FROM "collection://..." LIMIT 10

However, when actually calling the tool, the Notion MCP backend returns:

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

So the exposed tool schema and the registered runtime MCP tool set appear inconsistent.

What steps can reproduce the bug?

Uploaded thread: 019dd23a-0765-7713-a9d3-e46cc14f6c99

  1. In Codex Desktop, use the Notion connector.
  2. Search for a Notion database.
  3. Fetch the database. This returns a data source URL and a SQLite table definition, e.g. collection://35fb1d57-69a4-4d67-9bea-2d0aad2a34d2
  4. Call notion_query_data_sources with a SQL query such as:
{
  "data": {
    "mode": "sql",
    "data_source_urls": ["collection://35fb1d57-69a4-4d67-9bea-2d0aad2a34d2"],
    "query": "SELECT Status, COUNT(*) AS count FROM \"collection://35fb1d57-69a4-4d67-9bea-2d0aad2a34d2\" GROUP BY Status"
  }
}


### What is the expected behavior?

_No response_

### Additional information

_No response_

extent analysis

TL;DR

The Notion connector in Codex Desktop may have a mismatch between the exposed tool schema and the registered runtime MCP tool set, causing the notion-query-data-sources tool to not be found.

Guidance

  • Verify that the notion-query-data-sources tool is correctly registered in the MCP backend and that the tool schema is up-to-date.
  • Check the Notion connector configuration to ensure that it is properly set up to use the notion_query_data_sources tool.
  • Investigate the possibility of a version mismatch between the Codex Desktop and the Notion connector, as the issue may be related to a specific version of the Codex App (26.422.30944).
  • Review the uploaded thread (019dd23a-0765-7713-a9d3-e46cc14f6c99) for any additional error messages or clues that may help resolve the issue.

Notes

The issue seems to be related to a specific configuration or version mismatch, and resolving it may require further investigation into the Codex Desktop and Notion connector setup.

Recommendation

Apply workaround: Try to manually register the notion-query-data-sources tool in the MCP backend or update the Notion connector to ensure compatibility with the Codex Desktop version.

Vote matrix · Quick signals

Works
Did the solution work? Tap to confirm.
Easy Fix
Was it a quick fix?
Time Saver
Did it save you time?
Blocking
Was it severely blocking?
Common Issue
Are others likely hitting this too?
Flaky / Intermittent
Is it intermittent?
Verified / Reproducible
Can you reproduce it reliably?
Loading…

Still need to ship something?

×6

Another batch ranked right after the header list — different links, same matching logic.

Back to top recommendations

TRENDING

codex - 💡(How to fix) Fix Notion connector exposes SQL query tool in schema, but runtime says tool not found [2 comments, 2 participants]