npx claudepluginhub salesforcecommercecloud/b2c-developer-tooling --plugin b2c-cliThis skill uses the workspace's default tool permissions.
Use `b2c cip` commands to query B2C Commerce Intelligence (CIP), also known as Commerce Cloud Analytics (CCAC).
Searches, retrieves, and installs Agent Skills from prompts.chat registry using MCP tools like search_skills and get_skill. Activates for finding skills, browsing catalogs, or extending Claude.
Searches prompts.chat for AI prompt templates by keyword or category, retrieves by ID with variable handling, and improves prompts via AI. Use for discovering or enhancing prompts.
Checks Next.js compilation errors using a running Turbopack dev server after code edits. Fixes actionable issues before reporting complete. Replaces `next build`.
Use b2c cip commands to query B2C Commerce Intelligence (CIP), also known as Commerce Cloud Analytics (CCAC).
Tip: If
b2cis not installed globally, usenpx @salesforce/b2c-cli.
cip
├── tables - list metadata catalog tables
├── describe <table> - describe table columns
├── query - raw SQL execution
└── report - curated report topic
├── sales-analytics
├── sales-summary
├── ocapi-requests
├── top-selling-products
├── product-co-purchase-analysis
├── promotion-discount-analysis
├── search-query-performance
├── payment-method-performance
├── customer-registration-trends
└── top-referrers
--client-id, --client-secret--tenant-id (or --tenant)Salesforce Commerce API role with tenant filter for your instanceOptional:
--cip-host (or SFCC_CIP_HOST) to override the default host--staging (or SFCC_CIP_STAGING) to force staging analytics host::: warning Availability
This feature is typically used with production analytics tenants (for example abcd_prd).
Starting with release 26.1, reports and dashboards data can also be enabled for non-production instances (ODS/dev/staging and designated test realms) using the Enable Reports & Dashboards Data Tracking feature switch.
Reports & Dashboards non-production URL: https://ccac.stg.analytics.commercecloud.salesforce.com
:::
b2c cip tables) or curated reports (b2c cip report --help).b2c cip describe <table> or report --describe to inspect structure/parameters.--sql to preview generated SQL.cip query when you need custom execution/output handling.# List warehouse tables
b2c cip tables --tenant-id abcd_prd --client-id <client-id> --client-secret <client-secret>
# Filter table names
b2c cip tables --tenant-id abcd_prd --pattern "ccdw_aggr_%" --client-id <client-id> --client-secret <client-secret>
# Describe table columns
b2c cip describe ccdw_aggr_ocapi_request --tenant-id abcd_prd --client-id <client-id> --client-secret <client-secret>
For an efficient table catalog grouped by aggregate/dimension/fact families, use:
references/KNOWN_TABLES.mdFor a general-purpose starter query pack with ready-to-run SQL patterns, use:
references/STARTER_QUERIES.mdThe list is derived from official JDBC documentation and intended as a quick discovery aid.
# Show report commands
b2c cip report --help
# Run a report
b2c cip report sales-analytics \
--site-id Sites-RefArch-Site \
--from 2025-01-01 \
--to 2025-01-31 \
--tenant-id abcd_prd \
--client-id <client-id> \
--client-secret <client-secret>
# Show report parameter contract
b2c cip report top-referrers --describe
# Print generated SQL and stop
b2c cip report top-referrers --site-id Sites-RefArch-Site --limit 25 --sql
# Force staging analytics host
b2c cip report top-referrers --site-id Sites-RefArch-Site --limit 25 --staging --sql
b2c cip report sales-analytics --site-id Sites-RefArch-Site --sql \
| b2c cip query --tenant-id abcd_prd --client-id <client-id> --client-secret <client-secret>
b2c cip query \
--tenant-id abcd_prd \
--client-id <client-id> \
--client-secret <client-secret> \
"SELECT * FROM ccdw_aggr_sales_summary LIMIT 10"
You can also use:
--file ./query.sqlcat query.sql | b2c cip query ...)b2c cip query supports placeholder replacement:
<FROM> with --from YYYY-MM-DD<TO> with --to YYYY-MM-DD--from defaults to first day of current month--to defaults to todayIf you provide --site-id, the common CIP format is Sites-{siteId}-Site. The command warns when siteId does not match that pattern but still runs with your input.
Both raw query and report commands support:
--format table (default)--format csv--format json--json (global JSON mode)The underlying JDBC analytics service has strict limits. Keep requests scoped:
SELECT * queriesLimits can change over time. Use the official JDBC access guide for current NFR limits:
tenant-id is required: set --tenant-id (or SFCC_TENANT_ID)--user-authFor full command reference, use b2c cip --help and CLI docs.