# Postgres Scout

> Use this tool when you need to interact with and optimize PostgreSQL databases, and solve problems related to performance, data quality, and reliability. Postgres Scout provides a comprehensive set of 38 tools for exploration, diagnostics, and monitoring, accepting database connections as input and outputting detailed analytics and recommendations. It is particularly useful in contexts where database health, query optimization, and data integrity are critical, such as in high-traffic web applications or data-intensive enterprise systems.

Canonical page: https://skillsregistry.net/skills/bluwork-postgres-scout  
JSON: https://api.skillsregistry.net/v1/skills/bluwork-postgres-scout

## Description

Postgres Scout provides comprehensive PostgreSQL database interaction with 38 tools covering exploration, diagnostics, optimization, monitoring, data quality, and safe writes. Features include health scoring with component breakdown, table bloat analysis, slow query detection, index usage analysis, partitioning suggestions, and temporal analysis with seasonality detection. The server runs in read-only mode by default with explicit opt-in for write operations and preview/dry-run capabilities.

## Trust

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

## Facts

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

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/bluwork-postgres-scout)
- **Repository:** <https://github.com/bluwork/postgres-scout-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": "bluwork-postgres-scout"
    }
  }
}
```

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