# pizza-analytics

> pizza-analytics — ferrerj-dbt-and-mcp-experiment. Use this tool when you need to analyze pizza sales data and generate insights on store-level and total sales metrics. It solves problems related to data querying and analysis by providing a natural language interface to access local DuckDB sales data. The tool takes natural language queries as input and outputs relevant sales metrics, making it ideal for use cases that require real-time analytical queries.

Canonical page: https://skillsregistry.net/skills/ferrerj-dbt-and-mcp-experiment  
JSON: https://api.skillsregistry.net/v1/skills/ferrerj-dbt-and-mcp-experiment

## Description

Exposes local DuckDB pizza sales data as MCP tools for querying store-level and total sales metrics via natural language, enabling local LLMs to perform real-time analytical queries.

## Trust

- **Trust score (0–1):** 0.70
- **Verification tier:** verified
- **Last scanned:** 2026-09-03

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** ai-ml
- **Updated:** 2026-09-03

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/giw8evgei9)
- **Repository:** <https://github.com/ferrerj/DBT-and-MCP-Experiment>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "ferrerj-dbt-and-mcp-experiment"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/ferrerj-dbt-and-mcp-experiment` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/ferrerj-dbt-and-mcp-experiment/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt
