Schema | analytics-mcp

analytics-mcp

Describes the environment variables required to run the server.

Name	Required	Description	Default
No arguments

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.

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`	{}

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.

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.

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.

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/bhavya998/analytics-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server