# PostgreSQL

> Use this tool when you need to interact with PostgreSQL databases to create, manage, and query data. It solves problems related to database schema design, table management, and data retrieval by providing a straightforward interface for executing SQL queries and describing table structures. With inputs including SQL queries and database connections, and outputs including query results and table descriptions, use PostgreSQL for building data-driven applications, managing database schemas, and performing data analysis.

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

## Description

Enables direct interaction with PostgreSQL databases through four core tools: creating tables with custom schemas, listing all tables in the public schema, describing table structures with column details, and executing arbitrary SQL queries. Features a built-in web configurator for secure API key generation and database connection management, with automatic usage tracking stored locally. Supports Docker deployment with docker-compose for local development.

## Trust

- **Trust score (0–1):** 0.93
- **Verification tier:** verified
- **Last scanned:** 2026-09-19

## Facts

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

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/udaykumar-dhokia-postgresql)
- **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"
    }
  }
}
```

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