Waii favicon

Waii

Waii screenshot
Click to visit website
Feature this AI

About

Waii is an AI-powered tool that translates plain English into SQL queries. It boasts 95%+ accuracy, optimizes queries for performance, and customizes SQL to match business needs. Waii supports various databases (Snowflake, PostgreSQL, MySQL, etc.) and handles complex queries with joins, aggregations, and window functions. It offers SaaS and self-hosted options with robust security features, including SSO and RBAC. Waii also includes a knowledge graph for improved accuracy and customization.

Platform
Web
Keywords
ainatural language processingsqldatabasetext-to-sql
Task
sql generation

Features

customized

performant

accurate

FAQs

Can I deploy Waii in my environment?

Yes, absolutely. We have Self-hosted, SaaS and hybrid deployments available, more [here](http://doc.waii.ai).

What does it take to trial Waii?

We have a trial setup with synthetic data you can use right away. If you have a database you want to test Waii with (recommended), we can get you set up in as little as 1-2 hours. If you have specific privacy requirements and want to integrate additional data sources or LLMs, we can give you a custom setup in just a few days.

What sets Waii apart from other text-2-sql vendors?

You can achieve the highest possible accuracy with Waii - with real-world workloads (1000s of tables, 20-way joins, semi-structured data, etc). You get the fastest answers with sophisticated caching and optimization techniques. All this while using the fewest tokens possible.The system is also truly enterprise ready, with all required security, governance, and operational capabilities you need.

How does Waii control access for each user?

Waii supports SSO, RBAC and pass-through authorization. You have control over what your users can access and change in Waii, they will see only the data and metadata they have access to. Row level access and column masking is supported as well.

How does Waii handle PII data?

Waii offers fine-grained control over what data it uses. You can make sure no PII data is touched. We also offer PII detection and access logs as additional guardrails.

What models do you support and recommend?

Depends on the complexity of the environment. For analytical workloads with many tables and complex queries, we recommend models with high reasoning capabilities: Typically OpenAI's GPT-4+ family, Anthropic Claude 3 Opus, or Gemini 1.5 ultra / pro. For less complex scenarios (simpler aggregates, more lookup-based queries, fewer tables), you can use smaller models: OpenAI GPT-3.5, Anthropic Claude 3 Sonnet, etc. For these cases OSS models can also achieve good results: E.g.: Llama 2/3, Mistral Large If you are dealing with one/few databases and the rate of change is slow, you can get more complex scenarios working on smaller models with appropriate fine tuning.

What data does Waii share with models?

That is controllable, minimum is schema information and context to understand the schema. Sharing some categorical data, structure of json / xml data is recommended to get better results.

Does it take a lot of data modeling and cataloging to use Waii?

No. At Waii we believe that the system should automatically make the most of the available information and give an incremental path to improvement. Many of our customers are using Waii on previously unknown databases and rely on the automatic generation of the knowledge graph to get good query results.

What databases does Waii support?

Snowflake, Postgres, MongoDB, Trino, Athena, Presto, Redshift, MySQL, SQLite and OSQuery at the moment. We are constantly adding more. If you don't see your database here, check in and see when it will be available.

What data catalogs and semantic layers does Waii support?

Waii supports Datahub, DBT, cube.dev, and OpenMetadata.org. We are constantly adding more. If you don't see your database here, check in and see when it will be available.

Do I need a dev team to deploy Waii?

No. While we are an API first company and make everything we do available to developers, we can give you access to a SQL builder and chat experiences without coding required.

What vector databases does Waii support?

Waii can use a wide variety of vector databases. By default we use Postgres/pg_vector, but can use any vector db you have already set up.

What is conversational intelligence and how does it relate to Waii?

Conversational intelligence or sometimes conversational BI or conversational analytics, is about gaining insights from data via natural language. It combines databases, visualizations and NLP to enable rapid analysis of complex datasets. That's at the heart of Waii, our API and tools are all tailor made to support this use case.

Does Waii need a snowflake or star schema to use Waii?

No. We are supporting customers and partners with a variety of different schemas. Star schemas and snowflake schemas are common and supported, but highly normalized schemas and "raw" schemas with highly nested data models are supported as well.

Can Waii handle OLTP schemas?

Yes! Waii supports a variety of schema types and you can get high accuracy queries out of all of them.

Job Opportunities

There are currently no job postings for this AI tool.

Explore AI Career Opportunities

Social Media

Ratings & Reviews

No ratings available yet. Be the first to rate this tool!

Alternatives

text2sql favicon
text2sql

Let AI generate your SQL statements for you. Ask your question in natural language and let text2sql automatically generate the SQL for you.

View Details
SQLAI.ai favicon
SQLAI.ai

AI-powered SQL multi-tool for generating, fixing, explaining, and optimizing SQL queries and databases.

View Details
AI Query favicon
AI Query

Generate error-free SQL queries in seconds using simple English. Includes schema definition, SQL explanation, and various database support.

View Details
Text2SQL.ai favicon
Text2SQL.ai

AI-powered tool that converts natural language into optimized SQL queries for various databases.

View Details
Vanna.AI favicon
Vanna.AI

Vanna.AI uses AI to generate SQL queries from natural language questions, supporting various databases and offering flexible pricing options.

View Details
View All Alternatives

Featured Tools

Songmeaning favicon
Songmeaning

Songmeaning uses AI to reveal the stories and meanings behind song lyrics. It offers lyric translation and AI music generation.

View Details
Whisper Notes favicon
Whisper Notes

Offline AI speech-to-text transcription app using Whisper AI. Supports 80+ languages, audio file import, and offers lifetime access with a one-time purchase. Available for iOS and macOS.

View Details
GitGab favicon
GitGab

Connects Github repos and local files to AI models (ChatGPT, Claude, Gemini) for coding tasks like implementing features, finding bugs, writing docs, and optimization.

View Details
nuptials.ai favicon
nuptials.ai

nuptials.ai is an AI wedding planning partner, offering timeline planning, budget optimization, vendor matching, and a 24/7 planning assistant to help plan your perfect day.

View Details
Make-A-Craft favicon
Make-A-Craft

Make-A-Craft helps you discover craft ideas tailored to your child's age and interests, using materials you already have at home.

View Details
Pixelfox AI favicon
Pixelfox AI

Free online AI photo editor with comprehensive tools for image, face/body, and text. Features include background/object removal, upscaling, face swap, and AI image generation. No sign-up needed, unlimited use for free, fast results.

View Details
Smart Cookie Trivia favicon
Smart Cookie Trivia

Smart Cookie Trivia is a platform offering a wide variety of trivia questions across numerous categories to help users play trivia, explore different topics, and expand their knowledge.

View Details
Code2Docs favicon
Code2Docs

AI-powered code documentation generator. Integrates with GitHub. Automates creation of usage guides, API docs, and testing instructions.

View Details