A growing interest is devoted to global-scale approaches in ecology and evolution that examine patterns and determinants of species diversity and the threats resulting from global change. These analyses obviously require global datasets of species distribution. Freshwater systems house a disproportionately high fraction of the global fish diversity considering the small proportion of the earth’s surface that they occupy, and are one of the most threatened habitats on Earth. Here we provide complete species lists for 3119 drainage basins covering more than 80% of the Earth surface using 14953 fish species inhabiting permanently or occasionally freshwater systems. The database results from an extensive survey of native and non-native freshwater fish species distribution based on 1436 published papers, books, grey literature and web-based sources. Alone or in combination with further datasets on species biological and ecological characteristics and their evolutionary history, this database represents a highly valuable source of information for further studies on freshwater macroecology, macroevolution, biogeography and conservation.

Using the most comprehensive fish occurrence database, we evaluated the importance of ecological and historical drivers in diversity patterns of subdrainage basins across the Amazon system. Linear models reveal the influence of climatic conditions, habitat size and sub-basin isolation on species diversity. Unexpectedly, the species richness model also highlighted a negative upriver-downriver gradient, contrary to predictions of increasing richness at more downriver locations along fluvial gradients. This reverse gradient may be linked to the history of the Amazon drainage network, which, after isolation as western and eastern basins throughout the Miocene, only began flowing eastward 1–9 million years (Ma) ago. Our results suggest that the main center of fish diversity was located westward, with fish dispersal progressing eastward after the basins were united and the Amazon River assumed its modern course toward the Atlantic. This dispersal process seems not yet achieved, suggesting a recent formation of the current Amazon system.