About WAII MCP Server
WAII MCP Server lets language models work with databases through WAII’s natural-language interface, combining query execution with schema handling and result formatting.
Key features
- 01Natural-language to SQL conversion
- 02Database schema understanding
- 03Query execution and result formatting
- 04Query optimization suggestions
- 05Data visualization
Use cases
- 01Generate SQL from a natural-language request
- 02Inspect and manage database schemas
- 03Run queries and format their results
MCP support
It exposes a `database` tool to MCP clients for database interaction through WAII, using a database connection string, WAII API key, and endpoint URL.
Configuration
Local server config is the same for every client. Copy it into your client’s MCP config file.
We haven’t collected a package or remote endpoint for this server. Follow the instructions in the project README.
Tools
Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.
Details
From the project READMEWAII 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 stringapi-key(string, required): Your WAII API keyurl(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 keyYOUR_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.
Comments
New to MCP?
From what the protocol is to installing your first server, these answers cover most first questions.
An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.