analytics-mcp
Provides tools and resources for querying and analyzing an enterprise sales SQLite database, including revenue reports, customer profiles, product leaderboards, sales trends, and regional performance.
This server does not currently have a deployable release on Glama. Follow the repository's setup instructions to install and configure it for your MCP client, including any required credentials and local dependencies.
analytics-mcp
Production-grade MCP server for enterprise sales analytics. 6 tools, 3 resources, 2 prompts — all with structured outputs — over a SQLite database. Connects to Claude, OpenCode, Cursor, and any MCP client.
What This Is
A Model Context Protocol (MCP) server that exposes an enterprise sales database to LLM clients. Instead of copy-pasting data into ChatGPT, connect this server and let the AI query, analyze, and visualize your data through structured tools.
Built with the latest MCP patterns (July 2026):
FastMCP 3.4 — high-level server framework
Structured outputs — Pydantic models define
outputSchemafor every toolTool annotations —
readOnlyHintlets clients skip confirmationsIn-memory client testing — no port flakiness, era-neutral
Resources — schema introspection, table details, report templates
Prompts — reusable analysis templates (sales analysis, customer segmentation)
Both transports — stdio (local) + HTTP (remote)
Related MCP server: sales-agent-mcp
Quick Start
git clone https://github.com/abhijithezzoft/analytics-mcp-demo.git
cd analytics-mcp-demo
uv sync
# Initialize database (200 customers, 25 products, 2000 orders)
uv run analytics-mcp init
# Start server (stdio for local MCP clients)
uv run analytics-mcp serve
# Or HTTP transport for remote access
uv run analytics-mcp serve --transport http --port 8000Connect to Claude Desktop / OpenCode
Add to your MCP client config:
{
"mcpServers": {
"analytics": {
"command": "uv",
"args": ["run", "--directory", "/path/to/analytics-mcp-demo", "analytics-mcp", "serve"]
}
}
}Then ask: "Show me the top 5 products by revenue and analyze the monthly sales trend"
Tools
Tool | Description | Annotations |
| Run parameterized SELECT queries against the database |
|
| Revenue by category/region/tier/status/month with profit analysis |
|
| 360-degree customer view: orders, LTV, favorite category, recent activity |
|
| Leaderboard by revenue or quantity, optional category filter |
|
| Time-series with period-over-period growth rates |
|
| Ranked regional performance with revenue, orders, customers, AOV |
|
Resources
URI | Description |
| Full database schema (all tables, columns, types, row counts) |
| Detailed table schema with sample rows |
| Available report templates and usage examples |
Prompts
Prompt | Description |
| Comprehensive sales analysis with focus area (overall/category/region/customer) |
| Segment customers into Champions/At Risk/New/Dormant with retention strategies |
Database Schema
customers (200 rows)
id, name, email, company, region, tier, signup_date, lifetime_value
products (25 rows)
id, name, category, price, cost, stock
orders (2000 rows)
id, customer_id, employee_id, order_date, status, total
order_items (5000+ rows)
id, order_id, product_id, quantity, unit_price
employees (15 rows)
id, name, role, region, hire_dateTesting
make test # 43 tests: database, tools, full MCP client integration
make lint # ruffSuite | Tests | Pattern |
| 9 | DB init, query validation, schema introspection |
| 21 | Direct tool function calls (all 6 tools) |
| 13 | Full MCP protocol via in-memory Client |
Tests use the modern in-memory Client(mcp) pattern — no ports, no subprocesses, era-neutral.
Tech Stack
Layer | Technology |
MCP Framework | FastMCP 3.4 (Prefect) |
Protocol | MCP 1.28 (Streamable HTTP + stdio) |
Database | SQLite with seeded enterprise data |
Validation | Pydantic v2 (structured tool outputs) |
CLI | Typer + Rich |
Testing | pytest + pytest-asyncio + FastMCP Client |
Project Structure
analytics-mcp/
├── src/analytics_mcp/
│ ├── server.py MCP server: 6 tools, 3 resources, 2 prompts
│ ├── database.py SQLite setup + schema + seed data (2000+ orders)
│ ├── schemas.py Pydantic models for structured outputs
│ └── cli.py CLI (serve, init, inspect)
├── tests/ 43 tests (database, tools, client integration)
├── data/ SQLite database (auto-generated, gitignored)
├── Makefile
└── pyproject.tomlLicense
MIT
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
This server cannot be deployed
Maintenance
Related MCP Connectors
Ask questions in plain language, get answers from your business database. No SQL required.
The all-in-one data stack for agents. Upload files, run SQL, evolve tables, and render charts.
Query, explore, and manage your databases through natural conversation.
The grounded data layer for any LLM: governed SQL, metrics, lineage and catalog over your data.
Related MCP Servers
- FlicenseNot gradedqualityDmaintenanceProvides a suite of business tools for interacting with a SQLite sales database, including SQL query execution, KPI calculations, and report generation. It enables AI agents to analyze sales data across customers, products, and orders using the Model Context Protocol.-
- FlicenseNot gradedqualityDmaintenanceEnables natural language sales analysis by connecting to a SQLite database, generating charts, and exporting results to CSV/Excel.-
- AlicenseAqualityCmaintenanceA production-grade MCP server for enterprise sales analytics, enabling LLM clients to query, analyze, and visualize sales data from a SQLite database through structured tools, resources, and prompts.6MIT
- FlicenseNot gradedqualityDmaintenanceEnables AI assistants like Claude to query, analyze, and summarize local SQLite e-commerce databases using natural language through 11 tools, schema resources, and pre-built analytical prompts.-