What can you do with this server?

The SLAM Commerce MCP server exposes a Shopify SQLite database (via SLAM Gadget) to AI tools, providing 60 read-only tools for comprehensive analysis of your Shopify store. Access is always read-only (PRAGMA query_only = 1). Meta & Diagnostics * Check server health, sync status, and store metadata (domain, currency, timezone, plan) * Explore the full database schema, table relationships, and SQL patterns * Query custom metafields across products, variants, customers, orders, and collections Products * List, search, filter, and count products by status, vendor, type, or tag * Retrieve a single product with variants, collections, and metafields * Browse product images Variants & Inventory * List and search variants by SKU, barcode, or product; explore product options * View inventory levels per variant per location, summaries, low-stock alerts, oversold (negative stock), and dead stock Collections * List/retrieve collections with product counts; find which collections a product belongs to; list products in a collection with sales metrics Orders * List, search, and filter orders; inspect line items; analyze discount code usage * Track fulfillments, refunds, returns, and draft orders Customers * List, search, and retrieve customers with spend/order history * Analyze customer tags, rank top customers by spend or order count, view addresses Pricing * View current prices, identify on-sale items, and analyze discount percentages and price distribution Data Quality Checks * Automated checks for content gaps, pricing anomalies, identifier completeness (SKUs, barcodes), inventory issues, and order/customer data integrity Reporting & Analytics * Sales dashboard (revenue, AOV, top products), time-series sales by day/week/month * Best-selling products, frequently co-purchased pairs, and vendor performance summaries Store-Level * Fulfillment locations, B2B companies, content pages, gift card balances, and selling plans * One-call store health snapshot (slam_store_snapshot) covering sales, inventory, data issues, and sync freshness Ad-hoc SQL * Execute any custom read-only SELECT query directly against the database (slam_run_query)

Which integrations are available for this server?

Exposes Shopify store data from a SQLite database, providing tools for managing products, variants, inventory, collections, orders, customers, pricing, conditions, reporting, and store-level operations through AI tools. Provides read-only access to a SQLite database containing Shopify store data, enabling query execution and data retrieval through specialized tools while maintaining security with query-only mode and SELECT validation.

How do I use SLAM Commerce MCP?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@SLAM Commerce MCP show me our top 5 customers by spend this month" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

de en es ja ko ru zh

SLAM Commerce MCP

by valljo888ai

Overview Schema Related Servers Score Discussions

Local

The SLAM Commerce MCP server exposes a Shopify SQLite database (via SLAM Gadget) to AI tools, providing 60 read-only tools for comprehensive analysis of your Shopify store. Access is always read-only (PRAGMA query_only = 1).

Meta & Diagnostics

Check server health, sync status, and store metadata (domain, currency, timezone, plan)
Explore the full database schema, table relationships, and SQL patterns
Query custom metafields across products, variants, customers, orders, and collections

Products

List, search, filter, and count products by status, vendor, type, or tag
Retrieve a single product with variants, collections, and metafields
Browse product images

Variants & Inventory

List and search variants by SKU, barcode, or product; explore product options
View inventory levels per variant per location, summaries, low-stock alerts, oversold (negative stock), and dead stock

Collections

List/retrieve collections with product counts; find which collections a product belongs to; list products in a collection with sales metrics

Orders

List, search, and filter orders; inspect line items; analyze discount code usage
Track fulfillments, refunds, returns, and draft orders

Customers

List, search, and retrieve customers with spend/order history
Analyze customer tags, rank top customers by spend or order count, view addresses

Pricing

View current prices, identify on-sale items, and analyze discount percentages and price distribution

Data Quality Checks

Automated checks for content gaps, pricing anomalies, identifier completeness (SKUs, barcodes), inventory issues, and order/customer data integrity

Reporting & Analytics

Sales dashboard (revenue, AOV, top products), time-series sales by day/week/month
Best-selling products, frequently co-purchased pairs, and vendor performance summaries

Store-Level

Fulfillment locations, B2B companies, content pages, gift card balances, and selling plans
One-call store health snapshot (slam_store_snapshot) covering sales, inventory, data issues, and sync freshness

Ad-hoc SQL

Execute any custom read-only SELECT query directly against the database (slam_run_query)

@slam-commerce/mcp

