Introspect the SLAM MCP server: MCP protocol version, server version, SQLite version, database pathname, row counts per table, last sync timestamp, and store metadata. Use as the first call to verify the connection and detect version drift.

Returns sync metadata (last sync time, minutes since sync) and row counts for every entity table in the SLAM database.

Returns store information from the SLAM metadata table: shop domain, currency, timezone, and other store-level settings.

Returns the full database schema (tables + columns), logical relationships, TEMP view documentation with semantic descriptions and column type notes, and copy-paste SQL patterns for common cross-table queries. Call this before writing slam_run_query to understand the data model.

Browse and filter metafields (custom fields) across products, variants, customers, orders, and collections. Filter by owner type, namespace, key, a specific entity ID, or a substring of the value. Returns owner label (product title, customer email, or variant title) alongside each metafield.

Returns a paginated list of products with variant counts. Supports filtering by status, vendor, and product_type. Use the data_quality parameter to filter to products with content gaps (e.g. 'no_description' returns only products with empty body_html).

Returns a single product by ID, including all its variants, collection memberships, and metafields.

Searches products by title, vendor, product_type, or tags using LIKE matching. Returns paginated results with variant counts.

Returns the total count of products, optionally filtered by status, vendor, or product_type.

Returns product images from the product_media table. Supports filtering by product_id.

Returns a paginated list of variants. Optionally filter by product_id to see variants for a specific product.

Returns a single variant by ID, including parent product information, inventory items, and inventory levels.

Look up variants by exact SKU or barcode. Returns variant details plus parent product info. Provide sku, barcode, or both.

Returns product option names and values from the product_options table (option_values stored as JSON).

Returns inventory levels joined with variant info (SKU, title) and location name. Filterable by product_id, SKU, or location_id.

Returns aggregated inventory statistics: total SKUs tracked, total units, units by location, out-of-stock count, and low stock count.

Returns variants at or below a stock threshold — your reorder list. Uses multi-location inventory_levels aggregation via the variant_stock_health view. Sorted by lowest stock first.

Returns variants where total available stock is negative — meaning orders have exceeded inventory (overselling). Distinct from out-of-stock (zero stock). Sorted by most negative first.

Returns inventory stock totals aggregated by location (warehouse/store). Shows available, on_hand, reserved, and committed units per location.

Returns variants that have available inventory but no recorded sales (order_count = 0). Useful for identifying stock to clearance or discontinue. Sorted by highest stock first.

Returns a paginated list of collections with product counts. Filterable by collection_type ('smart' or 'custom').

Returns a single collection by ID, including all member products.

Returns all collections that contain the specified product.

Returns all products in a collection, each enriched with variant count and sales metrics (order_count, units_sold, total_revenue) from the product_sales view. Products with no sales show zeros.

Returns a paginated list of orders with customer name and line item count. Filterable by financial_status and fulfillment_status.

Returns a single order by ID, including line items, discount codes, and customer info.

Search orders by customer email or name fragment, date range, or status. Use for support workflows like 'find all orders from jane@example.com' or 'show unfulfilled orders from last week'.

List individual order line items. Filter by product, variant, or specific order. Useful for cross-order product queries like 'show all orders containing variant X' or 'which orders had this product?'

Returns discount code usage summary from order_discount_codes. Shows most-used codes, total discount amounts, and discount types.

Returns active discount codes from the discounts table (not order_discount_codes). Shows current live promotions.

Returns fulfillment records from the fulfillments table. Filter by order or status.

Returns refund records joined with refund line items. Shows refund amounts, reasons, and order context.

Returns return records from the returns table, joined with return line item counts.

Returns draft orders with line item counts. Draft orders are unpaid/pending orders not yet converted.

Returns a paginated list of customers with orders_count and total_spent. Optionally filter by tag.

Returns a single customer by ID, including recent orders (up to 10) and metafields.

Returns customer tag distribution from the customer_tags table. Shows which tags are most common and how many customers have each.

Search customers by email address or name fragment. Matches against email, first_name, and last_name using a case-insensitive substring search.

Returns customers ranked by total spend, order count, or average order value. Use min_orders to filter to repeat buyers only.

Returns customer addresses from the customer_addresses table.

Returns current variant prices. Use below_compare to show only variants where price < compare_at_price (on sale). Filterable by product_id.

Returns variants with discount analysis from the price_comparison view. By default shows only items on sale (compare_at_price > price), sorted by biggest discount first.

Runs content quality checks: products with empty descriptions, 'Copy of'/'Untitled' titles, or missing tags.

Runs pricing anomaly checks: zero-price variants, inverted compare_at_price, and compare_at_price equal to price.

Runs identifier completeness checks: empty SKUs, empty barcodes, and duplicate product titles.

Runs inventory status checks: out-of-stock variants, negative inventory, and untracked inventory items.

Runs order quality checks: orders with no line items, missing customer email, zero total price, and refunded-but-unfulfilled status.

Runs customer quality checks: missing email, duplicate emails, zero order count, and customers with orders but zero total spent.

Returns a store sales dashboard: total orders, total revenue, average order value, breakdown by financial and fulfillment status, and top 5 products by revenue. Optionally filter by financial_status.

Returns orders grouped by day, week, or month — a time-series view of sales performance. Each period includes order_count, total revenue, and average order value. Most recent periods first.

Returns products ranked by sales performance (revenue, units sold, or order count). Supports pagination, sort direction, and optional vendor/product_type filters. Uses the product_sales view which joins orders and line_items — only products with at least one order appear.

Returns product pairs ranked by co-purchase frequency — how often two products appear together in the same order. Use to discover bundle opportunities. Supply product_id to anchor on a specific product, or omit to see the top pairs across all orders.

Returns sales performance grouped by vendor — total revenue, units sold, order count, and product count per vendor. Sorted by revenue by default.

Returns all fulfilment locations with stock totals. Uses the inventory_by_location view.

Returns B2B companies with location and contact counts.

Returns pages and articles for content audit. Use content_type filter to restrict to 'page' or 'article'.

Returns outstanding gift card balance summary grouped by currency.

Returns subscription selling plan groups with plan and product counts.

Returns a one-call store health snapshot: sales totals, inventory counts, data condition issue counts, and sync freshness. Answers 'what is the state of my store right now?' without requiring multiple tool calls.

Executes a read-only SQL query against the SLAM database with validation, pagination, money column warnings, and fuzzy error suggestions. Only SELECT, PRAGMA, EXPLAIN, and WITH statements are allowed.