# pg-analytics-mcp

> pg-analytics-mcp — sa3fa-pg-analytics-mcp. Use this tool when you need to analyze data from a Postgres database, as it enables read-only querying of an analytics schema via a managed MCP server. It solves problems related to data introspection and querying, providing auto-generated tools and configurable SQL queries defined in YAML. Ideal for use cases requiring flexible and secure data analysis, with inputs including YAML configurations and outputs featuring query results.

Canonical page: https://skillsregistry.net/skills/sa3fa-pg-analytics-mcp  
JSON: https://api.skillsregistry.net/v1/skills/sa3fa-pg-analytics-mcp

## Description

Enables Claude to query a Postgres analytics schema via a read-only MCP server, with tools auto-generated from live database introspection and configurable SQL queries defined in YAML.

## Trust

- **Trust score (0–1):** 0.67
- **Verification tier:** scanned
- **Last scanned:** 2026-09-04

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-09-04

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/wv6np7ghf3)
- **Repository:** <https://github.com/Sa3fa/pg-analytics-mcp>

## 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": "sa3fa-pg-analytics-mcp"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/sa3fa-pg-analytics-mcp` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/sa3fa-pg-analytics-mcp/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