Introduction

The Model Context Protocol (MCP) is a standard for connecting Large Language Models (LLMs) to platforms like WoWSQL. Once connected, your AI assistants can interact with and query your WoWSQL projects on your behalf.

Getting Your MCP Token

Step-by-Step Token Generation

1. Log in to your WoWSQL dashboard at app.wowsql.com (use email/password or OAuth - Google/GitHub)
2. Go to your Profile page → MCP Access Tokens section
3. Click "Generate MCP Token" (optionally name your client, e.g., "Cursor" or "Claude Desktop")
4. Copy the generated token immediately (you won't see it again!)
5. Add the token to your MCP client configuration as shown below

Client Configuration

Choose your MCP client and follow the installation instructions:

{
  "mcpServers": {
    "wowsql": {
      "url": "https://api.wowsql.com/api/v1/mcp",
      "transport": "http",
      "headers": {
        "Authorization": "Bearer YOUR_MCP_TOKEN_HERE",
        "Content-Type": "application/json"
      }
    }
  }
}

{
  "mcp.servers": {
    "wowsql": {
      "url": "https://api.wowsql.com/api/v1/mcp",
      "transport": "http",
      "headers": {
        "Authorization": "Bearer YOUR_MCP_TOKEN_HERE",
        "Content-Type": "application/json"
      }
    }
  }
}

{
  "mcpServers": {
    "wowsql": {
      "url": "https://api.wowsql.com/api/v1/mcp",
      "transport": "http",
      "headers": {
        "Authorization": "Bearer YOUR_MCP_TOKEN_HERE",
        "Content-Type": "application/json"
      }
    }
  }
}

{
  "mcpServers": {
    "wowsql": {
      "command": "python",
      "args": ["-m", "app.mcp.stdio_server", "--token", "YOUR_MCP_TOKEN_HERE"],
      "env": {
        "PYTHONPATH": "/path/to/backend"
      }
    }
  }
}

{
  "mcpServers": {
    "wowsql": {
      "command": "python",
      "args": ["/path/to/backend/mcp_stdio_bridge.py", "--token", "YOUR_MCP_TOKEN_HERE"]
    }
  }
}

Available Tools

Once connected, these MCP tools are available:

• list_projects - List all your WoWSQL projects
• list_tables - List all tables in a project
• query_database - Query table data with filters
• create_table - Create database tables
• alter_table - Modify table structure (add/drop/modify columns)
• drop_table - Delete tables
• insert_data - Insert new rows into tables
• update_data - Update existing rows
• delete_data - Delete rows from tables

Security & Best Practices

WoWSQL MCP is built with security as a top priority. Our server includes comprehensive security features including SQL injection protection, rate limiting, audit logging, and robust error handling.

Built-in Security Features

Best Practices for Production

• API Key Management: Use environment variables to store your API keys securely. Rotate keys regularly and use different keys for development and production environments.
• Project Scoping: Scope your MCP server to specific projects to limit access to only the resources you need. This provides better isolation and security.
• Tool Permissions: Configure which tools are available to the LLM. Enable only the tools you need to minimize the attack surface.
• Manual Approval: Most MCP clients support manual approval of tool calls. Keep this enabled in production to review operations before execution.
• Monitor Audit Logs: Regularly review audit logs to track MCP usage and identify any unusual patterns or potential security issues.

Understanding Prompt Injection

Prompt injection is a technique where malicious instructions are embedded in user content to manipulate LLM behavior. WoWSQL MCP includes multiple layers of protection against this:

HTTP Transport Support

Production Ready

Next Steps

Your AI tool is now connected to your WoWSQL project using HTTP-based MCP. Try asking the AI tool to query your database using natural language commands.