# postgres-mcp-assistant

> postgres-mcp-assistant — meghnatomar17-postgres-mcp-assistant. Use this tool when you need to explore PostgreSQL database metadata, execute secure read-only SQL queries, or query your database using natural language. It solves problems related to database exploration, data retrieval, and analysis, providing a user-friendly interface for inputs like SQL queries and natural language prompts, and outputs like query results and database insights. Ideal for use cases where you want to simplify database interactions, such as data analysis, reporting, or development, with the added benefit of local LLM integration for more intuitive querying.

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

## Description

An AI-powered PostgreSQL assistant built using the Model Context Protocol (MCP). Supports database metadata exploration, secure read-only SQL execution, and natural language querying with local LLM integration.

## Trust

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

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** container
- **Runtime environment:** vm
- **Updated:** 2026-09-28

## Source

- **Source listing:** [GitHub](https://github.com/MeghnaTomar17/postgres-mcp-assistant)

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

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