WAII MCP Server

April 29, 2025 ยท View on GitHub

A Model Context Protocol server that provides database interaction capabilities through WAII. This server enables Language Models to interact with databases, execute queries, and process database content through natural language.

mcp

Available Tools

database

Interact with databases through WAII's natural language interface.

Arguments:

  • database-key (string, required): Your database connection string
  • api-key (string, required): Your WAII API key
  • url (string, required): WAII API endpoint URL

Installation

When using uv/uvx no specific installation is needed. You can directly run the server using either approach:

Using uv:

uv run -m mcp_server_waii \
  --url "YOUR_WAII_URL" \
  --api-key "YOUR_API_KEY" \
  --database-key "YOUR_DATABASE_CONNECTION_STRING"

Using pip

Alternatively, you can install mcp-server-waii via pip:

pip install mcp-server-waii

After installation, you can run it as a module:

python -m mcp_server_waii \
  --url "YOUR_WAII_URL" \
  --api-key "YOUR_API_KEY" \
  --database-key "YOUR_DATABASE_CONNECTION_STRING"

Requirements

  • Python 3.10 or higher
  • A WAII account with API access
  • Database credentials supported by WAII

Configuration

Configure for Claude.app

There are several ways to configure the server for Claude:

{
    "mcpServers": {
        "waii": {
            "command": "uvx",
            "args": [
                "mcp_server_waii",
                "--url",
                "YOUR_WAII_URL",
                "--api-key",
                "YOUR_API_KEY",
                "--database-key",
                "YOUR_DATABASE_CONNECTION_STRING"
            ]
        }
    }
}

2. Using Python installation

{
    "mcpServers": {
        "waii": {
            "command": "python",
            "args": [
                "-m",
                "mcp_server_waii",
                "--url",
                "YOUR_WAII_URL",
                "--api-key",
                "YOUR_API_KEY",
                "--database-key",
                "YOUR_DATABASE_CONNECTION_STRING"
            ]
        }
    }
}

Example Values:

  • YOUR_WAII_URL: e.g., "http://WAII_URL/api/"
  • YOUR_API_KEY: Your WAII API key
  • YOUR_DATABASE_CONNECTION_STRING: e.g., "snowflake://USER@HOST/DB?role=ROLE&warehouse=WAREHOUSE"

Features

  • Natural language to SQL conversion
  • Database schema understanding and management
  • Query execution and result formatting
  • Automatic query optimization suggestions
  • Data visualization capabilities

Development

To set up the development environment:

  1. Clone the repository
git clone https://github.com/waii-ai/mcp-server-waii.git
cd mcp-server-waii
  1. Install in development mode:
uv pip install -e .

Support

For support:

  1. Check the GitHub Issues
  2. Contact WAII support for API-related questions
  3. Open a new issue if you find a bug

License

Apache License 2.0 - see LICENSE file for details.