{"server":"shopsphere-mcp","version":"1.0.0","protocol":"Model Context Protocol (JSON-RPC 2.0)","transport":"Streamable HTTP (single-response JSON mode)","usage":"POST JSON-RPC 2.0 messages to https:\/\/chatweb.backendwithdev.in\/mcp","methods":["initialize","notifications\/initialized","ping","tools\/list","tools\/call"],"example":{"jsonrpc":"2.0","id":1,"method":"tools\/call","params":{"name":"get_orders_today","arguments":{}}},"tools":[{"name":"get_orders_today","description":"Get all orders placed TODAY: order count, total revenue, average order value, status breakdown and the most recent orders. Use this for questions like \"how many orders were placed today?\" or \"what came in today?\"."},{"name":"get_revenue_stats","description":"Get revenue statistics (total revenue, order count, average order value) for a given period: today, yesterday, this_week, this_month or all_time. Cancelled orders are excluded from revenue."},{"name":"get_top_products","description":"Get the best-selling products ranked by units sold or by revenue. Use for questions like \"what are my top selling products?\"."},{"name":"get_order_status_breakdown","description":"Get the count of orders in each status (pending, processing, shipped, delivered, cancelled) across the whole store. Use for questions like \"how many orders are still pending?\" or \"give me an overview of order statuses\"."},{"name":"search_orders","description":"Search orders by order number, customer email or customer name, optionally filtered by status. Use when the admin asks about a specific order or customer."},{"name":"get_low_stock_products","description":"Get products whose stock has fallen to or below a threshold (default 10), sorted from lowest stock first. Use for inventory questions like \"which products are running low?\" or \"what needs restocking?\"."},{"name":"get_customer_stats","description":"Get customer statistics: total registered customers, how many have placed orders, new customers this month, average orders per customer and the top 5 customers by spend."},{"name":"get_sales_by_category","description":"Get sales performance broken down by product category: units sold and revenue per category, sorted by revenue. Use for questions like \"which category sells best?\"."},{"name":"run_sql_query","description":"Run a READ-ONLY SQL SELECT query against the e-commerce database and get the rows back. Tables available: users, categories, products, orders, order_items. Use this ONLY when no dedicated tool fits the question. Only single SELECT\/WITH statements are allowed; any data-modifying statement is rejected. Results are capped at 100 rows."}]}