WoWSQL — Claude Code MCP server: what it does, how to install
Links managed Postgres to your AI assistant over HTTP and OAuth 2.0 to execute queries and manage storage.
claude mcp add --transport http mcp https://mcp.wowsql.com/mcpWhat WoWSQL 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.
What it helps with
- 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 for the agent
- 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
How to install WoWSQL
Platform CLI: remote server
claude mcp add --transport http mcp https://mcp.wowsql.com/mcpPlatform CLI: remote server
codex mcp add wowsql --url https://mcp.wowsql.com/mcpConfig file
{
"mcpServers": {
"wowsql": {
"url": "https://mcp.wowsql.com/mcp"
}
}
}Config file
{
"servers": {
"wowsql": {
"type": "http",
"url": "https://mcp.wowsql.com/mcp"
}
}
}Platform CLI: remote server
gemini mcp add -t http wowsql https://mcp.wowsql.com/mcpStep by step, with commands for each platform: How to add an MCP server to Claude Code, Codex, Cursor, VS Code, Gemini CLI and more
Questions about WoWSQL
How to install WoWSQL in Claude Code?
Add the endpoint by running claude mcp add --transport http wowsql https://mcp.wowsql.com/mcp in your terminal.
What does WoWSQL do?
It provides HTTP tools for AI assistants to execute Postgres queries, look up documentation, and access file storage using OAuth tokens.
Why does the local process proxy OAuth requests?
Desktop clients such as Cursor encounter fetch errors when querying local auth hosts directly, so the server forwards authentication endpoints to WOWSQL_API_BASE.
