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"
      ]
    }  
  }
}