zava-sales-analysis-online

zava-sales-analysis-online is an MCP server for Claude Code, Codex, Cursor, Gemini CLI, OpenCode from microsoft/MCP-Server-and-PostgreSQL-Sample-Retail. Its token cost is not measured, scanned A, original, MIT.

A remotely hosted MCP server for the ZavaShop retail sample. MCP is a standard way for an AI coding tool to call an external service; this server provides access to sales-analysis functions.

In plain words
What is it for?
Use it for sales analysis in the ZavaShop retail project, through its configured local HTTP endpoint.
Why use it?
It connects the development workflow to sales data and analysis without requiring those functions to be built into the editor.

MCP server for Claude CodeCodexCursorGemini CLIOpenCode ✓ vendor

Written for no agent in particular: it speaks MCP, so any client can run it.

One of 4 entries in mcp.json upstream. Installing this one merges just its entry into your config; the other 3 are separate, each on its own page.

Good fit Use it for sales analysis in the ZavaShop retail project, through its configured local HTTP endpoint.

Compare 6 mcp servers from other repositories ↓
Install with agentmods
npx agentmods add mcp/microsoft/mcp-server-and-postgresql-sample-retail/zava-sales-analysis-online
About the project

MCP Server and PostgreSQL Sample - Retail Sales Analysis is an example Model Context Protocol server that gives AI assistants controlled access to retail sales data stored in PostgreSQL. It is intended for learning how to build and deploy database-connected MCP services for retail analytics, including secure and schema-aware data access. The catalogue entries operate this sample MCP server.

microsoft/MCP-Server-and-PostgreSQL-Sample-Retail · 20 stars · on GitHub

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Clone the repo
git clone --depth 1 https://github.com/microsoft/MCP-Server-and-PostgreSQL-Sample-Retail

Made for: Claude Code, Codex, Cursor, Gemini CLI, OpenCode.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for zava-sales-analysis-online

README.md
[![agentmods](https://agentmods.dev/badge/mcp/microsoft/mcp-server-and-postgresql-sample-retail/zava-sales-analysis-online/github.svg)](https://agentmods.dev/mcp/microsoft/mcp-server-and-postgresql-sample-retail/zava-sales-analysis-online)
Your own site
<a href="https://agentmods.dev/mcp/microsoft/mcp-server-and-postgresql-sample-retail/zava-sales-analysis-online"><img src="https://agentmods.dev/badge/mcp/microsoft/mcp-server-and-postgresql-sample-retail/zava-sales-analysis-online/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for zava-sales-analysis-online

Your own site · 80×15
<a href="https://agentmods.dev/mcp/microsoft/mcp-server-and-postgresql-sample-retail/zava-sales-analysis-online"><img src="https://agentmods.dev/badge/mcp/microsoft/mcp-server-and-postgresql-sample-retail/zava-sales-analysis-online.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session not measured What this adds to a session before it is invoked.
When invoked not measured Not applicable: nothing here is loaded into a session.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
Origin original No closer match found in the catalogue.
Security

Grade A, and why

zava-sales-analysis-online scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 2d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

.vscode/mcp.json · 9 lines

What it actually says

{
  "zava-sales-analysis-online": {
    "url": "http://127.0.0.1:8000/mcp",
    "type": "http",
    "headers": {
      "x-rls-user-id": "2f4e6d8c-1a3b-5c7e-9f0a-b2d4f6e8c0a2"
    }
  }
}
Same file

What else mcp.json configures

This page is one entry in a file that holds 4. Installing the file brings all of them; each is measured and scanned on its own page.

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 2d ago First seen · 9 lines scan A c2b8f6cff6f9

Subscribe to this mod's changes

zava-sales-analysis-online is an MCP server published in the GitHub repository microsoft/MCP-Server-and-PostgreSQL-Sample-Retail (20 stars, last pushed 2d ago), licensed MIT. Its token cost is not measured: an MCP server costs its tool schemas, not its config file. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-09-19.