World Database API - Countries, Cities & Languages
← Back to Dashboard

World Database Explorer

Comprehensive geographic data API powered by the MySQL World Database. Explore countries, cities, languages, and continental statistics with advanced filtering and search capabilities.

GET /location/health

Service health check with database connectivity verification and table status.

Check Health

GET /location/countries

List all countries with pagination support. Includes basic country information.

View Countries

GET /location/cities

Browse cities with filtering by country and population. Supports pagination.

View Cities

GET /location/languages

Language statistics showing distribution across countries and usage percentages.

View Languages

GET /location/continents

Continental statistics including population totals and country counts.

View Continents

GET /location/stats

Overall database statistics and summary information.

View Statistics

GET /location/search

Search countries and cities by name with intelligent ranking.

Try Search

GET /location/info

Service information and complete API documentation.

API Info

Example Queries

→ Get USA details: /location/countries/USA → US cities over 1M: /location/cities?country=USA&min_population=1000000 → Cities with pagination: /location/cities?page=2&limit=10 → Search for "New": /location/search?q=New → China details: /location/countries/CHN → City by ID: /location/cities/1