Ask Drush to list which modules have database updates available

Question

I specifically want Drush to list, of the modules that have available updates, which of those contain database updates. Is this possible with Drush?

Edit for clarification: I know drush up will list all modules that have available updates, yes, but not all of those updates will have database updates that go along with them. I strictly want a list of updates that have associated database updates.

Answer 1

drush updatedb --no (shorthand: drush up -n) will list them and take no further action.

Answer 2

This is a feature request; please post it in the drush issue queue. Note that this is not a terribly easy thing for Drush to do; it would have to download all of the projects to be updated and inspect them prior to prompting you.

Answer 3

"drush pm-update" will give you a list of modules that have updates available.

Answer 4

There is a drush command that will be better for you than drush updatedb --no, as it will not clear the cache (which could really affect performance on a production site):

drush8 --uri=www.example.com updatedb-status --format=json
[
    {
        "module": "Metatag",
        "update_id": 7104,
        "description": "Remove the entity revision ID from the translation strings. "
    },
    {
        "module": "Metatag",
        "update_id": 7105,
        "description": "Fix the output translation strings. "
    }
]

Documentation is at http://drushcommands.com/drush-8x/core/updatedb-status/