{"id":"dr5hn-countries-states-cities-database","name":"countries-states-cities-database","homepage":"http://countrystatecity.in/","repo_url":"https://github.com/dr5hn/countries-states-cities-database","category":"databases","subcategories":[],"tags":["databases","geographical-data","countries","states","cities","csv","json","sql","sqlite","mongodb","geojson","api","open-source","iso-codes","timezones"],"what_it_does":"Provides a global dataset of countries, states/regions, and cities (including ISO codes, names, coordinates, and timezones for countries) distributed as downloadable files and via an associated REST API ecosystem. Exports are available in many formats (e.g., JSON, CSV, SQL/MySQL/PostgreSQL, SQLite, MongoDB, XML, YAML, GeoJSON, and TOON).","use_cases":["Populate applications with normalized geographic hierarchy (country → state/region → city)","Offline ingestion into databases via SQL/SQLite/MySQL/PostgreSQL/MongoDB dumps","Geocoding-like UI dropdowns (countries/states/cities) and validation of user inputs","Analytics/GIS pipelines using GeoJSON and coordinate fields","LLM-friendly context formatting using TOON","Building administrative tools that need consistent geographic reference data"],"not_for":["Authoritative real-time location search/geocoding beyond the static dataset","Systems requiring strict provenance/audit trails beyond the published dataset updates","Use as a live reference source without ensuring you keep dataset/API versions updated"],"best_when":"You need a large, regularly updated reference dataset across multiple formats, or you need quick integration through ready-to-use client packages/export downloads.","avoid_when":"You require transactional correctness of “current” administrative boundaries or live data; treat this as reference data that may lag behind real-world changes.","alternatives":["Other open geographic datasets (e.g., Natural Earth + administrative boundary sources)","Commercial/geographic reference APIs (e.g., location autocomplete services)","OpenStreetMap-derived place datasets","Wikidata-based entity/location databases"],"af_score":54.2,"security_score":47.5,"reliability_score":48.8,"package_type":"skill","discovery_source":["openclaw"],"priority":"high","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-03-29T14:54:53.001745+00:00","interface":{"has_rest_api":true,"has_graphql":false,"has_grpc":false,"has_mcp_server":false,"mcp_server_url":null,"has_sdk":true,"sdk_languages":["JavaScript","TypeScript","Python"],"openapi_spec_url":"https://github.com/dr5hn/csc-swagger","webhooks":false},"auth":{"methods":["API via REST (implied)","No auth described for direct downloads / offline packages"],"oauth":false,"scopes":false,"notes":"The README notes the REST API exists and references docs/playground, but it does not describe authentication method details or scopes. It also describes free tier/credits for API/export tools, implying some form of access control or quota may apply, but specifics are not provided in the supplied content."},"pricing":{"model":"Free tier + paid credits (for API and/or export to","free_tier_exists":true,"free_tier_limits":null,"paid_tiers":[],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"README states REST API has a 'free tier + paid' model and export tool is 'free + credits', but it does not provide concrete pricing/limits in the supplied content."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":54.2,"security_score":47.5,"reliability_score":48.8,"mcp_server_quality":0.0,"documentation_accuracy":65.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":60.0,"rate_limit_clarity":30.0,"tls_enforcement":70.0,"auth_strength":35.0,"scope_granularity":30.0,"dependency_hygiene":45.0,"secret_handling":60.0,"security_notes":"Direct dataset downloads and offline packages reduce credential risk. However, the supplied content does not describe REST API authentication details, scopes/authorization model, or rate-limit headers; thus auth and operational security cannot be fully validated. TLS requirement is not explicitly stated in the provided README.","uptime_documented":55.0,"version_stability":65.0,"breaking_changes_history":40.0,"error_recovery":35.0,"idempotency_support":"false","idempotency_notes":null,"pagination_style":"none","retry_guidance_documented":false,"known_agent_gotchas":["The provided content does not specify REST error formats, retry/backoff guidance, pagination behavior, or idempotency guarantees; these may exist in the referenced API docs/OpenAPI but are not present in the supplied text.","Large exports are served from GitHub Releases (not committed to git); agents must handle download/extraction correctly (e.g., .gz)."]}}