I tried to copy the code from MCP's official website(https://www.claudemcp.com/docs/write-ts-server),
and I was able to see all the "tools" listed in my Claude desktop, and when I ask relevant questions, they are triggered automatically.
But when it comes to "resource" and "prompt", I have no idea how to trigger them even if I input the exact "description" of a specific resource, the function simply does not get called.
Unfortunately, you need to add them manually by clicking on the plus sign -> MCP Server -> Prompt/References. Maybe in a later version, this will be included so that it's aware of available prompts and resources and not just tools
I am also trying to build a postgres mcp server and provide table metadata based on user natural query to load the resources at runtime like tools and get a specific tables metadata and use it before writing the sql query.
I think we can just for the meantime put that functionality too as a tool where it takes schema and table name and reads a schema_table.json for extra context.
