# PostgreSQL with GitHub OAuth

> Use this tool when you need to securely manage PostgreSQL database operations with authenticated access through GitHub OAuth, solving problems of unauthorized data access and SQL injection. It provides a secure interface for table schema inspection, read-only queries, and privileged write operations, with inputs including GitHub usernames and SQL queries, and outputs including query results and database schema information. Ideal for teams requiring authenticated database access in AI workflows with strict security boundaries.

Canonical page: https://skillsregistry.net/skills/postgresql-github-oauth  
JSON: https://api.skillsregistry.net/v1/skills/postgresql-github-oauth

## Description

This PostgreSQL database MCP server by Cole Medin provides secure database operations through GitHub OAuth authentication and Cloudflare Workers deployment. Built with TypeScript and featuring role-based access control, it offers three core tools: table schema inspection for all authenticated users, read-only SQL queries with injection protection, and privileged write operations restricted to specific GitHub usernames. The implementation includes comprehensive security measures with SQL validation patterns, database error sanitization, connection pooling through the postgres library, and optional Sentry monitoring integration, making it ideal for teams needing authenticated database access in AI workflows while maintaining strict security boundaries and production-ready deployment on Cloudflare's edge infrastructure.

## Trust

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

## Facts

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

## Source

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

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