$ loading_
Securely analyze online store SQLite data and sales metrics.
Copy the install command and let the AI configure it · recommended for beginners
No copy-paste install info for "Shop Analytics MCP" yet — see the docs or source repo.
First inspect the SQLite database schema for this online store and explain each table's purpose.
Returns table structure, field relationships, and the purpose of each table.
Please calculate customer metrics for this store, such as customer counts, purchasing behavior, or related aggregates.
Outputs customer-level statistics with a brief interpretation.
Please analyze product sales, category revenue, revenue over a time period, and order leaders, then summarize the key findings.
Outputs analysis conclusions for products, categories, periods, and order rankings.
An ecommerce operator or product manager wants to see which products sell best and which categories drive the most revenue. This tool securely analyzes the SQLite store database.
A data analyst needs quick customer metrics and order leaders for weekly, monthly, or ad hoc analysis. The tool provides dedicated analytics for these questions.
A team needs to compare revenue across time periods to evaluate promotions or campaigns. The tool can analyze period revenue directly from the database.
It securely analyzes an online store's SQLite database. It includes six specialized capabilities for schema, customer metrics, product sales, category revenue, period revenue, and order leaders.
The known prerequisite is access to the online store's SQLite database. No additional installation or key requirements are provided.
It is not a general-purpose query tool; it is preset with six ecommerce-focused analytics tools to retrieve common business metrics more directly.
Connect to SQLite databases for querying, schema exploration, and data export.
Query e-commerce SQLite data safely and answer business analytics questions.
Analyze e-commerce data to uncover customer, product, delivery, and sales insights.
Query local sales data and investigate anomalies with an inline review dashboard.
Query GA4 and Search Console for traffic, conversions, indexing, and sitemaps.
Analyze sales data in natural language, create charts, and export results.