waii MCP Server

Use This MCP server To

Execute database queries using natural language commands Retrieve and summarize database content for reports Integrate database querying into AI workflows Enable LLMs to update or modify database entries Automate data extraction from databases for analysis Provide conversational database access in applications

README

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.

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

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:

Clone the repository

git clone https://github.com/waii-ai/mcp-server-waii.git
cd mcp-server-waii

Install in development mode:

uv pip install -e .

Support

For support:

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

License

Apache License 2.0 - see LICENSE file for details.

waii-mcp-server FAQ

How do I connect the waii-mcp-server to my database?

Provide your database connection string as the 'database-key' argument during server startup.

What credentials are required to use the waii-mcp-server?

You need a WAII API key and your database connection string to authenticate and connect.

Can I run the waii-mcp-server without installation?

Yes, using uv or uvx you can run the server directly without additional installation steps.

What is the role of the WAII API endpoint URL?

The URL specifies the WAII API endpoint that the server uses to process natural language database queries.

Is the waii-mcp-server compatible with multiple database types?

Yes, as long as you provide a valid connection string, it supports various databases through WAII.

How does the server handle natural language queries?

It translates natural language inputs into database queries via WAII's interface for execution.

Can I use the waii-mcp-server with different LLM providers?

Yes, it is designed to work with models like OpenAI, Claude, and Gemini by providing database context.

What security measures are in place for database access?

Access is secured using API keys and connection strings, ensuring authorized interactions only.