Schema | analytics-mcp

analytics-mcp

Describes the environment variables required to run the server.

Name	Required	Description	Default
No arguments

Features and capabilities supported by this server

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