# postgresql-mcp

> Use this tool when you need to securely interact with PostgreSQL databases, manage connections, and execute SQL queries directly from AI assistants. It solves problems related to database management, data retrieval, and automation by providing a secure interface for AI tools to access and manipulate database tables. The tool accepts SQL queries and database credentials as inputs and returns query results, table listings, and connection status as outputs.

Canonical page: https://skillsregistry.net/skills/udaykumar-dhokia-postgresql-mcp  
JSON: https://api.skillsregistry.net/v1/skills/udaykumar-dhokia-postgresql-mcp

## Description

A secure MCP server that lets AI assistants directly interact with PostgreSQL databases via tools like create_table, list_tables, and execute_sql, plus a web configurator for managing connections.

## Trust

- **Trust score (0–1):** 0.69
- **Verification tier:** scanned
- **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/ks70apeal2)
- **Repository:** <https://github.com/udaykumar-dhokia/postgresql-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": "udaykumar-dhokia-postgresql-mcp"
    }
  }
}
```

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