OpenCart MCP Server
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@OpenCart MCP Server Which products are low on stock?"
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.
OpenCart MCP Server
Query and edit your OpenCart store from Claude Code. Products, orders, customers, Journal3 modules, SEO URLs, CMS pages — 42 tools, all through natural language.
Built for store owners and developers who are tired of SSH + phpMyAdmin + admin panel clicking to get simple answers.
"Which products are low on stock?"
"Update the meta description for category 25"
"Show me today's orders over £50"
"Find the Journal3 module that contains our FAQ text and fix the typo"It just works. You ask, Claude calls the right tool, you get the answer.
💻 Prefer the terminal? Check out opencart-cli — same OpenCart understanding, pretty tables, sparklines, AI in the shell (
opencart ask "..."), interactive REPL, live order watching.pip install opencart-cli.
Safe by default
This matters if you're connecting AI to a live store. Every decision here was made with that in mind.
Read-only queries —
query()only allows SELECT, SHOW, DESCRIBE, EXPLAINDDL is blocked — DROP, ALTER, TRUNCATE, CREATE will never run, even through
run_sql()SSH tunnel — database credentials stay inside the encrypted connection, never exposed
Path traversal blocked —
get_file()andwrite_file()reject..in pathsAccess policy — optional
OPENCART_MCP_POLICY(safe/manager/developer/all) hides write tools by role; defaultallkeeps previous behavior. Levels belowallalso apply best-effort secret guardrails (blockconfig.php/ admin user tables, redact password-like settings)Write confirmation — Claude Code prompts you before any write tool executes
Nothing runs on your server — no agents, no daemons, no PHP files uploaded. The server runs on your machine and connects over SSH
You can point this at a production store and not worry about it doing something stupid. For day-to-day agent use on production data, prefer OPENCART_MCP_POLICY=safe or developer (writes allowed for module work, secrets still filtered) over all.
Related MCP server: AdminAgent
What can you actually do with it?
Store owners
"How many orders came in this week?" → instant sales summary with daily breakdown
"What's running low?" → stock report sorted by quantity, lowest first
"Update the price of product 47 to 29.99" → done, one confirmation click
"Show me the About Us page content" → full CMS page, ready to review or edit
Developers
"Show me the schema for oc_order" → column definitions without opening phpMyAdmin
"List all OCMOD modifications and their status" → instant audit
"What extensions are installed?" → full list, no admin panel needed
"Run this SELECT against the orders table" → custom SQL with safety rails
Agencies managing multiple stores
Run dev and live as separate MCP instances in the same Claude session
opencart_dev__get_productsvsopencart_live__get_products— no confusionCompare stock levels, settings, or module content across environments
Journal3 users
List, inspect, and edit J3 modules — FAQ accordions, sliders, banners, product tabs
Read and update theme settings and skin settings per skin
Find/replace inside module JSON — safely change text without rewriting the entire module
J3 tools return empty results (not errors) if Journal3 isn't installed, so the server works with any theme
How it compares
Task | Admin panel | SSH + SQL | This MCP server |
Check stock levels | Click through pages | Write a query, run it | "What's low on stock?" |
Update a product price | Find product, edit, save | UPDATE query by hand | "Set product 47 to £29.99" |
Read a J3 module | JSON blob in the database | Copy-paste from phpMyAdmin | "Show me module 505" |
Edit FAQ text | Find module, decode JSON, edit, re-encode | Pain | "Replace X with Y in module 505" |
Sales report | Reports page, manually filter | Write aggregation queries | "Sales summary for the last 7 days" |
Check SEO URLs | Admin > Marketing > SEO URL, paginate | SELECT from oc_seo_url | "Show SEO URLs containing 'headphones'" |
Manage CMS pages | Admin > Catalog > Information | Direct DB access | "Show me the About Us page" |
Quick start
1. Install
git clone https://github.com/chrisbray85/opencart-mcp.git
cd opencart-mcp
python3 -m venv .venv && source .venv/bin/activate
pip install -e .Run it directly, no clone:
nix run github:chrisbray85/opencart-mcpInstall via a flake input (NixOS / home-manager) — adds the opencart-mcp
binary to PATH:
{
inputs.opencart-mcp.url = "github:chrisbray85/opencart-mcp";
# then, in your NixOS configuration (configuration.nix / a module):
environment.systemPackages = [
inputs.opencart-mcp.packages.${pkgs.system}.default
];
# …or home-manager:
home.packages = [
inputs.opencart-mcp.packages.${pkgs.system}.default
];
}Dev shell with all deps (skip the venv steps above):
nix develop2. Configure
cp .env.example .envFill in your server details:
OPENCART_SSH_HOST=your-server-ip
OPENCART_SSH_USER=your-ssh-username
OPENCART_SSH_KEY=~/.ssh/id_ed25519
OPENCART_DB_USER=your_db_user
OPENCART_DB_PASS=your_db_password
OPENCART_DB_NAME=your_opencart_database
OPENCART_ROOT=/path/to/opencart
OPENCART_STORAGE=/path/to/storageWhere to find your paths:
OPENCART_ROOT— the directory containingindex.php,admin/,catalog/,system/
OPENCART_STORAGE— check yourconfig.phpfor theDIR_STORAGEvalue (often outside the web root on OpenCart 3.0.3.3+)
Optional extras:
OPENCART_SSH_PORT=22 # if SSH runs on a non-standard port
OPENCART_DB_HOST=localhost # if MySQL isn't on the same host (e.g. a tunnel)
OPENCART_DB_PREFIX=oc_ # table prefix override
OPENCART_LANGUAGE_ID=1 # skip auto-detect from config_language
# OPENCART_MCP_POLICY=all # safe | manager | developer | all (default: all)OPENCART_MCP_POLICY controls which tools are registered:
Value | Tools | Secret guardrails |
| Read-only tools | yes |
| + catalog/order/settings/coupon writes | yes |
| + | yes |
| Everything | no (previous behavior) |
Guardrails (when policy is not all) block paths like config.php / .env, queries against admin user/session tables, and redact password-like keys in get_settings. This is best-effort, not a hard security boundary.
Any OPENCART_DB_* value you leave unset is read from the install's config.php automatically, so on most setups the main block above is all you need.
The storefront language is auto-detected from the store's config_language setting, so multi-language and non-English stores work without configuration — set OPENCART_LANGUAGE_ID only to force a specific one.
No SSH? Direct MySQL mode
If your host allows remote MySQL connections (or you run your own tunnel), leave OPENCART_SSH_HOST empty and set the OPENCART_DB_* values instead:
OPENCART_SSH_HOST=
OPENCART_DB_HOST=your-mysql-host
OPENCART_DB_PORT=3306
OPENCART_DB_USER=your_db_user
OPENCART_DB_PASS=your_db_password
OPENCART_DB_NAME=your_opencart_database
OPENCART_DB_PREFIX=oc_All SQL-backed tools work identically. File and cache tools (get_file, write_file, clear_cache, refresh_modifications) refuse to run in this mode — there's no shell to run them on, and they must never touch a local copy of the store thinking it's production. SSH remains the recommended transport: credentials stay inside the encrypted connection.
Using DDEV for local development?
Set OPENCART_SSH_HOST=ddev and point OPENCART_ROOT at the local project directory — commands will run via ddev exec inside your container instead of SSH:
OPENCART_SSH_HOST=ddev
OPENCART_DB_USER=db
OPENCART_DB_PASS=db
OPENCART_DB_NAME=db
OPENCART_ROOT=/Users/you/Sites/your-opencart-projectContainer paths (/var/www/html etc.) are auto-resolved — you only need the local project path. (DDEV support contributed by @IceDBorn — thanks!)
3. Test the connection
source .venv/bin/activate
PYTHONPATH=src python -c "
from opencart_mcp.config import Config
from opencart_mcp.db import OpenCartDB
import json
config = Config.from_env()
db = OpenCartDB(config)
result = db.run_query('SELECT COUNT(*) as product_count FROM oc_product WHERE status = 1')
print(json.dumps(result, indent=2))
db.close()
"You should see something like [{"product_count": "42"}]. If not, check Troubleshooting.
4. Add to Claude Code
Open your VS Code settings JSON (Cmd+Shift+P → "Open User Settings (JSON)") and add:
{
"claude.mcpServers": {
"opencart": {
"command": "/absolute/path/to/opencart-mcp/.venv/bin/python",
"args": ["-m", "opencart_mcp.server"],
"cwd": "/absolute/path/to/opencart-mcp",
"env": {
"PYTHONPATH": "/absolute/path/to/opencart-mcp/src",
"OPENCART_SSH_HOST": "your-server-ip",
"OPENCART_SSH_USER": "your-ssh-username",
"OPENCART_SSH_KEY": "~/.ssh/id_ed25519",
"OPENCART_DB_USER": "your_db_user",
"OPENCART_DB_PASS": "your_db_password",
"OPENCART_DB_NAME": "your_opencart_database",
"OPENCART_ROOT": "/path/to/opencart",
"OPENCART_STORAGE": "/path/to/storage"
}
}
}
}Restart VS Code and the tools will appear in the Claude Code panel.
Add to ~/.claude.json (global) or .claude/settings.json (project-level):
{
"mcpServers": {
"opencart": {
"command": "/absolute/path/to/opencart-mcp/.venv/bin/python",
"args": ["-m", "opencart_mcp.server"],
"cwd": "/absolute/path/to/opencart-mcp",
"env": {
"PYTHONPATH": "/absolute/path/to/opencart-mcp/src",
"OPENCART_SSH_HOST": "your-server-ip",
"OPENCART_SSH_USER": "your-ssh-username",
"OPENCART_SSH_KEY": "~/.ssh/id_ed25519",
"OPENCART_DB_USER": "your_db_user",
"OPENCART_DB_PASS": "your_db_password",
"OPENCART_DB_NAME": "your_opencart_database",
"OPENCART_ROOT": "/path/to/opencart",
"OPENCART_STORAGE": "/path/to/storage"
}
}
}
}Restart Claude Code and the tools load automatically.
JetBrains uses the same ~/.claude.json configuration as the CLI. Follow the CLI instructions above and restart your IDE.
Example prompts
These all work out of the box. Just type them into Claude Code.
Products & stock
"Show me all products with less than 5 in stock"
"Get full details for product 123 including options and images"
"Search for products with 'wireless' in the name"
"Update the price of product 47 to 34.99"Orders & customers
"Show me today's orders"
"Get order 5892 with line items and status history"
"Find customer john@example.com — how many orders have they placed?"
"Sales summary for the last 7 days with top sellers"SEO & content
"List all SEO URLs containing 'sale'"
"Update the SEO URL for product 23 to 'wireless-mouse-pro'"
"Show me the FAQ page content"
"Replace 'old company name' with 'new company name' in the About Us page"Journal3 theme
"List all Journal3 FAQ modules"
"Show me the full content of module 505"
"Replace 'Free shipping over £50' with 'Free shipping over £75' in the banner module"
"What skin settings are configured for skin 1?"Technical
"Show the schema for oc_order_product"
"List all tables matching 'journal3'"
"Run: SELECT order_id, total FROM oc_order WHERE total > 100 ORDER BY date_added DESC LIMIT 10"
"What OCMOD modifications are active?"All 42 tools
Read (27)
Tool | What it does |
| Search products with stock, prices, SEO data. Filter by category |
| Full product details — images, options, categories, attributes |
| Recent orders filtered by status and date range |
| Full order with line items, totals, status history |
| Search by name/email with order count and total spent |
| Category tree with product counts and SEO URLs |
| All products sorted by stock level (lowest first) |
| OpenCart core settings by group/key |
| Journal3 theme settings |
| Journal3 skin/layout settings per skin |
| Journal3 modules by type — search content within modules |
| Full module JSON data for any J3 module |
| List CMS pages (About Us, FAQ, T&Cs) with content preview |
| Full HTML content of a single CMS/information page |
| All order status mappings with IDs |
| Product attributes (weight, storage conditions, etc.) |
| Revenue, top sellers, daily stats for any period |
| OCMOD modifications with status |
| Installed extensions list |
| SEO URL mappings with filtering |
| Custom read-only SQL (SELECT/SHOW/DESCRIBE/EXPLAIN only) |
| Column definitions for any table |
| List tables matching a pattern |
| Read files from the server ( |
| List discount coupons with usage counts |
| List gift vouchers |
| One-call store overview — revenue, order statuses, stock alerts, latest orders |
Write (15)
Tool | What it does |
| Update price, stock, name, SEO title, meta description |
| Change OpenCart core settings |
| Change Journal3 theme settings |
| Change Journal3 skin settings |
| Find/replace text within J3 module JSON (banners, FAQ, sliders) |
| Find/replace text within CMS page HTML (About Us, T&Cs, etc.) |
| Create or update SEO URL mappings |
| Update category name, meta, status |
| Write files to server via SFTP |
| Execute INSERT/UPDATE/DELETE (DDL blocked) |
| Flush OpenCart + Journal3 caches |
| Clear OCMOD modification cache |
| Change order status + append order history |
| Create a discount coupon (percentage or fixed) |
| Enable/disable, extend, or edit a coupon |
How it works
Your machine Your server
┌──────────────┐ ┌──────────────┐
│ Claude Code │ │ │
│ ↓ │ SSH tunnel │ PHP cli │
│ MCP Server │ ──────────────────→ │ ↓ │
│ (Python) │ PHP via stdin │ MySQL │
│ │ ←────────────────── │ (JSON) │
└──────────────┘ └──────────────┘The server runs on your machine. It connects to your OpenCart server via SSH, pipes PHP to the remote interpreter via stdin, and gets JSON back. Nothing is installed on your server. No files uploaded, no cleanup, no ports opened.
PHP via stdin — works with any PHP version, nothing written to disk
SSH tunnel — credentials never leave the encrypted connection
Paramiko — pure Python SSH, no system dependencies beyond Python 3.10+
Direct MySQL —
pymysqlfallback for hosts without SSH (file/cache tools disabled)
Multiple stores
Run dev and live as separate instances in the same Claude session:
{
"mcpServers": {
"opencart_dev": {
"command": "/path/to/opencart-mcp/.venv/bin/python",
"args": ["-m", "opencart_mcp.server"],
"cwd": "/path/to/opencart-mcp",
"env": { "OPENCART_DB_NAME": "my_dev_database", "..." }
},
"opencart_live": {
"command": "/path/to/opencart-mcp/.venv/bin/python",
"args": ["-m", "opencart_mcp.server"],
"cwd": "/path/to/opencart-mcp",
"env": { "OPENCART_DB_NAME": "my_live_database", "..." }
}
}
}Claude prefixes tools automatically — opencart_dev__get_products vs opencart_live__get_products — so there's no confusion about which store you're querying.
You can also run the same store twice with different policies (e.g. daily safe plus an occasional developer entry) by duplicating the block and setting OPENCART_MCP_POLICY per instance.
Tested with
Component | Versions |
OpenCart | 3.0.3.2 — 3.0.5.0 (any 3.x should work) |
PHP | 5.6+ (server-side) |
Python | 3.10+ (local machine) |
Journal3 | 3.x (optional — everything works without it) |
OpenCart forks | ocStore / LiveStore 3.x (SQL-compatible; for Technics-theme tools see the livestore-mcp fork) |
Hosting | VPS, dedicated servers, shared hosting with SSH or remote MySQL |
Clients | Claude Code CLI, VS Code extension, JetBrains extension |
Used daily on production stores with 100+ products, thousands of orders, and Journal3 theme.
Troubleshooting
SSH connection fails
# Test SSH works
ssh your-user@your-server "echo ok"
# Test PHP is available
ssh your-user@your-server "echo '<?php echo 1;' | php"If SSH needs a password instead of a key:
ssh-copy-id -i ~/.ssh/id_ed25519.pub your-user@your-serverEmpty results
Run the test script to check credentials
OPENCART_ROOTshould point to the directory containingindex.phpOPENCART_STORAGEshould matchDIR_STORAGEin yourconfig.php
cPanel / shared hosting
cPanel prints tput: No value for $TERM warnings over SSH. The server filters these automatically.
Slow queries
Default timeout is 30 seconds. If queries are slow, check if SSH goes through a VPN (adds latency) or if the server is under load.
Journal3 tables not found
Normal if you're not running Journal3. The J3 tools return empty results instead of errors.
Common path issues
Hosting | Typical OPENCART_ROOT | Typical OPENCART_STORAGE |
cPanel |
|
|
Plesk |
| Above web root |
Custom VPS |
| Varies |
Check your config.php — both DIR_APPLICATION and DIR_STORAGE are defined there.
Roadmap
OpenCart 4.x support
Direct MySQL transport + language auto-detection (v0.7.0)
Coupon and voucher management tools (v0.6.0)
Order status update tool (v0.6.0)
Bulk product import/export
Customer group management
Dashboard summary tool (one prompt, full store overview) (v0.6.0)
Got a feature request? Open an issue.
Changelog
See releases for full history.
0.7.0
Direct MySQL transport (pymysql) when
OPENCART_SSH_HOSTis empty — file/cache tools refuse in this modeStorefront
language_idauto-detected fromconfig_language(override withOPENCART_LANGUAGE_ID) — fixes hardcodedlanguage_id = 1on non-English storesRevenue queries now also exclude canceled-reversal, chargeback, and voided orders
First unit tests (
tests/test_config.py)
Contributing
Issues and PRs welcome. If you're running this on a hosting setup or OpenCart version not listed above, let us know what works and what doesn't.
Thanks to the contributors so far:
@IceDBorn — DDEV support and the Nix flake
@ClayRabbit — configurable SSH port and full
config.phpDB fallback@Penikov — direct MySQL transport and language auto-detection; maintains the livestore-mcp fork for LiveStore + Technics stores
Support
Built and maintained in evenings. If it saves you time on a store, a coffee helps keep the tools coming:
License
MIT — see LICENSE for details.
Available Tools
42 toolsclear_cacheClear CacheA
Clear OpenCart and Journal3 caches on VPS. Requires SSH or DDEV.
Inputs: no named parameters. Returns: result
create_couponCreate CouponC
Create a discount coupon, enabled and valid from today. type: 'P' = percentage, 'F' = fixed amount. uses_total=0 = unlimited total uses; uses_per_customer=0 = unlimited per customer.
Inputs: code (required), name (required), discount (required), type, +6 more. Returns: result
dashboardDashboardA
One-call store overview: revenue today / 7 days / 30 days, order status breakdown, stock alerts, and the latest orders. The 'give me a store summary' tool. Excludes cancelled/failed/refunded orders from revenue.
Inputs: low_stock_threshold. Returns: result
get_categoriesGet CategoriesB
Get category tree. Set parent_id=0 for top-level categories.
Inputs: parent_id. Returns: result
get_couponsGet CouponsA
List discount coupons with usage counts. Search by code or name. Default: enabled, unexpired coupons only.
Inputs: limit, search, include_disabled. Returns: result
get_customersGet CustomersC
Search customers by name or email.
Inputs: limit, search. Returns: result
get_extensionsGet ExtensionsB
List installed OpenCart extensions.
Inputs: no named parameters. Returns: result
get_fileGet FileA
Read a file from the VPS. Path is relative to OpenCart root unless absolute.
By default returns the first max_lines lines (head). Set from_end=True for the last max_lines (tail) — preferred for large logs such as error.log. Optional grep is a fixed substring filter (not a regex). With from_end=True, grep only searches the last ~50k lines so huge logs stay fast; with from_end=False, grep scans the whole file then takes the first max_lines matches (can be slow on very large files). max_lines is capped at 2000. Requires SSH or DDEV.
Inputs: path (required), grep, from_end, max_lines. Returns: result
get_information_pageGet Information PageC
Get full content of a single information/CMS page by ID.
Inputs: information_id (required). Returns: result
get_information_pagesGet Information PagesA
List CMS/information pages (About Us, FAQ, T&Cs, etc.) with title and content preview. Search by title text.
Inputs: search. Returns: result
get_j3_moduleGet J3 ModuleA
Get full Journal3 module data for a single module by ID. Returns full JSON config — can be large for complex modules.
Inputs: module_id (required). Returns: result
get_j3_settingsGet J3 SettingsA
Get Journal3 theme settings. Filter by setting_name pattern (SQL LIKE).
Inputs: pattern. Returns: result
get_j3_skin_settingsGet J3 Skin SettingsB
Get Journal3 skin settings. Filter by setting_name pattern (SQL LIKE).
Inputs: pattern, skin_id. Returns: result
get_modificationsGet ModificationsB
List all OCMOD modifications with status.
Inputs: no named parameters. Returns: result
get_modulesGet ModulesA
List Journal3 modules. Filter by type (e.g. 'products', 'slider', 'product_tabs'). Search module_data content with search parameter.
Inputs: search, module_type. Returns: result
get_orderGet OrderC
Get full order details including line items and totals.
Inputs: order_id (required). Returns: result
get_ordersGet OrdersA
Get recent orders. Filter by status name (e.g. 'Complete', 'Pending'). Default: last 30 days, 20 orders.
Inputs: days, limit, status. Returns: result
get_order_statusesGet Order StatusesA
List all order statuses with their IDs.
Inputs: no named parameters. Returns: result
get_productGet ProductC
Get full details for a single product including images, options, and attributes.
Inputs: product_id (required). Returns: result
get_product_attributesGet Product AttributesB
Get all attributes for a product (e.g. CAS number, molecular weight, storage).
Inputs: product_id (required). Returns: result
get_productsGet ProductsA
List products with stock, prices, and SEO data. Search by name. Optionally filter by category_id. Set include_description=True to include full HTML descriptions.
Inputs: limit, search, category_id, include_description. Returns: result
get_seo_urlsGet Seo UrlsC
Get SEO URL mappings. Filter by query pattern (e.g. 'product_id=%').
Inputs: query_pattern. Returns: result
get_settingsGet SettingsB
Get OpenCart settings. Filter by group (e.g. 'config') and/or key pattern (SQL LIKE).
Inputs: key, group. Returns: result
get_stock_reportGet Stock ReportB
Get stock levels for active products, sorted by quantity (lowest first).
Inputs: limit. Returns: result
get_table_schemaGet Table SchemaA
Show columns for an OpenCart table. The install's prefix (e.g. 'oc_') is added automatically if missing.
Inputs: table (required). Returns: result
get_vouchersGet VouchersB
List gift vouchers with amount, sender/recipient, and status.
Inputs: limit. Returns: result
list_tablesList TablesB
List database tables matching pattern. Default: all OpenCart tables (using detected prefix).
Inputs: pattern. Returns: result
queryQueryA
Execute a read-only SQL query. Only SELECT statements allowed. Use this for custom queries not covered by other tools.
Inputs: sql (required). Returns: result
refresh_modificationsRefresh ModificationsA
Clear the OCMOD modification cache so OpenCart serves unmodified files. Run Admin > Extensions > Modifications > Refresh afterwards for the full recompile — this tool cannot do that step.
Inputs: no named parameters. Returns: result
run_sqlRun SqlB
Execute a write SQL statement (INSERT/UPDATE/DELETE). Use with caution — changes the database directly.
Inputs: sql (required). Returns: result
sales_summarySales SummaryB
Get sales summary: total revenue, order count, top selling products. Covers the last N days. Excludes cancelled/failed/refunded orders.
Inputs: days, top_n. Returns: result
update_categoryUpdate CategoryC
Update category fields. Only specified fields are changed.
Inputs: category_id (required), name, status, meta_title, +1 more. Returns: result
update_couponUpdate CouponA
Update a coupon: enable/disable (status 1/0), change discount, extend date_end (YYYY-MM-DD), adjust total-use limit, or rename. Only specified fields are changed.
Inputs: coupon_id (required), name, status, date_end, +2 more. Returns: result
update_informationUpdate InformationB
Update text within an information/CMS page using find/replace. Works on the HTML description field. Use get_information_page first to see current content.
Inputs: find (required), replace (required), information_id (required). Returns: result
update_j3_moduleUpdate J3 ModuleA
Update text within a Journal3 module's JSON data using find/replace. Safer than rewriting the entire module — only changes the matched text. Use get_j3_module first to see the current content.
Inputs: find (required), replace (required), module_id (required). Returns: result
update_j3_settingUpdate J3 SettingC
Update a Journal3 theme setting.
Inputs: setting_name (required), setting_value (required). Returns: result
update_j3_skin_settingUpdate J3 Skin SettingD
Update a Journal3 skin setting.
Inputs: setting_name (required), setting_value (required), skin_id. Returns: result
update_order_statusUpdate Order StatusA
Change an order's status and append an order-history entry — the same thing the admin status dropdown does. notify=True marks the history row as customer-notified but does NOT send the email itself. Use get_order_statuses to look up status IDs.
Inputs: order_id (required), order_status_id (required), notify, comment. Returns: result
update_productUpdate ProductB
Update product fields. Only specified fields are changed.
Inputs: product_id (required), name, price, status, +3 more. Returns: result
update_seo_urlUpdate Seo UrlB
Update or create an SEO URL mapping. Query is e.g. 'product_id=123' or 'category_id=45'. Keyword is the URL slug (e.g. 'bpc-157-5mg').
Inputs: query (required), keyword (required). Returns: result
update_settingUpdate SettingC
Update an OpenCart setting.
Inputs: key (required), group (required), value (required). Returns: result
write_fileWrite FileA
Write content to a file on the VPS via SFTP. Path is relative to OpenCart root unless absolute. Creates parent directories if needed. Use with caution. Requires SSH or DDEV.
Inputs: path (required), content (required). Returns: result
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 42 tools
Most tools target distinct resources (products, orders, coupons, settings) with clear read/write separation. Minor overlaps exist: dashboard vs sales_summary both report revenue, and the three settings tools (OpenCart vs Journal3 theme vs skin) could confuse without Journal3 familiarity.
The set predominantly uses a consistent verb_noun convention (get_*, update_*, list_*, create_*). A few exceptions like query, dashboard, sales_summary, and clear_cache break the pattern but remain readable and unambiguous.
42 tools is heavy for any single server, exceeding the 25-tool threshold where agents may struggle to scan the surface. The broad domain (OpenCart core, Journal3 theme, DB, VPS files) justifies many tools, but the count is still on the high side.
Read coverage is broad and write operations cover updates for products, categories, settings, SEO, and content, with run_sql as a fallback for missing writes. However, no create/delete tools exist for products, categories, customers, or vouchers, which are notable gaps for full lifecycle management.
Maintenance
Related MCP Connectors
Ask Claude or ChatGPT about your PrestaShop sales, stock and orders. Safe edits with undo.
Ask Claude or ChatGPT about your WooCommerce sales, stock and orders. Safe edits with undo.
Run a WooCommerce shop from Claude or ChatGPT: sales and stock reports, SEO, prices, products, menus and site design. Every change is a draft that you approve with one click, and you can undo it. Free forever: 100 actions a day. Skill: github.com/SakkoulasGiannis/addsynapse-woocommerce
Manage WordPress blogs and WooCommerce shops from Claude, ChatGPT, Cursor and other MCP apps.
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceEnables complete management of PrestaShop e-commerce stores through natural language, including products, categories, customers, orders, modules, cache, themes, and navigation menus.8MIT
- FlicenseNot gradedqualityDmaintenanceAI-powered Shopify Admin via Claude + MCP, enabling full store management through conversation including products, collections, analytics, and bulk operations.-
- AlicenseCqualityDmaintenanceConnects your Shopify store data to Claude Desktop, enabling access to products, orders, customers, inventory, and more through natural language.154MIT
- FlicenseNot gradedqualityDmaintenanceEnables AI assistants like Claude to query, analyze, and summarize local SQLite e-commerce databases using natural language through 11 tools, schema resources, and pre-built analytical prompts.-