# mcp-postgres

> Use this tool when you need to execute SQL queries or inspect PostgreSQL database structures, and want a safe and controlled interface for AI agents to interact with your database. It solves problems related to data retrieval, schema exploration, and read/write operations, while providing a secure default mode with optional write capabilities. It accepts SQL queries and database connections as inputs and returns query results or schema information as outputs, making it suitable for use cases involving data analysis, integration, or automation.

Canonical page: https://skillsregistry.net/skills/filipescordeiro2-mcp-postgres  
JSON: https://api.skillsregistry.net/v1/skills/filipescordeiro2-mcp-postgres

## Description

Enables AI agents to execute SQL queries and introspect PostgreSQL schemas, tables, and indexes with read-only safety by default. Supports optional write operations and works with Claude, LangChain, and other agents via stdio or HTTP transports.

## 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-04-21

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/l4eucdqhvx)
- **Repository:** <https://github.com/Filipescordeiro2/mcp-postgres>

## 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": "filipescordeiro2-mcp-postgres"
    }
  }
}
```

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