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.

The relative importance of contemporary and historical processes is central for understanding biodiversity patterns. While several studies show that past conditions can partly explain the current biodiversity patterns, the role of history remains elusive. We reconstructed palaeo-drainage basins under lower sea level conditions (Last Glacial Maximum) to test whether the historical connectivity between basins left an imprint on the global patterns of freshwater fish biodiversity. After controlling for contemporary and past environmental conditions, we found that palaeo-connected basins displayed greater species richness but lower levels of endemism and beta diversity than did palaeo-disconnected basins. Palaeo-connected basins exhibited shallower distance decay of compositional similarity, suggesting that palaeo-river connections favoured the exchange of fish species. Finally, we found that a longer period of palaeo-connection resulted in lower levels of beta diversity. These findings reveal the first unambiguous results of the role played by history in explaining the global contemporary patterns of biodiversity.