# mcp-postgres-analytics

> mcp-postgres-analytics — archimedes-market-mcp-postgres-analytics. Use this tool when you need to analyze and optimize PostgreSQL database performance without modifying its structure or data. It provides read-only insights into query plans, slow queries, index usage, table bloat, and vacuum status, helping you identify and resolve performance issues. Ideal for use cases where database auditing and performance monitoring are required without granting write access.

Canonical page: https://skillsregistry.net/skills/archimedes-market-mcp-postgres-analytics  
JSON: https://api.skillsregistry.net/v1/skills/archimedes-market-mcp-postgres-analytics

## Description

Read-only PostgreSQL analytics agent exposed as an MCP server. Lets Claude / ChatGPT / Cursor inspect query plans, surface slow queries, audit index usage, detect table bloat, and report vacuum status — without any DDL, DML, or write access. Designed

## Trust

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

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** container
- **Runtime environment:** vm
- **Category:** database
- **Updated:** 2026-09-21

## Source

- **Source listing:** [GitHub](https://github.com/archimedes-market/mcp-postgres-analytics)

## 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": "archimedes-market-mcp-postgres-analytics"
    }
  }
}
```

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