Algolia + Steampipe

select
  rank,
  hit
from
  algolia_search
where
  index = 'offices'
  and query = 'usa'
order by
  rank;

+------+---------------------------------------------------------+
| rank | hit                                                     |
+------+---------------------------------------------------------+
| 1    | { "name": "Scranton", "state": "PA", "country": "USA" } |
| 2    | { "name": "Stamford", "state": "CT", "country": "USA" } |
+------+---------------------------------------------------------+

steampipe plugin install algolia

connection "algolia" {
  plugin  = "algolia"
  app_id  = "D902ND8AK3"
  api_key = "dba7ac3a72a41306c5b34207b9fd9d95"
}