How to set the timeout for a MySQL query?

[torryspace]

When executing a query, an exception will be thrown if it takes more than 30 seconds.

{"level":"error","timestamp":"2025-04-23T07:52:22.650Z","caller":"logging/logger.go:261","message":"Error executing tool handler","component":"mcp-server","tool":"query_ums","error":"query execution failed: context deadline exceeded","stacktrace":"github.com/FreePeak/cortex/internal/infrastructure/logging.(*Logger).Error\n\t/go/pkg/mod/github.com/!free!peak/cortex@v1.0.5/internal/infrastructure/logging/logger.go:261\ngithub.com/FreePeak/cortex/internal/interfaces/rest.(*MCPServer).processToolsCall\n\t/go/pkg/mod/github.com/!free!peak/cortex@v1.0.5/internal/interfaces/rest/server.go:470\ngithub.com/FreePeak/cortex/internal/interfaces/rest.(*MCPServer).processMessage\n\t/go/pkg/mod/github.com/!free!peak/cortex@v1.0.5/internal/interfaces/rest/server.go:589\ngithub.com/FreePeak/cortex/internal/interfaces/rest.NewMCPServer.func1\n\t/go/pkg/mod/github.com/!free!peak/cortex@v1.0.5/internal/interfaces/rest/server.go:87\ngithub.com/FreePeak/cortex/internal/infrastructure/server.(*SSEServer).handleMessage\n\t/go/pkg/mod/github.com/!free!peak/cortex@v1.0.5/internal/infrastructure/server/sse_server.go:441\ngithub.com/FreePeak/cortex/internal/infrastructure/server.(*SSEServer).ServeHTTP\n\t/go/pkg/mod/github.com/!free!peak/cortex@v1.0.5/internal/infrastructure/server/sse_server.go:566\nnet/http.(*ServeMux).ServeHTTP\n\t/usr/local/go/src/net/http/server.go:2822\nnet/http.serverHandler.ServeHTTP\n\t/usr/local/go/src/net/http/server.go:3301\nnet/http.(*conn).serve\n\t/usr/local/go/src/net/http/server.go:2102"}

[linhdmn]

Hi @torryspace , thanks for reporting this.
I'm working on this and get back to you later.

[linhdmn]

I @torryspace I've just release new version, please checkout README to have new configuration with timeout. Thanks and have a nice day