The Most Complete Public APIs Directory in 2026 (1,555 APIs with Auth, SDKs & Rate Limits)
Source: Dev.to
Introduction
If you’ve ever built a side project, you know the drill: you have an idea, you start building, and then you spend hours searching for the right API.
Is there a free weather API? Does it need an API key? What’s the rate limit? Does it have a Python SDK?
I got tired of that workflow, so I built a curated CSV dataset containing 1,555 public APIs across 52 categories, enriched with the information you actually need before integrating an API.
Dataset Overview
| Field | Example |
|---|---|
| Name | OpenWeatherMap |
| Category | Weather |
| Description | Real‑time weather data by city or coordinates |
| Base URL | api.openweathermap.org |
| Auth Type | API Key |
| Free Tier | Yes |
| Free Limit | 1,000 req/day |
| Available SDKs | Python, JavaScript, Ruby |
| Docs URL | |
| Popularity | High |
You can open the CSV in Excel, Google Sheets, Notion, or Airtable. Filter by category, sort by auth type, search by SDK. No login, no account, no dependencies.
Largest Categories
- Development – 154 APIs
- Geocoding – 94 APIs
- Games & Comics – 89 APIs
- Government – 83 APIs
- Transportation – 66 APIs
- Cryptocurrency – 55 APIs
- Finance – 55 APIs
- Video – 50 APIs
- Documents & Productivity – 48 APIs
- Social – 39 APIs
- Security – 37 APIs
- Sports & Fitness – 37 APIs
- Weather – 36 APIs
- Machine Learning – 30 APIs
- Music – 32 APIs
Plus 37 more categories including Animals, Anime, Books, Calendar, Email, Environment, Health, Jobs, Photography, Shopping, and more.
Example APIs by Category
- Weather: Open‑Meteo (unlimited, no auth), WeatherAPI, OpenWeatherMap
- Finance: Alpha Vantage, Fixer, ExchangeRate API
- Machine Learning: Hugging Face, Stability AI, OpenAI
- Geocoding: Mapbox, OpenStreetMap, HERE
- Government: NASA, data.gov, EU Open Data Portal
- Games: RAWG, IGDB, Open Trivia Database
Who Can Benefit
- Developers prototyping apps who need a quick API reference
- Indie hackers validating ideas before committing to a paid API
- Students building portfolio projects with real data
- No‑code builders connecting tools via Make, Zapier, or n8n
- Data scientists looking for free data sources
Accessing the Dataset
The full dataset (1,555 APIs, CSV format) is available here:
- DataStackHQ on Payhip — $9 one‑time, instant download
If you find it useful, I’ll be releasing more datasets. Drop a comment with the category you’d like to see next.
How It Was Built
- Scraped the public‑apis community repository (one of the most maintained API directories on GitHub with 300k+ stars).
- Enriched each entry using Claude AI to fill in missing fields: free limits, SDK availability, and popularity scoring.
- The entire pipeline took about 3 hours of scripting and roughly $0.02 in API costs.
Built with Python, pandas, and the Anthropic API. The source repository is public-apis/public-apis on GitHub.