[Feature Request] JSON Export Tool for Query Results

[jlmaoju]

Problem
Current large query results are sent entirely to LLMs, causing:

• Token waste
• Performance issues
• No reusable outputs for downstream workflows

Solution
Add export_to_json tool that:

1. Streams results directly to filesystem
2. Returns only minimal metadata to LLM:

   {
     "success": true,
     "file_path": "/exports/query_12345.json",
     "count": 15000,
     "sample": [first_3_docs]
   }

3. Preserves data for:
   • Visualization tools
   • Subsequent MCP processing
   • Human verification

[nirinchev]

Hey, sorry for the slow response here - I think your suggestion definitely makes sense and we'll try to find the best way to incorporate it into a future release.

[github-actions]

This issue has gone 30 days without any activity and meets the project's definition of "stale". This will be auto-closed if there is no new activity over the next 30 days. If the issue is still relevant and active, you can simply comment with a "bump" to keep it open, or add the label "not_stale". Thanks for keeping our repository healthy!

[jlmaoju]

bump

[himanshusinghs]

Hi @jlmaoju 👋 Thanks for bumping this up! I have a few questions to ask before we consider what we would like to deliver:

1. Because you mentioned that the data could later be used by visualisation tools, I don't think most of those tools have capability to work with EJSON (JSON compatible way to represent BSON values that are stored in MongoDB database). So, the export for such cases will have to have values with lost precision. We have something like this in MongoDB Compass today, documented here. Would you say that the format with lost precision (Relaxed Extended JSON) is all you need for now or do you envision use of the "Default Extended EJSON" and "Canonical Extended EJSON" formats as well?
2. For the tools that would use data for visualisation / analytical processing, isn't a CSV export better? Do you think a CSV export is what you will need more instead of "Relaxed Extended JSON" export?