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

Hey HN! Maybe I’m crazy because I’ve been tinkering with this since GPT-3 era... but today, I’m thrilled to share Myriade with you.

As a data guy, I’ve always been frustrated by the effort involved in answering simple questions. Not that SQL is hard, but a simple question can easily require 10+ queries and 1h+ of our time.

Which means it’s not worth doing - more often than not.

Myriade is a natural language interface to analyze your database, which allows you to get answers in seconds/minutes, not hours.

Live Demo: https://hn.myriade.ai (explore HN data!)

Repository: https://github.com/myriade-ai/myriade

What it does:

- Ask "Why was there a drop in sales on July 14?” instead of writing JOIN statements

- The data analyst agent will explore, try, correct, adapt, inspect, analyze & synthetize a response… beyond the classical NL2SQL.

- See the agent's full interaction and “take over” at any moment.

- Works with Postgres, MySQL, Snowflake, BigQuery

- Self-hostable (so you can control where your data goes)

Under the hood

- Developed my own agent library for this (https://github.com/BenderV/autochat)

- Uses Anthropic Claude (also compatible with OpenAI and others)

- Postgres/Flask/SQLAlchemy/Vue/Tailwind/Echarts

I’ve used it a lot, and it shows great potential that goes beyond just “getting information”.

Interesting use cases I've seen:

- “What KPIs should I focus on ?” → Select your KPIs

- “Detect quality issues in billing data" → Review data quality

- “Flatten this table” → Prepare a view

- “Make this query run faster: X” → Optimize a query

This clearly is not the one-size-fits-all solution to solve BI, but I find it really useful for day to day.

Try it for yourself - let me know what you think! I’d love to get any feedback, feature requests and (especially) criticism you may have!