iwatobipen.wordpress.com
Use MCP for making query of Database #cheminformatics #AI
Recently I have interest to MCP. Because MCP can engage task and API with natural language so we don't need code (BTW, I love writing code!!!!). Today I tried to make SQL query with MCP. I used Claude desktop. At first I modfied config file shown below. postgres part is added. $ vim ~/.config/Claude/claude_desktop_config.json { "mcpServers": { "weather": { "command": "uv", "args": [ "--directory", "/home/iwatobipen/dev/weather", "run", "weather.py" ] }, "chemblmcp": { "command": "uv", "args": [ "--directory", "/home/iwatobipen/dev/chembl_mcp", "run", "chemblmcp.py" ] }, # this part is used for communicating postgres!!!