Insert blocks when run as a child process (MCP STDIO server)

[fredrikjacobson]

Hi,

I'm facing issues when trying to utilize chdb-go within an MCP server. I believe the issue is similar to what is found here chdb-io/chdb#152 reported about jupyter notebook.

Essentially the issue comes from when running it as a subprocess. Running the code directly works fine, but when ran as a subprocess it hangs.

I also tried to redirect stdin/stdout during chdb function calls but was not able to resolve the issue with the application hanging.

Is there any way to create a connection with chdb with your own defined pipes instead of relying on stdin and stdout? Or any information as to the underlying issue and possible resolutions?

For additional context, here's how the MCP client is spawning the subprocesses

Thanks in advance!