# PostgreSQL Credentials

> Use this tool when you need to securely access a PostgreSQL database with authenticated users, leveraging GitHub OAuth and role-based access control to manage read and write operations. It solves problems related to database security, authentication, and authorization, providing a production-ready implementation with enterprise-grade controls. Ideal for developers and teams requiring authenticated database access with OAuth flows, database integration, and secure deployment via Cloudflare Workers.

Canonical page: https://skillsregistry.net/skills/preangelleo-postgresql-credentials  
JSON: https://api.skillsregistry.net/v1/skills/preangelleo-postgresql-credentials

## Description

Production-ready MCP server implementation by Cole Medin that provides secure PostgreSQL database access through GitHub OAuth authentication and Cloudflare Workers deployment. The implementation features a dual-architecture approach with direct database tools for authenticated users and an HTTP API wrapper for bypassing Cloudflare Workers' connection limitations, plus role-based access control where read operations are available to all authenticated users while write operations require privileged GitHub usernames. Built with TypeScript and including SQL injection protection, Sentry monitoring integration, comprehensive validation loops, and a specialized PRP (Product Requirement Prompt) system for generating new MCP servers, it serves developers who need authenticated database access with enterprise security controls and teams wanting to rapidly scaffold new MCP servers using proven patterns for OAuth flows, database integration, and production deployment.

## Trust

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

## Facts

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

## Source

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

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