# WoWSQL

Links managed Postgres to your AI assistant over HTTP and OAuth 2.0 to execute queries and manage storage.

- MCP server · `type=mcp` · Claude Code, Codex, Cursor, GitHub Copilot, Windsurf (Devin Desktop), Cline, Zed, Gemini CLI · ★ 5
- Author: WoWSQL
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/WoWSQL/MCP-Server
- Updated: 2026-08-13
- HTML: https://affpapa.org/en/nevibecode/mcp/wowsql

## What it does

WoWSQL connects coding assistants to cloud database instances. Running as an HTTP MCP service, it secures tool execution using OAuth 2.0 code exchange with PKCE. The agent gains direct access to run SQL queries and inspect storage containers.

The service acts as an OAuth protected endpoint rather than the identity server itself. Inbound JSON-RPC calls sent via `POST /mcp` require Bearer tokens, which validate against `WOWSQL_API_BASE`. For Electron environments like Cursor, the server proxies registration and token endpoints to prevent local connection failures.

Local deployments require a functioning FastAPI backend reachable at `WOWSQL_API_BASE`. Without that backend service or setting `MCP_ALLOW_UNAUTHENTICATED=true`, every request fails with a 401 status code.

## Requirements
- Remote server: `https://mcp.wowsql.com/mcp`

## Install

### Claude Code (native platform)

**Platform CLI: remote server**
```bash
claude mcp add --transport http mcp https://mcp.wowsql.com/mcp
```

### Codex

**Platform CLI: remote server**
```bash
codex mcp add wowsql --url https://mcp.wowsql.com/mcp
```

### Cursor

**Config file**
File `.cursor/mcp.json`:
```json
{
    "mcpServers": {
        "wowsql": {
            "url": "https://mcp.wowsql.com/mcp"
        }
    }
}
```

### GitHub Copilot

**Config file**
File `.vscode/mcp.json`:
```json
{
    "servers": {
        "wowsql": {
            "type": "http",
            "url": "https://mcp.wowsql.com/mcp"
        }
    }
}
```

### Gemini CLI

**Platform CLI: remote server**
```bash
gemini mcp add -t http wowsql https://mcp.wowsql.com/mcp
```

## When to use it
- execute SQL queries on managed Postgres instances
- search project documentation using semantic queries
- manage cloud storage buckets and objects
- route OAuth tokens reliably through Electron-based IDEs

## Example prompts
- Run a query on the WoWSQL database to retrieve recent active users
- Search the project documentation for migration instructions
- List all storage buckets available in the current project

## Similar
- [World Monitor](https://affpapa.org/en/nevibecode/mcp/world-monitor.md) — MCP server · ★ 89609
- [Scrapling MCP Server](https://affpapa.org/en/nevibecode/mcp/scrapling-mcp-server.md) — MCP server · ★ 89899
- [MCP Toolbox for Databases](https://affpapa.org/en/nevibecode/mcp/googleapis-mcp-toolbox-for-databases.md) — MCP server · ★ 16730
- [PostHog MCP Server](https://affpapa.org/en/nevibecode/mcp/posthog-mcp-server.md) — MCP server · ★ 40459
- [dbx](https://affpapa.org/en/nevibecode/mcp/dbx.md) — MCP server · ★ 27844
- [Metabase](https://affpapa.org/en/nevibecode/mcp/metabase.md) — MCP server · ★ 49863

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md