Get media url (featured image) with wp-cli

Assuming the attachment ID were in a variable of $attachment_id you could use the following command:

# get attachment URL
wp db query "SELECT guid FROM $(wp db tables *_posts) WHERE ID=\"$attachment_id\"" | head -n 2 | tail -1

I use the $(wp db tables *_posts) bit just in case the wp_ table prefix is non-default.

Related Posts:

  1. Detect if WP is running under WP-CLI
  2. WP CLI “Error establishing a database connection” in localhost (MAMP)
  3. How do I run a PHP script from WordPress environment, like `wp shell`?
  4. Using wp-cli can I not query pages by their title?
  5. wp-cli 0.14.1 MySQL error
  6. How to use wp-cli.yml file?
  7. WP cli –path does not seem to work
  8. Enable Auto-updates for all plugins using wp-cli? (since wordpress 5.5)
  9. How do I clone or duplicate a post with the WordPress Command Line Interface WP-CLI?
  10. How do I activate an mu-plugin with WP-CLI?
  11. How to create a WP-CLI command with $_POST?
  12. wp-cli doesn’t find and wordpress installation
  13. wp-cli import theme sample data
  14. WP-CLI works on non WP-CLI installed WordPress instance?
  15. What could cause WP-CLI search-replace to not replace all instances of a string?
  16. WPCLI – update plugins, themes, and core, all in one row, instead 3 rows?
  17. Using Travis CI to run unit tests and running phpunit locally [closed]
  18. “Could not open input file” error even when WP-CLI is in the path
  19. WP-CLI over SSH – wp command not found
  20. wp-cli create post and media import
  21. Import Media To CPT with CLI & Filter Custom Taxonomy
  22. wp-cli with MAMP shows sh: mysql: command not found
  23. PHP warning are displaying when using WP CLI [closed]
  24. WP CLI – show users whose ID is larger than given ID
  25. How can I replace all regex matches using the WP_CLI search-replace tool
  26. How do I update a nested option?
  27. Is it possible to use WP-CLI via PHP-framework?
  28. What tools respect `.distignore`?
  29. wp-cli silently fails with 255 when running wp core install
  30. WP-CLI Get Site ID from its url
  31. WP-CLI alias: connect with ssh proxy
  32. wp-cli: run post generate and post meta add together
  33. Setting boolean and array values using wp theme mod set
  34. How can I get the WP-CLI eval-file command to report errors to stderr?
  35. WP CLI: there has been critical error
  36. In a continuous integration environment how do you implement the database entries for plugins and themes
  37. wp-cli: wp term generate xxxxx – Error: ‘xxxxx’ is not a registered taxonomy
  38. MAMP PRO WP-CLI Error: Error establishing a database connection
  39. “Class ‘Phar’ not found” error setting up WP-CLI with Cygwin
  40. Running WP-CLI without SSH
  41. WP CLI Shell not working on Windows
  42. How do you kill WP-CLI execution?
  43. Is it possible to delete a range of posts by ID with WP-CLI?
  44. How to specify to wp-cli for the `wp config create` (`wp core config`) command that the DB user is an ‘all hosts’ user?
  45. Formatting messed up when piping wp commands
  46. wpcli: Error on post_content or post_title if accents
  47. wp-cli configuration in php?
  48. Lock User and Enforce Password change via wp-cli
  49. BackupBuddy WP CLI Invalid Profile Error
  50. How to find what pages/posts contain a particular reusable block?
  51. WP CLI not outputting anything
  52. WP-CLI search-replace posts content for certain URLs
  53. Bulk remove custom post type and its attachments with wp-cli?
  54. WP-CLI can not find Url
  55. Running custom defined WP-CLI commands without WordPress installation present
  56. Update BackupBuddy with WP-CLI
  57. Wrong output order when mixing WP_CLI::API and php-cli-tools
  58. WP-CLI not working from Bash script
  59. MySQL 5.6 Causes Errors with WP CLI
  60. Using WP-CLI, how do I delete a post by title or slug, not ID?
  61. wp-cli only displays PHP version for all input options
  62. WP CLI: search and replace specific directory name of URL
  63. WP-CLI plugin install causes PHP fatal error – Using $this when not in object context
  64. How to delete a single post using wp cli in command line?
  65. Adding content from file with wp post create
  66. How to run wp cli from a wp hook?
  67. wp-cli PHP Notice after moving server behind load balancer
  68. What is the purpose of the “user” global parameter in wp-cli.yml config?
  69. Userless db-only wordpress instalation
  70. One-click WP site generation wih wp-cli on Windows
  71. PHPUnit via WP-CLI: Warning: Cannot modify header information … bootstrap.php:68
  72. Add passwords to config.yml to manage multiple sites
  73. WP-CLI mysteriously stopping while downloading the core [closed]
  74. WP-CLI: Does “wp post create” will create post normally and will ping to Ping Service?
  75. Trying to install/configure wp-cli for WordPress
  76. Logs for WP CLI
  77. WP-Cli Autoloads Non-existant Framework
  78. Mocking WP_CLI static methods in unit tests
  79. Give WP-Cli User Home Directory Privileges
  80. How to add an array to a command “wp config set”?
  81. WP-CLI: detect altered core files and restore them automatically
  82. wp-cli core install unknown: fatal: file /etc/postfix/main.cf: parameter mail_owner: user postfix has same user ID as _postfix
  83. How to specify which editor is used when editing posts with WP-CLI?
  84. bash script wp-cli search-replace 0 replacements, but command-line 3000+
  85. WP changes siteurl, but some URLs then don’t work
  86. Is WP-CLI safe to use in a hosting environment? Why?
  87. Install plugin on remote wordpress
  88. WP-CLI is unable to update password
  89. Make WordPress more like Jekyll (using wp-cli package?)
  90. Is it possible to use WP CLI to update a theme that is not in the WordPress Repo?
  91. Can I use WP-CLI from a remote computer?
  92. Install WordPress using PHP
  93. How to install WordPress with Composer?
  94. wp-cli output ‘column display format’ / wrapping
  95. When might you need to specify the “url” argument/option in WP-CLI?
  96. wp-cli incorrectly believes a plugin is currently installed
  97. WordPress CLI isn’t working while use WordPress development repository
  98. Using wp-cli on remote with quoted commands
  99. is it possible to use wp cli to export custom post types
  100. ‘wp’ is not recognized as an internal or external command, operable program or batch file