BlogWoWSQLGet started
tutorial··8 min read·WoWSQL Team

Connect ChatGPT to Your Database with WoWSQL MCP (Complete Guide)

Step-by-step guide to connecting ChatGPT, Cursor, and Claude to your WoWSQL project using the production MCP server with OAuth 2.0 — database, docs, and project tools.

Connect ChatGPT to Your Database with WoWSQL MCP

Model Context Protocol (MCP) is the open standard that lets AI assistants — ChatGPT, Cursor, Claude Desktop, VS Code, and more — interact with external tools and data sources securely.

WoWSQL ships a production MCP server so your AI client can understand your PostgreSQL schema, read WoWSQL documentation, and manage project context — not just hallucinate table names.

What is WoWSQL MCP?

WoWSQL MCP is an HTTP MCP server with OAuth 2.0 authorization code + PKCE:

  • Endpoint: https://mcp.wowsql.com/mcp
  • Auth: OAuth 2.0 via your WoWSQL account
  • Package: @wowsql/mcp-server-wowsql on npm (self-hosted option)

When an MCP client connects, you approve access in the WoWSQL dashboard — same trust model as connecting GitHub to a third-party app.

MCP scope: what tools are available?

You can scope MCP access per project with query parameters:

https://mcp.wowsql.com/mcp?project_ref=YOUR_PROJECT&read_only=true&features=database,docs
Feature What it enables
database Schema inspection, safe queries, table awareness
docs WoWSQL product and API documentation in context
account Project and account management tools

Use read_only=true when you only want schema exploration without write operations.

Supported MCP clients

WoWSQL MCP works with any MCP-compatible client, including:

  • ChatGPT (with MCP connector support)
  • Cursor
  • Claude Desktop
  • VS Code (MCP extensions)
  • Windsurf

The dashboard OAuth flow at /mcp/oauth handles consent for each client.

How to connect (high level)

  1. Log in to app.wowsql.com
  2. Open your project → MCP settings
  3. Copy the scoped MCP URL for your project
  4. In your AI client, add the MCP server URL
  5. Complete OAuth when prompted — approve project access
  6. Ask questions: "What tables are in my database?", "Write a query for active users last 7 days"

MERA + MCP: two AI layers

WoWSQL offers two complementary AI surfaces:

  • MCP — external AI clients (ChatGPT, Cursor) talk to your WoWSQL project
  • MERA — in-dashboard SQL copilot that generates optimized PostgreSQL from natural language

Use MCP when you live in ChatGPT or your IDE. Use MERA when you are inside the WoWSQL SQL editor.

Security model

  • OAuth 2.0 + PKCE — no long-lived passwords in config files
  • Project-scoped tokens — access limited to approved projects
  • Read-only mode — optional for exploration
  • Activity logging — MCP requests can be logged per project (dashboard)

WoWSQL does not control third-party AI providers. Their terms apply to prompts and responses sent to ChatGPT, Claude, etc.

Why this matters for developers

Before MCP, AI assistants guessed your schema from snippets you pasted. With WoWSQL MCP:

  • Schema-aware answers
  • Fewer broken queries
  • Faster onboarding for new team members
  • AI-assisted migrations and reporting

Self-hosted MCP (advanced)

Developers can run the open MCP package locally:

npm install -g @wowsql/mcp-server-wowsql
# Set WOWSQL_API_BASE and OAuth env — see docs

Production teams typically use mcp.wowsql.com behind TLS.

Next steps

WoWSQL — Indian BaaS with Postgres, Auth, Realtime, Storage, and AI-native tooling.