Title: vip dev-env sync sql
Published: July 7, 2026

---

 1. [VIP-CLI command reference](https://docs.wpvip.com/vip-cli/commands/)
 2. [vip dev-env](https://docs.wpvip.com/vip-cli/commands/dev-env/)
 3. [vip dev-env sync](https://docs.wpvip.com/vip-cli/commands/dev-env/sync/)
 4. vip dev-env sync sql

#  vip dev-env sync sql

Sync the database of a VIP Platform environment to a local environment.

## Usage

    ```wp-block-preformatted
    vip dev-env sync sql [options]
    ```

## Options

| Option | Description | 
|  `-a`, `--app` |  [value] Target an application. Accepts a string value for the application name or an integer for the application ID. |  
|  `-e`, `--env` |  [value] Target an environment. Accepts a string value for the environment type. |  
|  `-h`, `--help` |  Retrieve a description, examples, and available options for a (sub)command. (default: false) |  
|  `-v`, `--version` |  Retrieve the version number of VIP-CLI currently installed on the local machine. (default: false) |  
|  `-d`, `--debug` |  [value] Generate verbose output during command execution to help identify or fix errors or bugs. |  
|  `-s`, `--slug` |  [value] A unique name for a local environment. Default is “vip-local”. |  
|  `-t`, `--table` |  [value] The name of a table to include in the partial database sync. Accepts a string value and can be passed more than once with a different value, or add multiple values in a comma-separated list. –site-id [value] The ID of a network site to include in the partial database sync. Accepts an integer value (can be passed more than once with different values), or multiple integer values in a comma-separated list. |  
|  `-w`, `--wpcli-command` |  [value] Run a custom WP-CLI command that has logic to retrieve specific data for the partial database export. |  
|  `-c`, `--config-file` |  [value] A local configuration file that specifies the data to include in the partial database sync. Accepts a relative or absolute path to the file. |  
|  `-f`, `--force` |  [value] Skip validations. |

## Examples

    ```wp-block-preformatted
    - Sync the entire database of the develop environment in the "example-app" application to a local environment named "example-site".$ vip @example-app.develop dev-env sync sql --slug=example-site- Sync only the wp_posts and wp_comments tables from the database of the develop environment to a local environment named "example-site".$ vip @example-app.develop dev-env sync sql --slug=example-site --table=wp_posts --table=wp_comments- Use comma-separated syntax to specify that only the wp_posts and wp_comments tables are synced.$ vip @example-app.develop dev-env sync sql --slug=example-site --table=wp_posts,wp_comments- Sync only the tables related to network site ID 2 and network site ID 3.$ vip @example-app.develop dev-env sync sql --slug=example-site --site-id=2 --site-id=3- Use comma-separated syntax to specify that only the tables related to network site ID 2 and network site ID 3 are synced.$ vip @example-app.develop dev-env sync sql --slug=example-site --site-id=2,3- Reference a local configuration file that specifies the data to sync to a local environment.$ vip @example-app.develop dev-env sync sql --slug=example-site --config-file=~/dev-env-sync-config.json
    ```

Last updated: July 07, 2026