Claude desktop app passing paramter to mcp server but displayed as null in the UI

[sivankri]

Issue1: Claude desktop app passing tools required paramter to mcp server but displayed as null in the UI. The 'query' parameter is displayed as null here but passed to server with value.

Request
{
limit: 100,
query: null,
offset: 0
}
Response

[{"PRODUCT_ID":1,"PRODUCT_NAME":"Laptop","UNIT_PRICE":500},{"PRODUCT_ID":2,"PRODUCT_NAME":"Smartphone","UNIT_PRICE":300},{"PRODUCT_ID":3,"PRODUCT_NAME":"Headphones","UNIT_PRICE":30},{"PRODUCT_ID":4,"PRODUCT_NAME":"Keyboard","UNIT_PRICE":20},{"PRODUCT_ID":5,"PRODUCT_NAME":"Mouse","UNIT_PRICE":15},{"PRODUCT_ID":6,"PRODUCT_NAME":"Monitor","UNIT_PRICE":120},{"PRODUCT_ID":7,"PRODUCT_NAME":"USB Drive","UNIT_PRICE":10},{"PRODUCT_ID":8,"PRODUCT_NAME":"External HDD","UNIT_PRICE":80},{"PRODUCT_ID":9,"PRODUCT_NAME":"Printer","UNIT_PRICE":100},{"PRODUCT_ID":10,"PRODUCT_NAME":"Webcam","UNIT_PRICE":45}]

Issue2: Few times the query parameter is not passed. How do we mandate the query parameter is being sent?

2025-12-15T17:15:09.818Z [TreeSpeciesDatabase] [info] Message from client: {"method":"tools/call","params":{"name":"RUN_SQL","arguments":{"query":"SELECT * FROM ADMIN.TREE_DATA WHERE ROWNUM <= 5","limit":5,"offset":0}},"jsonrpc":"2.0","id":6} { metadata: undefined }
[24455] [Local→Remote] tools/call
[24455] [Remote→Local] 6
2025-12-15T17:15:10.530Z [TreeSpeciesDatabase] [info] Message from server: {"jsonrpc":"2.0","id":6,"result":{"content":[{"type":"text","text":"{"error":"Internal error executing MCP tool."}"}],"isError":true}} { metadata: undefined }
2025-12-15T17:15:16.185Z [TreeSpeciesDatabase] [info] Message from client: {"method":"tools/call","params":{"name":"RUN_SQL","arguments":{"limit":100,"offset":0,"query":"SELECT * FROM ADMIN.TREE_DATA WHERE ROWNUM <= 5"}},"jsonrpc":"2.0","id":7} { metadata: undefined }
[24455] [Local→Remote] tools/call
[24455] [Remote→Local] 7
2025-12-15T17:15:16.896Z [TreeSpeciesDatabase] [info] Message from server: {"jsonrpc":"2.0","id":7,"result":{"content":[{"type":"text","text":"{"error":"Internal error executing MCP tool."}"}],"isError":true}} { metadata: undefined }
2025-12-15T17:15:21.458Z [TreeSpeciesDatabase] [info] Message from client: {"method":"tools/call","params":{"name":"RUN_SQL"},"jsonrpc":"2.0","id":8} { metadata: undefined }
[24455] [Local→Remote] tools/call
[24455] [Remote→Local] 8
2025-12-15T17:15:22.165Z [TreeSpeciesDatabase] [info] Message from server: {"jsonrpc":"2.0","id":8,"result":{"content":[{"type":"text","text":"{"error":"Internal error executing MCP tool."}"}],"isError":true}} { metadata: undefined }
2025-12-15T17:15:26.809Z [TreeSpeciesDatabase] [info] Message from client: {"method":"tools/call","params":{"name":"RUN_SQL"},"jsonrpc":"2.0","id":9} { metadata: undefined }