How to list runtime resources ?

[Grudra1]

I am trying to implement the postgres mcp server in Fastmcp.(ref : https://github.com/modelcontextprotocol/servers/tree/main/src/postgres). I want to list all the tables in the database/schema in the list resource.

For that there should be some method like list_resource. I am not able to create resources at runtime, by querying the information_schema.
Can someone please direct me in the right direction ?

[richardkmichael]

FastMCP will automatically handle the */list (tools/list, resources/list) MCP requests.

The list is prepared from all the items marked with the respective decorators, e.g., @server.tool, @server.resource.

Sounds like you want to create a "tables" resource, and possibly with a custom URI:

@server.resource("sql_schema://tables")
def get_tables(...):
  # ... fetch table list from PostgreSQL

Later you could build a template (dynamic) resource for parameterized schema queries (get tables, get indeces, get views, etc.).

But, note that not many MCP clients (including Claude Desktop & Code) support discovery of resources.