Skip to main content
skill CX Codex

remote-mcp-server-with-auth — Claude Code skill

remote-mcp-server-with-auth is a Claude Code skill for building and deploying a Cloudflare Workers MCP server with GitHub OAuth and PostgreSQL. It supports role-based permissions.

no license 168 installs ★ 9 updated 2026-10-09

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add reason-machines/mcp-skills --skill remote-mcp-server-with-auth -a claude-code
Open on GitHub

What remote-mcp-server-with-auth does

This skill guides you through a Cloudflare Workers MCP server where users authenticate through GitHub OAuth and tools can access PostgreSQL. Clients can connect over streamable HTTP at /mcp or the legacy SSE endpoint at /sse. Tool implementations live in separate files under src/tools/; the examples include schema inspection and read-only queries.

A GitHub username allowlist in src/index.ts controls database write access. Query checks restrict the read-only tool, and the database connection is shared across tool calls. Deployment requires GitHub OAuth credentials, a cookie encryption key, DATABASE_URL, and a Cloudflare login through wrangler login. The server cannot authenticate users or connect to the database until those credentials and secrets are configured.

What it helps with

  • deploy a remote MCP server on Cloudflare Workers
  • add GitHub OAuth sign-in to an MCP server
  • limit PostgreSQL write access by GitHub username
  • separate database tools into individual files
  • offer HTTP and SSE endpoints for MCP clients

Example prompts for the agent

  • Create a remote MCP server with GitHub sign-in and PostgreSQL access.
  • Set up an MCP server on Cloudflare Workers with HTTP transport and a GitHub username allowlist for writes.
  • Add an MCP tool that lists the PostgreSQL schema and describe how to connect to it.

How to install remote-mcp-server-with-auth

1Skills CLI (Vercel)

npx skills add reason-machines/mcp-skills --skill remote-mcp-server-with-auth -a claude-code

2Manually: put the files in place

~/.claude/skills/remote-mcp-server-with-auth/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/remote-mcp-server-with-auth/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about remote-mcp-server-with-auth

How do I install remote-mcp-server-with-auth in Claude Code?

Run npx skills add reason-machines/mcp-skills --skill remote-mcp-server-with-auth -a claude-code. The skill file is located at ~/.claude/skills/remote-mcp-server-with-auth/SKILL.md.

What does remote-mcp-server-with-auth do?

It guides you in building a remote MCP server for Cloudflare Workers, with GitHub OAuth and PostgreSQL-backed tools. The template supports HTTP and SSE transports.

What do I need to configure for PostgreSQL access?

Set DATABASE_URL, GitHub OAuth credentials, and COOKIE_ENCRYPTION_KEY. Deployment also requires a Cloudflare login using wrangler login.

Similar skills

All skills for Backend and APIs →

From the same set98

The whole set →
mcp-server-code-execution-mode mcp-server-code-execution-mode executes Python in rootless Podman or Docker containers and proxies MCP tools through a single entry point, cutting context from 30,000 to 200 tokens. CX Codex +1 173installs nanobanana-mcp-image-generation The nanobanana-mcp-image-generation skill connects an agent to Gemini image generation and editing with model selection, 4K output, aspect ratios, and templates. Use it for visual assets from a coding workspace. CX Codex +1 172installs mcp-server-bash-sdk mcp-server-bash-sdk guides you in building zero-runtime Model Context Protocol servers using pure Bash and jq instead of heavy runtimes. CX Codex +1 171installs codex-mcp-server-integration codex-mcp-server-integration — a skill that bridges OpenAI Codex CLI to Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, and OpenCode via MCP. Brings code analysis, generation, branch review, and web search into the editor. CX Codex +1 171installs postman-mcp-server Hooks your coding agent up to Postman over MCP: workspaces, collections, environments, request runs and client code generation. CX Codex +1 168installs mcp-server-12306 Enables AI agents to query China Railway 12306 services. Checks real-time train availability, seat prices, schedules, and transfer routes. CX Codex +1 167installs quickbooks-online-mcp-server Connects coding assistants to a QuickBooks Online MCP server to handle bookkeeping entities and inspect accounting reports. CX Codex +1 166installs mcp-documentation-server The mcp-documentation-server skill indexes documents in a local database and searches by text or meaning. Use it to find relevant passages across files and retrieve their surrounding context. CX Codex +1 166installs

Project sponsors

Companies that keep this analytics open