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.