WoWSQL MCP (Model Context Protocol)
wowsql-style HTTP MCP with OAuth 2.0 authorization code + PKCE on the WoWSQL API.
Power your agent
URL ของผู้เผยแพร่เอง ไม่ใช่เอนด์พอยต์ของ PlugMCP
Host a copy with our keys and logs.
https://mcp.wowsql.com/mcpปุ่ม Claude ด้านบนจะเปิด Claude พร้อมกรอกชื่อและ URL ให้แล้ว คุณยังต้องยืนยันที่นั่นเอง
claude mcp add --transport http com.wowsql-mcp https://mcp.wowsql.com/mcpRun in a terminal.
{ "mcpServers": { "com.wowsql-mcp": { "command": "npx", "args": [ "-y", "mcp-remote", "https://mcp.wowsql.com/mcp" ] } }}claude_desktop_config.json
URL แบบรีโมตหรือคำสั่งบนเครื่องของคุณ? การติดตั้งสองแบบต่างกันอย่างไร
รันบน PlugMCP
A new server you create. It is not this listing's official endpoint. Use the publisher install when you want their URL and their credentials.
เปิดจากผู้เผยแพร่
wowsql-style HTTP MCP with OAuth 2.0 authorization code + PKCE on the WoWSQL API.
Managed Postgres MCP: projects, SQL, docs search, and storage buckets via OAuth.
| Package | Description |
|---|
packages/mcp-server-wowsql | @wowsql/mcp-server-wowsql — HTTP MCP server, createToolSchemas() for AI SDK |
From the repo root:
cd mcp
npm install
npm run build
npm start
The MCP process is an OAuth protected resource (not the authorization server):
POST /mcp requires Authorization: Bearer <access_token> unless MCP_ALLOW_UNAUTHENTICATED=true (dev only).WWW-Authenticate: Bearer ... resource_metadata="<url>" so MCP clients (Cursor, etc.) can start OAuth.GET {WOWSQL_API_BASE}/api/v1/auth/me with the same Bearer token (must match the JWT issued by WoWSQL OAuth or login).GET {WOWSQL_API_BASE}/.well-known/oauth-authorization-serverGET /.well-known/oauth-protected-resource/mcpCursor / Electron: OAuth metadata is rewritten so authorization_endpoint, token_endpoint, and registration_endpoint point at this MCP host (e.g. http://localhost:8787/...). The MCP process proxies those requests to WOWSQL_API_BASE, so the IDE does not need a working direct fetch to localhost:8000 for OAuth (which often shows up as fetch failed). You still need FastAPI running on WOWSQL_API_BASE so the proxy can reach it.
If MCP_PUBLIC_URL is unset, PRM and 401 resource_metadata are derived from each request’s Host (and X-Forwarded-Proto), so http://localhost:8787/mcp and http://127.0.0.1:8787/mcp each get matching metadata. Set MCP_PUBLIC_URL when the MCP is behind a reverse proxy or you need a single fixed origin in production.
Option A — .env / .env.local (recommended)
Copy packages/mcp-server-wowsql/.env.example to .env or .env.local in that folder. The CLI loads .env, then .env.local (overrides), then the process cwd .env. Use .env.local for machine-specific values (e.g. http://localhost:8000) without committing them.
cd mcp/packages/mcp-server-wowsql
cp .env.example .env
# edit .env — set WOWSQL_API_BASE to your API
npm run build # from mcp root: npm run build -w @wowsql/mcp-server-wowsql
npm start
Option B — shell (no file)
PowerShell:
cd mcp
$env:WOWSQL_API_BASE="http://localhost:8005"
$env:PORT="8787"
npm start
bash / zsh:
cd mcp
export WOWSQL_API_BASE=http://localhost:8005
export PORT=8787
npm start
POST http://localhost:8787/mcp — JSON-RPC body; append query params for scoping. MCP clients (Cursor, etc.) use this.GET http://localhost:8787/mcp returns 401 with a short “not authorized” page (no public metadata). The protocol is POST JSON-RPC with Authorization: Bearer.GET http://localhost:8787/healthExample scoped URL for clients:
http://localhost:8787/mcp?project_ref=<uuid-or-slug>&read_only=true&features=database,docs
GET https://api.wowsql.com/.well-known/oauth-authorization-serverGET /api/v1/auth/oauth/mcp/authorizePOST /api/v1/auth/oauth/mcp/approvePOST /api/v1/auth/oauth/mcp/token (grant_type=authorization_code or refresh_token)Dashboard consent UI: /mcp/oauth on the app (see dashboard/app/mcp/oauth/page.tsx).
mcp.wowsql.comWOWSQL_API_BASE / WOWSQL_OAUTH_ISSUER_URL to https://api.wowsql.com (not 127.0.0.1:8000/8001). Blue/green flips change the backend host port; the public hostname always follows the active slot via NPM.MCP_PUBLIC_URL=https://mcp.wowsql.com.mcp.wowsql.com to the service; health check: GET /health.redirect_uri values include your MCP client callbacks (see oauth_clients seed + env).EC2 blue/green: ./deploy/ec2-blue-green.sh mcp sets those env vars automatically.
cd mcp/packages/mcp-server-wowsql
npm version patch
npm publish --access public
Requires an npm org scope @wowsql (or change name in package.json).
Managed Postgres MCP: projects, SQL, docs search, and storage buckets via OAuth.
{ "mcpServers": { "com.wowsql-mcp": { "url": "https://mcp.wowsql.com/mcp", "headers": {} } }}เครื่องมือ
ยังไม่มีรายการเครื่องมือ เซิร์ฟเวอร์แบบรีโมตจะได้รายการหลังการตรวจสอบสถานะครั้งแรก
FAQ
คัดลอกคอนฟิก http สำหรับ Cursor, Claude Desktop, Claude Code หรือ VS Code ได้ในหน้านี้ คอนฟิกนี้ใช้การติดตั้งของผู้เผยแพร่ ไม่ใช่พร็อกซีของ PlugMCP
ระเบียนนี้ไม่ได้ระบุตัวแปรสภาพแวดล้อมที่จำเป็น
WoWSQL เข้าถึงได้ผ่าน HTTP
ตรวจสอบล่าสุดเมื่อ 2026-11-08 Managed Postgres MCP: projects, SQL, docs search, and storage buckets via OAuth.