Show HN: Myriade – Ask your database questions in plain English

3 months ago 4

Myriade is the secure AI analytics copilot for your database.

Query any database in natural language, inspect every SQL the agent runs, and get instant, actionable insights.

output

👉👉👉 Live Demo 👈👈👈

Traditional BI tools still require you to think about tables, joins, and SQL before you get to insight.

Myriade removes all that friction with an AI‑native chat interface that reads your question, explores your database safely in read‑only mode, writes and refines SQL, analyses the result set, and surfaces the answer—all in seconds.

  • 10× faster answers – let the agent do the heavy lifting (schema exploration, SQL generation, result analysis, etc.).
  • 🔒 Secure by design – read‑only, limited previews, zero knowledge protection, ...
  • 🧠 Beyond NL2SQL – root‑cause analysis, anomaly detection, opportunity discovery, ...
  • 🏗️ Extensible – works with Postgres, MySQL, Snowflake, BigQuery & more to come.
  • Local hosting – Install Myriade on your own hardware.
  • Read‑only – Myriade never mutates your production data (opt‑in).
  • Limited result preview – the agent sees row samples & column stats, not full dumps.
  • Zero‑Knowledge Protection – encrypt sensitive data before sending it to the LLM (opt‑in, beta).
  • Simple set up – Run Myriade locally in < 5 minutes.
  • Natural‑language chat – to query your data database.
  • AI ↔️ DB trace viewer – so you can inspect every query the agent runs.
  • SQL editor – take over and edit the SQL the agent generates.
  • Prompt templates ("Projects") – to tailor the agent to a domain or KPI set.
  • Data Quality control panel – (coming soon).
Ask… Myriade does…
"Why did sales drop on 2025‑03‑10?" scans fact tables, runs cohort diffs, returns root causes
"Create a view of user_id, total_sales, last_product_bought" generates SQL, saves the view, returns preview
"What KPIs are missing in the store report?" reviews schema, suggests additional metrics

This will help you run Myriade locally, without the user management support.

At this time, we recommend using Anthropic to get the best results. Get an Anthropic API key if you don't have one here.

Note: you can also use any other LLM provider (OpenAI, Gemini, etc.). Check the docker-compose.yml file for the available environment variables.

git clone --depth 1 https://github.com/myriade-ai/myriade.git cd myriade docker compose pull ANTHROPIC_API_KEY=XXXX docker compose up -d
docker compose pull AUTOCHAT_PROVIDER=openai AUTOCHAT_MODEL="o4-mini" OPENAI_API_KEY=XXXX docker compose up -d

Connect your database & profit

If you're a developer looking to modify Myriade or set up a local development environment, follow the instructions in DEVELOPMENT.md.

Read Entire Article