# Postgres MCP Pro

> Use this tool when you need to analyze and optimize PostgreSQL database performance, tune indexes, and execute SQL queries safely. It provides database health analysis, query plan exploration, and index tuning, solving problems related to database optimization and query execution. Ideal for AI agents involved in database development and maintenance, it accepts database queries and configuration inputs and outputs performance metrics and optimization recommendations.

Canonical page: https://skillsregistry.net/skills/moecodeshere-mcptrial  
JSON: https://api.skillsregistry.net/v1/skills/moecodeshere-mcptrial

## Description

An open source Model Context Protocol server for PostgreSQL that provides database health analysis, index tuning, query plan exploration, and safe SQL execution for AI agents throughout the development process.

## Trust

- **Trust score (0–1):** 0.60
- **Verification tier:** unverified

## Facts

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

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/nc16g09qrf)
- **Repository:** <https://github.com/moecodeshere/mcptrial>

## 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": "moecodeshere-mcptrial"
    }
  }
}
```

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