analytics-mcp
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Features and capabilities supported by this server
Protocol revision2025-11-25
| Capability | Details |
|---|---|
| tools | {
"listChanged": true
} |
| logging | {} |
| prompts | {
"listChanged": false
} |
| resources | {
"subscribe": false,
"listChanged": false
} |
| extensions | {
"io.modelcontextprotocol/ui": {}
} |
| experimental | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| query_databaseA | Run a read-only SQL query against the enterprise database. Tables: customers, products, orders, order_items, employees. Examples: SELECT * FROM customers WHERE tier = 'enterprise' LIMIT 10 SELECT region, COUNT(*) as customers FROM customers GROUP BY region SELECT p.name, SUM(oi.quantity) as sold FROM order_items oi JOIN products p ON oi.product_id = p.id GROUP BY p.name ORDER BY sold DESC LIMIT 5 |
| get_revenue_reportA | Generate a revenue report grouped by a dimension within a date range. Returns total revenue, order count, average order value, and estimated profit per segment. |
| get_customer_profileA | Get a 360-degree customer view: profile, order history, spending stats, favorite category. Useful for account reviews, churn analysis, and upsell identification. |
| get_top_productsA | Get a leaderboard of top-performing products by revenue or quantity sold. Optionally filter by category. |
| analyze_sales_trendA | Analyze sales trends over time with period-over-period growth rates. Returns revenue, order count, and growth percentage for each period. |
| get_regional_performanceA | Get ranked sales performance by region: revenue, orders, customers, AOV. Returns all 5 regions ranked by total revenue. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
| sales_analysis | Generate a comprehensive sales analysis prompt for the LLM. |
| customer_segmentation | Generate a customer segmentation analysis prompt. |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
| database_schema | Full database schema: all tables, columns, types, and row counts. |
| report_templates | Available report templates and their descriptions. |
TDQS
Scored across 6 tools
Tools are mostly distinct: each targets a specific analytics aspect (trends, customer profile, regional, revenue report, top products, raw SQL). Some overlap in subject matter but purposes and outputs are clearly differentiated.
Most tools use 'get_' prefix, but 'analyze_sales_trend' and 'query_database' break the pattern. The naming is readable but inconsistent across verbs.
6 tools is well-scoped for an analytics server, covering common analytical functions without being excessive. Each tool earns its place.
Covers key analytics areas: trends, customers, regions, revenue, products. The query_database tool compensates for most gaps. Minor omission like employee analytics is noted but not critical.