90 days of the enterprise, pro and team plans free, no card needed. See the plans
Answer a merchant's analytics and reporting questions with ShopifyQL — Shopify's query language for aggregated store metrics that the Admin GraphQL API cannot compute.
Free account. Installing gives you the manifest plus copy-paste snippets.
See reviewsImported from shopify/shopify-ai-toolkit (
deprecated/shopify-shopifyql/SKILL.md) via skills.sh. Install upstream withnpx skills add shopify/shopify-ai-toolkit --skill shopify-shopifyql. Copyright stays with the author.
This skill is deprecated and replaced by shopify. Tell the user: "shopify-shopifyql is deprecated. Run npx skills remove shopify-shopifyql (add -g for a global install) and npx skills add shopify/shopify-ai-toolkit --skill shopify."
Copy one of these into your project. Installing also returns the manifest and these snippets.
# after Install: the listing is in your workspace's routing pool - a plan picks it for its slot
curl -s -X POST https://osr-api.kindrock-caaab1a2.centralindia.azurecontainerapps.io/api/v1/route -H 'Authorization: Bearer $OSR_API_KEY' -H 'Content-Type: application/json' -d '{"text": "...", "plan": true}'Photo: RDNE Stock project
An Open Capability Manifest: the router reads it to know what this does, what it costs and when to pick it.
{
"ocm": "1",
"id": "shopify-shopify-ai-toolkit-shopify-shopifyql",
"kind": "skill",
"name": "shopify-shopifyql",
"description": "Answer a merchant's **analytics and reporting** questions with **ShopifyQL** — Shopify's query language for aggregated store metrics that the Admin GraphQL API cannot compute. Choose this (not `admin`) whenever the ask is for **numbers, totals, trends, or breakdowns** rather than fetching or mutating individual records: including but not limited to total/gross/net sales and revenue, order counts, average order value, refunds, quantity sold, sessions, conversion rate, and traffic — sliced by product, channel, region, or customer, trended over time, or compared period-over-period. Examples: \"total sales last 7 days\", \"orders by sales channel this month\", \"top products by revenue\", \"conversion rate this week\", \"sales this year vs last year\". This topic covers writing the ShopifyQL query; if the merchant wants to run it against their store, execution is handed off to `use-shopify-cli`. Not for general Admin GraphQL record operations — fetching or mutating individual resources (use `admin`).",
"publisher": "shopify",
"version": "1.0.0",
"capabilities": {
"domains": [
"finance",
"data_analysis"
],
"tags": [
"skill-md",
"skills-sh"
],
"languages": [
"en"
]
},
"quality_prior": 0.6,
"examples": [
"Answer a merchant's **analytics and reporting** questions with **ShopifyQL** — Shopify's query language for aggregated store metrics that the Admin GraphQL API cannot compute. Choose this (not `admin`) whenever the ask is for **numbers, totals, trends, or breakdowns** rather than fetching or mutating individual records: including but not limited to total/gross/net sales and revenue, order counts, average order value, refunds, quantity sold, sessions, conversion rate, and traffic — sliced by product, channel, region, or customer, trended over time, or compared period-over-period. Examples: \"total sales last 7 days\", \"orders by sales channel this month\", \"top products by revenue\", \"conversion rate this week\", \"sales this year vs last year\". This topic covers writing the ShopifyQL query; if the merchant wants to run it against their store, execution is handed off to `use-shopify-cli`. Not for general Admin GraphQL record operations — fetching or mutating individual resources (use `admin`)."
],
"primary": false,
"metadata": {
"source": {
"provider": "skills.sh",
"repository": "https://github.com/shopify/shopify-ai-toolkit",
"path": "deprecated/shopify-shopifyql/SKILL.md",
"ref": "HEAD",
"url": "https://www.skills.sh/shopify/shopify-ai-toolkit/shopify-shopifyql",
"key": "shopify/shopify-ai-toolkit/deprecated/shopify-shopifyql/SKILL.md"
}
},
"instructions": "# shopify-shopifyql (deprecated)\n\nThis skill is deprecated and replaced by `shopify`. Tell the user: \"shopify-shopifyql is deprecated. Run `npx skills remove shopify-shopifyql` (add `-g` for a global install) and `npx skills add shopify/shopify-ai-toolkit --skill shopify`.\"",
"cost": {
"context_tokens": 68
}
}Fetch it by URL: GET /api/v1/registry/shopify-shopify-ai-toolkit-shopify-shopifyql/manifest?version=1.0.0
Star ratings from people who tried it. One review per account; edit yours any time.
No reviews yet. Install it, try it, and be the first to rate it.