Waii MCP Server

🚀 WAII MCP Server

A Model Context Protocol (MCP) server that provides database interaction capabilities through WAII. This server enables language models to interact with databases, execute queries, and process database content using natural language.

🚀 Quick Start

The WAII MCP Server allows language models to interact with databases using natural language. Here's how you can get started.

✨ Features

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

📦 Installation

Using uv/uvx (Recommended)

Using uv/uvx doesn't require any specific installation. You can directly run the server:

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"

💻 Usage Examples

Available Tools

Database

Interact with the database through WAII's natural language interface.

Parameters:

📚 Documentation

Requirements

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

Configuration for Claude.app

There are several ways to configure the server for use with Claude:

1. Using uvx (Recommended)

{
    "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: For example, "http://WAII_URL/api/"
• YOUR_API_KEY: Your WAII API key
• YOUR_DATABASE_CONNECTION_STRING: For example, "snowflake://USER@HOST/DB?role=ROLE&warehouse=WAREHOUSE"

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

2. Install in development mode:

uv pip install -e .

Support

To seek help:

1. Check GitHub issues
2. Contact WAII support for API-related issue resolution
3. Submit a new issue when you find a bug

📄 License

Apache License 2.0 - See the LICENSE file for details.