MCP server for SLAM Gadget — expose your Shopify SQLite database to AI tools.

Requirements

Node.js 20+
A SLAM Gadget .db file (schema version 3, downloaded from the Gadget dashboard)

Installation

Step 1 — Install globally (required for fast startup)

npm install -g @slam-commerce/mcp@2

Why global? Native modules like better-sqlite3 must compile once on your machine. Using npx causes a 10–30 second cold start on every session while npm reinstalls and recompiles. Global install runs that cost once.

On Windows, if the install fails with a node-gyp error, first run:

npm install -g node-gyp@latest
npm install -g @slam-commerce/mcp@2

Step 2 — Point to your database

The server resolves the database path using the first of these that matches:

Priority	Mechanism	Best for
1	`--db <path>` CLI argument	Project-level `.mcp.json` with relative paths
2	`SLAM_DB_PATH` environment variable	Shared/global client configs
3	Auto-discover `./slam/data/*.db`	Drop-in zero-config if your project follows the standard layout

Step 3 — Configure your MCP client

Claude Code — project .mcp.json (recommended, portable)

Place a .mcp.json in your project root. The --db path resolves relative to that directory:

{
  "mcpServers": {
    "slam": {
      "command": "slam-mcp",
      "args": ["--db", "./slam/data/your-store.db"]
    }
  }
}

