Myriade, the analytic agent for your database.

Benjamin Derville — Tue, 15 Jul 2025 14:42:18 +0000

Open-sourced today 🥳 — Myriade, the analytic agent for your database.

Connect your database (Postgres, Mysql, ...)
Ask in plain English (... or Mandarin)
Get SQL + charts back in seconds.

Check it out :
https://github.com/myriade-ai/myriade

It's free, but you will need your own Anthropic apikey.

git clone https://github.com/myriade-ai/myriade.git
docker compose pull
ANTHROPIC_API_KEY=XXXX docker compose up -d

Open-sourced today — Myriade, the analytic agent for your database. 1. Connect your database (Postgres, Mysql, ...) 2. Ask in plain English (... or Mandarin) 3. Get SQL + charts back in seconds. Check it out : https://github.com/myriade-ai/myriade

Benjamin Derville — Tue, 15 Jul 2025 14:40:00 +0000

Query Your SQL Database In English

Benjamin Derville — Wed, 18 Jun 2025 08:43:56 +0000

Disclaimer: I built Myriade (and I love it ^^)

Let’s be honest: writing SQL can feel like a chore — tedious and tricky.
Have you ever dreamed of using ChatGPT on your database?
That’s exactly what Myriade lets you do.

What’s Myriade?

Myriade is an AI-powered tool designed to make database queries easy and intuitive.
It plugs directly into databases like Postgres, MySQL, Snowflake, or BigQuery.
It doesn’t just translate your questions into SQL; it actively explores, tries, corrects queries, adapts, reviews… and gets back to you with a synthesis report.

— no SQL needed.

Quick Start Guide

1. Connect Your Database

Start by hooking up your Postgres database to Myriade.
The connection is totally secure and strictly read-only, keeping your data safe and untouched.

Select your database type and fill your connection details

2. Just Ask in English

Simply type your query using everyday language.

For example:

“What were the sales figures last quarter?”
“Explain the decrease in user sign-ups yesterday.” You don’t even need to worry about field names or tables — Myriade figures that out for you.

3. Get Report

After you ask, Myriade transforms your plain-English question into SQL, fetches the data, and presents clear results as tables, graphs, or easy-to-understand insights.

Using a database about Formula 1

Safety First

Data security matters, so Myriade comes with built-in privacy:

Read-Only Mode: No chance of accidentally editing or losing data. Sample Only: The AI only reads a sample of the results (like a human would)
AI — Zero Data Retention: Nothing you query gets stored on the AI providers.
Zero Knowledge Protection: Advanced features to hide your sensitive data from AI providers.

Practical Examples of Using Myriade

Myriade isn’t just for basic queries. Here are some practical scenarios you can try:

Diagnose a Problem: “Why did sales drop on March 10?”
Find What’s Missing: “What key metrics aren’t in our monthly reports?”
Shape Your Data: “Make a quick table showing each user’s last purchase.”
Check Your Data Quality: “Spot any weird duplicates in billing data.”

With Myriade, interacting with your database feels less like coding and more like chatting.
Easy, intuitive, and even a little bit fun!
— myriade.ai.

Originally published on Medium

DEV Community: Benjamin Derville