# postgres

> Use this tool when you need to query and inspect a PostgreSQL database, solving problems such as data analysis, schema exploration, and SQL query execution. It takes SQL queries and database connections as inputs and returns query results, schema information, and table descriptions as outputs. Use it in contexts where you need to interact with PostgreSQL databases, such as data science, application development, and database administration.

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

## Description

Enables querying and inspecting a PostgreSQL database, including executing SQL queries, listing schemas and tables, and describing table columns.

## Trust

- **Trust score (0–1):** 0.70
- **Verification tier:** verified
- **Last scanned:** 2026-08-31

## Facts

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

## Source

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

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

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