Thanks to @crewsycrews
- Upgraded @modelcontextprotocol/sdk to a higher version for streamableHttp transport support.
- Added expess dependency so we could run an http server.
- Followed this docs to implement Remote mode.
- Added readme section on how to setup Remote MCP
- Some formatting changes are there(sorry, I can't fight against my IDE to not doing it).
- Fixed ListResourcesRequestSchema handler to properly return the resources list from the DB
- Fixed CallToolRequestSchema handler to return errors so that agents could understand the issues with the queries(if there are any).