In case it's useful for anyone, I managed to make it work in Cursor with this configuration:
{
"mcpServers": {
"motherduck": {
"command": "uvx",
"args": [
"mcp-server-motherduck",
"--db-path",
"./chess_pipeline.duckdb"
]
}
}
}