Move or rename the project folder and it still works. If your project follows the standard SLAM Gadget layout (./slam/data/*.db), you can omit --db entirely and let auto-discovery find the file.

Claude Desktop — add to config:

{
  "mcpServers": {
    "slam": {
      "command": "slam-mcp",
      "args": ["--db", "/absolute/path/to/store.db"]
    }
  }
}

Config file locations:

macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
Windows: %APPDATA%\Claude\claude_desktop_config.json

Cursor — add to ~/.cursor/mcp.json:

{
  "mcpServers": {
    "slam": {
      "command": "slam-mcp",
      "args": ["--db", "/absolute/path/to/store.db"]
    }
  }
}

Claude Code / Cursor (env var alternative) — run once:

claude mcp add slam --scope user \
  -e "SLAM_DB_PATH=/absolute/path/to/store.db" \
  -- slam-mcp

Tools (60 total)

Meta (5 tools)

Tool	Description
`slam_health`	Server introspection: version, schema_version, freshness, row counts
`slam_meta_status`	Sync status and row counts per entity table
`slam_meta_store`	Store metadata (domain, currency, timezone, plan)
`slam_meta_schema`	Full schema reference with relationships and SQL patterns (call this first before `slam_run_query`)
`slam_metafields_query`	Query metafields by owner type and namespace

Products (5 tools)

Tool	Description
`slam_products_list`	List products with optional filters (status, vendor, product_type, tag)
`slam_products_get`	Get a single product by ID with variants, collections, metafields
`slam_products_search`	Full-text search products by title or description
`slam_products_count`	Count products matching filters
`slam_product_images`	List product images from the product_media table

Variants (4 tools)

Tool	Description
`slam_variants_list`	List variants with optional product filter
`slam_variants_get`	Get a single variant by ID
`slam_variants_search`	Search variants by SKU, title, or barcode
`slam_variant_options`	Product options and values from the product_options table

Inventory (6 tools)

Tool	Description
`slam_inventory_levels`	Inventory levels per variant per location (includes location_name)
`slam_inventory_summary`	Stock summary across all variants
`slam_inventory_alerts`	Variants at or below a stock threshold
`slam_inventory_oversold`	Variants with negative available stock
`slam_inventory_by_location`	Inventory totals per location with location name
`slam_dead_stock`	Zero-sales variants with available stock

Collections (4 tools)

Tool	Description
`slam_collections_list`	List collections with product count
`slam_collections_get`	Get a collection with its products
`slam_collections_for_product`	Collections that contain a specific product
`slam_products_for_collection`	Products within a specific collection

Orders (10 tools)

Tool	Description
`slam_orders_list`	List orders with optional status/date filters
`slam_orders_get`	Get a single order with line items and discount codes
`slam_orders_search`	Search orders by name, email, or note
`slam_order_line_items_list`	Line items for a specific order
`slam_discounts_summary`	Summary of discount codes used across orders
`slam_discounts_active`	Active discount campaigns from the discounts table
`slam_fulfillment_tracking`	Fulfillment status from the fulfillments table
`slam_refunds_summary`	Refunds and refund line items
`slam_returns_summary`	Returns by status and period
`slam_draft_orders_list`	Draft orders pipeline

Customers (6 tools)

Tool	Description
`slam_customers_list`	List customers with optional tag filter
`slam_customers_get`	Get a single customer by ID
`slam_customers_by_tag`	Tag frequency analysis from the customer_tags table
`slam_customers_search`	Search customers by email or name
`slam_customers_top`	Top customers by spend or order count
`slam_customer_addresses`	Customer address records

Prices (2 tools)

Tool	Description
`slam_prices_current`	Current prices with compare_at for sale detection
`slam_price_analysis`	Price distribution and discount analysis

Conditions (6 tools)

Tool	Description
`slam_conditions_content`	Content/tag conditions for product filtering
`slam_conditions_pricing`	Price-based conditions
`slam_conditions_identifiers`	ID/SKU/barcode lookups
`slam_conditions_inventory`	Inventory-based conditions
`slam_conditions_orders`	Order history conditions
`slam_conditions_customers`	Customer conditions

Reporting (5 tools)

Tool	Description
`slam_sales_summary`	Revenue, order count, AOV summary
`slam_sales_by_period`	Sales broken down by day/week/month
`slam_products_top`	Best-selling products by revenue or units
`slam_products_bought_together`	Frequently co-purchased products
`slam_vendors_summary`	Vendor performance summary

Store-level (5 tools)

Tool	Description
`slam_locations_list`	All fulfilment locations with stock summary
`slam_b2b_companies_list`	B2B company directory with contact count
`slam_content_pages`	Pages and articles for content auditing
`slam_gift_cards_summary`	Outstanding gift card balance by currency
`slam_selling_plans_list`	Subscription/selling plan groups

Snapshot (1 tool)

Tool	Description
`slam_store_snapshot`	One-call store health overview: sales totals, inventory counts, data condition issue counts, and sync freshness

Ad-hoc (1 tool)

Tool	Description
`slam_run_query`	Execute any read-only SELECT query against the database (call `slam_meta_schema` first to understand the schema)

Response envelope

Every tool response includes a _meta object:

{
  "_meta": {
    "domain": "products",
    "output_type": "list",
    "last_sync_at": "2024-01-15T08:30:00.000Z",
    "minutes_since_sync": 45,
    "freshness_tier": "stale",
    "returned": 25,
    "offset": 0,
    "has_more": true
  }
}

Freshness tiers

Tier	Condition	Meaning
`fresh`	< 15 min	Data is current
`stale`	15–59 min	Minor lag
`very_stale`	1–24 hours	Re-sync recommended
`outdated`	≥ 24 hours	Data is old — re-sync now

Schema version

This package targets Gadget schema version 3. On startup the server reads _slam_meta.schema_version and writes a warning to stderr if the version does not match. Re-download your .db file from the Gadget dashboard if you see this warning.

Known gaps vs V3

The following tools from @slam-commerce/mcp@1.x were removed because the Gadget database does not have change-tracking tables:

Removed tool	Reason
`slam_inventory_history`	Requires `inventory_snapshots` table — not present in Gadget
`slam_prices_history`	Requires `price_snapshots` table — not present in Gadget
`slam_changes_recent`	Requires `change_log` table — not present in Gadget
`slam_changes_for_entity`	Requires `change_log` table — not present in Gadget

Security

All database connections open with PRAGMA query_only = 1. The slam_run_query tool additionally validates that the statement is a SELECT and checks the referenced tables against a known-good allowlist before execution.

Install Server

license - permissive license

quality

maintenance

How are these scores calculated?

Maintenance

–Maintainers

–Response time

–Release cycle

–Releases (12mo)

Commit activity

Resources

Need Help?

Related Servers

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Tools

View all tools

Latest Blog Posts

Lightport: Open-Sourcing Glama's AI Gateway
By punkpeye on April 27, 2026.
open source
OpenAI
Tool Definition Quality Score (TDQS)
By punkpeye on April 3, 2026.
mcp
The Hackers Who Tracked My Sleep Cycle
By punkpeye on March 26, 2026.
security

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/valljo888ai/mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server