How do I list countries?
Table of Contents
List countries via ores.cli. See the CLI inventory for sibling recipes.
Question
How do I list countries?
Answer
The CLI reads database credentials from ORES_CLI_* environment variables
when they are set in the shell. Use either approach:
- With
.env: source the file first soORES_CLI_DB_*vars are exported, then omit the explicit DB flags. - With explicit db args: pass
--db-user,--db-password, and--db-databasedirectly.
--tenant accepts a tenant UUID (also reads ORES_TENANT env var).
Omitting it returns no rows — all data is tenant-scoped.
ORES_TENANT is not written to .env automatically; export it in your
shell after provisioning, or add it manually:
export ORES_TENANT=<tenant-uuid> # e.g. the Barclays UUID from provision output
List all as table (using .env)
set -a && source .env && set +a ./ores.cli refdata countries list \ --tenant "$ORES_TENANT" \ --format table 2>&1 | head -n 15
+---------+---------+---------+---------+-----------------------------------+---------------------------------------------------------------------------+-----------------------------+-----------------------------------+-------------------------------+ | Alpha-2 | Alpha-3 | Numeric | Version | Name | Official Name | Change Reason | Modified By | Recorded At | +---------+---------+---------+---------+-----------------------------------+---------------------------------------------------------------------------+-----------------------------+-----------------------------------+-------------------------------+ | AD | AND | 020 | 1 | Andorra | Principality of Andorra | system.external_data_import | ores_prime_origin_refdata_service | 2026-06-25 10:13:26.000000000 | | AE | ARE | 784 | 1 | United Arab Emirates | United Arab Emirates | system.external_data_import | ores_prime_origin_refdata_service | 2026-06-25 10:13:26.000000000 | | AF | AFG | 004 | 1 | Afghanistan | Islamic Republic of Afghanistan | system.external_data_import | ores_prime_origin_refdata_service | 2026-06-25 10:13:26.000000000 | | AG | ATG | 028 | 1 | Antigua and Barbuda | Antigua and Barbuda | system.external_data_import | ores_prime_origin_refdata_service | 2026-06-25 10:13:26.000000000 | | AI | AIA | 660 | 1 | Anguilla | Anguilla | system.external_data_import | ores_prime_origin_refdata_service | 2026-06-25 10:13:26.000000000 | | AL | ALB | 008 | 1 | Albania | Republic of Albania | system.external_data_import | ores_prime_origin_refdata_service | 2026-06-25 10:13:26.000000000 | | AM | ARM | 051 | 1 | Armenia | Republic of Armenia | system.external_data_import | ores_prime_origin_refdata_service | 2026-06-25 10:13:26.000000000 | | AO | AGO | 024 | 1 | Angola | Republic of Angola | system.external_data_import | ores_prime_origin_refdata_service | 2026-06-25 10:13:26.000000000 | | AQ | ATA | 010 | 1 | Antarctica | Antarctica | system.external_data_import | ores_prime_origin_refdata_service | 2026-06-25 10:13:26.000000000 | | AR | ARG | 032 | 1 | Argentina | Argentine Republic | system.external_data_import | ores_prime_origin_refdata_service | 2026-06-25 10:13:26.000000000 | | AS | ASM | 016 | 1 | American Samoa | American Samoa | system.external_data_import | ores_prime_origin_refdata_service | 2026-06-25 10:13:26.000000000 | | AT | AUT | 040 | 1 | Austria | Republic of Austria | system.external_data_import | ores_prime_origin_refdata_service | 2026-06-25 10:13:26.000000000 | | AU | AUS | 036 | 1 | Australia | Commonwealth of Australia | system.external_data_import | ores_prime_origin_refdata_service | 2026-06-25 10:13:26.000000000 |
List all as table (with explicit db args)
./ores.cli refdata countries list \ --db-user ores_prime_origin_cli_user \ --db-password "$ORES_CLI_DB_PASSWORD" \ --db-database ores_dev_prime_origin \ --tenant "$ORES_TENANT" \ --format table | head -n 15
List all as JSON (using .env)
set -a && source .env && set +a ./ores.cli refdata countries list \ --tenant "$ORES_TENANT" \ --format json | python3 -c "import sys,json; d=json.load(sys.stdin); print(json.dumps(d[:3], indent=2))"
List specific country
set -a && source .env && set +a ./ores.cli refdata countries list \ --tenant "$ORES_TENANT" \ --format json --key "GB"
[
{
"version": 1,
"tenant_id": "36d4c3c9-195c-46b5-a4d8-b36cb48c8f46",
"alpha2_code": "GB",
"alpha3_code": "GBR",
"numeric_code": "826",
"name": "United Kingdom",
"official_name": "United Kingdom of Great Britain and Northern Ireland",
"image_id": "0930c1d7-387b-4004-8380-7caa84a7f510",
"modified_by": "ores_prime_origin_refdata_service",
"change_reason_code": "system.external_data_import",
"change_commentary": "Imported from DQ dataset: ISO 3166 Country Codes",
"performed_by": "ores_prime_origin_refdata_service",
"recorded_at": "2026-06-25 10:13:26Z"
}
]