# Myriade — AI SQL Agent

> Autonomous AI SQL agent that writes, explains and validates SQL on your warehouse from natural-language questions. Cited answers, schema-aware, read-only by default.

## What it is

An AI SQL agent that reasons about your schema, writes valid SQL from natural-language questions, validates the result against cited tables, and explains its work. Every query is auditable. You see the SQL before the result and can edit it.

Unlike simple text-to-SQL tools, the Myriade SQL agent reasons iteratively, handles multi-table joins, cohort comparisons, and window functions — and asks follow-up questions when needed.

## Key capabilities

- Natural-language to SQL with citations
- Schema-aware reasoning
- Iterative refinement (follow-up questions)
- Multi-table joins, window functions, cohort comparisons
- Read-only warehouse access by default
- Sensitive-field masking and governance

## What warehouses are supported

Snowflake, BigQuery, Databricks, Postgres, Oracle, MySQL, Redshift, Microsoft Fabric and others.

## How it's different from text-to-SQL tools

- Reasons about schema rather than translating line-by-line
- Asks clarifying questions instead of fabricating answers
- Cites tables and columns used
- Validates results against the source data
- Works across multiple warehouses in a single query

## Security

- Read-only by default
- Automatic masking of sensitive fields (zero-knowledge protection)
- Zero data retention with LLM providers
- RBAC, SSO, audit logs
- Self-hosted or VPC on Business and Enterprise

## MCP

Myriade exposes an MCP server so Claude, Cursor and other LLM clients can query your governed data directly — outside the Myriade UI — using the same SQL agent and governance.

## Links

- Product page: https://www.myriade.ai/ai-sql-agent
- NL2SQL deep dive: https://www.myriade.ai/nl2sql
- Security: https://www.myriade.ai/security
- Pricing: https://www.myriade.ai/pricing
- Global llms.txt: https://www.myriade.ai/llms.txt