When you connect to your live or staging site via SSH or the web terminal, you can enjoy WP-CLI there.

Examples

Here are some examples for your inspiration, full reference here.

Check database size

wp db size --tables

List wp-config.php values

wp config get

Update plugins

wp plugin update --all

Search & replace

wp search-replace oldstring newstring

Reset password

If you've lost your admin password:

wp user update you@example.com --user_pass=new-secure-password

Export / import database

See also importing database.

wp db export

wp db import db_dump.sql