# PostgreSQL with GitHub OAuth

> Use this tool when you need to securely access and manage PostgreSQL databases with granular permission controls, leveraging GitHub OAuth authentication for role-based access. It solves problems of authenticated database access, SQL injection protection, and performance tracking, accepting GitHub usernames and passwords as inputs and outputting database query results. Ideal for teams building AI-powered database applications requiring secure, authenticated access to production databases with fine-grained permissions.

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

## Description

This MCP server provides AI assistants with secure database access through GitHub OAuth authentication and PostgreSQL integration, built by Cole Medin using Cloudflare Workers with Durable Objects for stateful session management. The implementation features role-based access control where all authenticated GitHub users can perform read-only database operations like table listing and SELECT queries, while write operations (INSERT, UPDATE, DELETE) are restricted to specific GitHub usernames defined in an allowlist. Built with TypeScript using the workers-mcp framework, Hono for HTTP handling, and the postgres library for database connectivity, it includes SQL injection protection, query validation, connection pooling optimized for Cloudflare Workers' constraints, and optional Sentry integration for error monitoring and performance tracking. The server supports both simple math operations for testing and full PostgreSQL database management, making it valuable for teams building AI-powered database applications that need secure, authenticated access to production databases with granular permission controls based on GitHub identity.

## 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/coleam00-postgresql-github-oauth)
- **Repository:** <https://github.com/coleam00/remote-mcp-server-with-auth>

## 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": "coleam00-postgresql-github-oauth"
    }
  }
}
```

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