# moat-mcp

> moat-mcp — vinnyang-moat-mcp. Use this tool when you need to securely execute read-only SQL queries, as it provides a security-hardened Postgres MCP server that enforces safe query execution through SQL-AST inspection and read-only transactions, solving problems related to data protection and access control. It accepts SQL queries as input and returns query results as output, making it suitable for use cases where sensitive data needs to be queried without modification. Ideal for deployments where data security and integrity are paramount, such as in LLM agent applications.

Canonical page: https://skillsregistry.net/skills/vinnyang-moat-mcp  
JSON: https://api.skillsregistry.net/v1/skills/vinnyang-moat-mcp

## Description

A security-hardened Postgres MCP server that enables LLM agents to run safe, read-only SQL queries with enforcement via SQL-AST inspection and read-only transactions.

## Trust

- **Trust score (0–1):** 0.69
- **Verification tier:** scanned
- **Last scanned:** 2026-08-29

## Facts

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

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/disr20dsgl)
- **Repository:** <https://github.com/vinnyang/moat-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": "vinnyang-moat-mcp"
    }
  }
}
```

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