# jigarkkarangiya/magento-sql-mcp-server

Source: https://glimind.com/server/glama%2Fjigarkkarangiya%2Fmagento-sql-mcp-server
Registry id: `glama/jigarkkarangiya/magento-sql-mcp-server`
Status: unknown

## Tools (44)

- `audit_cms_page_blocks`: Active/inactive audit of blocks in a page
- `audit_plaintext_secrets`: Flag plaintext secrets in config
- `count_table_rows`: Row count for one table
- `describe_table`: Column definitions from INFORMATION_SCHEMA
- `detect_magento_environment`: Detect OSS vs Commerce, MSI, B2B, staging columns
- `execute_select_query`: Read-only SELECT/SHOW/DESCRIBE/EXPLAIN (auto LIMIT 100)
- `explain_select_query`: EXPLAIN plan for a SELECT
- `find_active_quote_by_email`: Most recent active cart
- `find_customer_by_email`: Exact email only + order stats
- `find_customers_by_name`: Firstname/lastname LIKE search
- `find_order_by_increment_id`: Order header + line items
- `find_product_by_sku`: Product entity + stock + websites
- `get_active_quote_items`: Quote line items with parent-child nesting
- `get_b2b_negotiable_quotes`: B2B negotiable quotes (optional company_id)
- `get_catalog_rule_price`: Indexed catalog rule price
- `get_cms_block`: CMS block by identifier or block_id
- `get_cms_page`: CMS page by identifier + embedded block IDs
- `get_configurable_children`: Configurable to simple child SKUs
- `get_connection_status`: Test connectivity, host, database, latency
- `get_cron_schedule`: Recent cron entries
- `get_db_queue_backlog`: Queue backlog (sampled on large DBs)
- `get_eav_attribute`: Attribute metadata + join hints
- `get_failed_cron_jobs`: Failed/stuck crons (24h)
- `get_foreign_keys`: Foreign key relationships
- `get_heavy_log_tables`: Oversized log/visitor tables
- `get_indexer_status`: indexer_state + mview_state
- `get_largest_tables`: Top tables by storage size
- `get_magento_config`: core_config_data with value_status + scope inheritance
- `get_module_versions`: Installed module versions
- `get_msi_stock_status`: Physical qty, reservations, salable qty
- `get_order_shipment_tracks`: Shipment tracking numbers
- `get_order_tax_breakdown`: Tax rates applied to an order
- `get_product_attributes`: Name, price, status, visibility, url_key
- `get_product_categories`: Category assignments with names
- `get_staging_upcoming_updates`: Future staging campaigns for a SKU
- `get_store_hierarchy`: Websites, store groups, store views
- `get_table_indexes`: Index details
- `get_url_rewrite`: URL rewrite lookup
- `list_available_tools`: Meta-tool: categorized tool catalog
- `list_connection_profiles`: List configured DB profiles
- `list_tables`: List tables (optional SQL LIKE pattern)
- `run_database_health_check`: Snapshot: connection, indexers, crons, queue backlog
- `search_columns`: Find tables containing a column name
- `validate_select_query`: Validate SQL safety without executing

Measured by Glimind (https://glimind.com): MCP handshake + tool list only, no tool is ever called. CC BY 4.0.