What is Waii Mcp Server

waii-mcp-server is a Model Context Protocol server that facilitates database interactions through WAII, allowing Language Models to execute queries and process database content using natural language.

Use cases

Use cases include building chatbots that can query databases, developing applications that require user-friendly database access, and enhancing data retrieval processes in business intelligence tools.

How to use

To use waii-mcp-server, you can run it directly using ‘uv’ or ‘uvx’ without specific installation. Alternatively, you can install it via pip and run it as a module by providing your WAII API endpoint URL, API key, and database connection string.

Key features

Key features include natural language interface for database interaction, support for executing queries, and the ability to process database content seamlessly with Language Models.

Where to use

waii-mcp-server can be used in various fields such as data analysis, natural language processing, application development, and any domain requiring database interactions through conversational interfaces.

WAII MCP Server

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.

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

Using uv/uvx (recommended)

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:

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: 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

2. 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.