WP CLI cheatsheet

Returns sizes of all database tables in a human friendly format.

Run health check on the database set in the wp-config.php file. It reports status of each database table separately in the output.

Checks if WP-CLI is due for an update.

Return WP CLI version.

Creates config.php file. Requires mysql cli to be installed.

This command searches for all posts in the database and returns the count number.

Download latest version of WordPress core files to current directory.

Opens wp-config.php file in the default text editor.

Exports WXR file containing XML formatted data about your site including posts, comments and information about images and other attachments. Site option settings are excluded.

By combining the following flags you can export a single page from WordPress. First set the post type you want to export (page) then set the ID of the post, and finally limit the command to only fetch a single post. Skipping comments is optional.

This command will generate authentication unique keys and salts in your wp-config.php file.

List all defined image sizes, their width, height and the crop details.

Imports WXR files.

You can import WXR data files to specific site in the multi-site installation. The --url flag identifies the site you want to migrate data to. Skipping authors is optional.

Install a plugin in your WordPress site. By passing --activate flag you can enable your new plugin in one command.

This command is based on the "wp post list" used to return all posts but the "--post_type=page" flag changes the search scope to return only pages. By default the output if formatted as a table and includes page ID, title, slug, creation date, and the status.

Use post ID to return all related meta data. By default it returns data as a table but other formats are available, for example you can use this flag --format=json to get data as json.

Returns a table of custom posts with a type specified using the --post_type flag.

Lists all columns in a given database table. You will need to pass a table name as the argument. List of the default WordPress tables - wp_commentmeta, wp_comments, wp_links, wp_options, wp_postmeta, wp_posts, wp_term_relationships, wp_term_taxonomy, wp_termmeta, wp_terms, wp_usermeta, wp_users.

Lists all tables in the database connected to your site.

Returns a table of all post types including custom posts.

Returns a table of all posts including ID, title, name, date and status.

If you're running a multi-site WordPress installation you can return a handy table presenting blog ID, URL, and update dates of each site instance.

Returns a table of all registered taxonomies including categories, post tags, navigation menus, themes, custom taxonomies and more.

Puts your site in a maintenance mode and returns "Briefly unavailable for scheduled maintenance. Check back in a minute." message with a 503 server response.

Takes your site out of maintenance mode.

Returns maintenance mode status of your site.

Connects to the database set in your wp-config.php file using MySQL CLI.

Runs MySQL optimizer on the connected database.

Regenerate all thumbnail image sizes stored in the media library. The --yes flag confirms your choice.

This command will generate basic files and structure for a new plugin. Use --skip-tests flag to omit php unit tests in the process.

Generates un-styled main theme with all the necessary files and views to display content.

You can search for a string in connected WordPress database. The --stats flag will append details about the search like matches found and tables searched.

Updates all installed plugins.

Update WP-CLI to the latest version.

Prints information to the console about WP CLI and its environment such as version, OS, PHP, MySQL.