📊 Vote for New Database Integrations for Wren AI

[wwwy3y3]

Hi everyone,

We’re excited to gather your input on which database integrations you’d like to see next in WrenAI! Your feedback is crucial in helping us prioritize and focus on what’s most valuable for our community.

Please take a moment to review the list of potential database integrations below and vote for the ones you find most useful. If you have any additional suggestions, feel free to add them in the comments.

How to Vote:

Add a thumbs-up (👍) reaction to the comment(s) corresponding to the database integration(s) you support.
If you have a new suggestion, please add a new comment and describe the integration.

[cyyeh]

(Update) 0.8.0 has supported Trino (https://github.com/Canner/WrenAI/releases/tag/0.8.0)

ref: #223

[wwwy3y3]

Trino has been scheduled to be supported in the following releases as the forth priority, coming after MySQL, MS SQL Server & Clickhouse.

Thanks for everyone's feedback.

[ng22t7a]

can u tell when will trino be supported

[cyyeh]

@ng22t7a Trino is supported now

[chilijung]

@ng22t7a check docs here https://docs.getwren.ai/oss/guide/connect/trino

[cyyeh]

(Update) 0.6.0 has supported MS SQL Server (https://github.com/Canner/WrenAI/releases/tag/0.6.0)

MS SQL Server

ref: #173

[wwwy3y3]

MS SQL Server has been scheduled to be supported in the following releases as the second priority, coming after MySQL.

Thanks for everyone's feedback.

[cyyeh]

Guys, we now support MS SQL Server in our latest version! https://github.com/Canner/WrenAI/releases/tag/0.6.0
Please have a try and we look forward to your feedback ❤️

[cyyeh]

OracleDB

ref: #236

[Redhadjeridi]

any updates about the oracle DB?

[numberonewastefellow]

Basically oracle PR merged, but it doesn't support fully. couple of places oracle implementations are missed.

[chilijung]

This is supported in 0.23.0 version!

[cyyeh]

(Update) 0.5.0 has supported MySQL (https://github.com/Canner/WrenAI/releases/tag/0.5.0)

MySQL

ref: #313

[wwwy3y3]

MySQL has been scheduled to be supported in the next release as the first priority.

Thanks for everyone's feedback.

[onlyjackfrost]

Guys, we now support MySQL in our latest version! https://github.com/Canner/WrenAI/releases/tag/0.5.0
Have a try and thanks for all your's feedback ❤️

[jagomezdiez]

NO, Invalid value 'mysql'

[cyyeh]

Databricks SQL Database/Lakehouse

ref: #322

[federel]

is databricks sql in your roadmap?

[emilianomm]

Are you planning to integrate with databricks using sql jdbc/odbc drivers or integrate nativey with Unity Catalog?

[qdrddr]

Neo4J Knowledge Graph DB

It can serve as Vector DB, or as SQL alternative for table relational structured data using Cypher query language.
Making it ideal and notable candidate for AI use-cases such as WrenAI.

Models such as OpenAI/gpt3.5-turbo and ollama with these models
https://ollama.com/library/sqlcoder
https://ollama.com/library/codeqwen
https://ollama.com/library/starcoder2
https://ollama.com/library/llama3:8b-instruct

All are quite good at generating Cypher query with prompt like this:
cypher_generation_request4.txt

@cyyeh

[qdrddr]

Also I came across the idea of building a semantic search layer between LLM and Graph DB. I guess the idea is very similar to what WrenAI is already doing for SQL/Relational DB.

https://towardsdatascience.com/enhancing-interaction-between-language-models-and-graph-databases-via-a-semantic-layer-0a78ad3eba49

[qdrddr]

Its cool that FalkorDB also supports openCypher. It seams like Cypher become de-facto standard for Graph DB just like SQL.

[qdrddr]

there's another one, though it doesn't have Cypher, instead it supports its own "GraphQL-inspiered", which is a downside.
https://github.com/dgraph-io/dgraph

And also
https://github.com/surrealdb/surrealdb
https://github.com/janusgraph/janusgraph

[qdrddr]

SurrealDB seams to be most popular among these Graph Databases.
Also there's a very popular Supabase Database, it based on Postgresql with GraphQL extension support, though not fully fledged Graph Database.

https://star-history.com/#neo4j/neo4j&supabase/supabase&surrealdb/surrealdb&dgraph-io/dgraph&vesoft-inc/nebula&falkordb/falkordb&janusgraph/janusgraph&Timeline

[qdrddr]

Here's an idea for you for KGDB: at the modeling stage, based on data and schema generate in advance all possible (at least primitive) queries that are checked and working (returning at least one row), and save into Vector DB, so you can retrieve examples dynamically based on the prompt. @cyyeh

[thaddeuscleo]

Support for:

• Clickhouse

[thaddeuscleo]

Okay Sure, I'll update it @wwwy3y3

[qdrddr]

Actually, I do not see MySQL as an option anywhere else. @wwwy3y3

[wwwy3y3]

@qdrddr it's here -> #327 (comment)

[wwwy3y3]

Clickhouse has been scheduled to be supported in the following releases as the third priority, coming after MySQL & MS SQL Server.

Thanks for everyone's feedback.

[maincrouser]

How can I use the ClickHouse connection with an SSL certificate? There is an option to enable SSL, but no possibility to choose a certificate.

[fabricebaranski]

Apache Druid

[MasaruKitajima]

MongoDB support will be appreciated.

[HelenGuohx]

Snowflake

[ongdisheng]

@HelenGuohx Snowflake is supported now, you may check the docs here.

[qdrddr]

Supabase DB

[qdrddr]

FalkorDB Graph DB

[qdrddr]

SurrealDB Graph DB

[qdrddr]

Nebula Graph DB

[vietnguyengit]

ZARR store, https://zarr.readthedocs.io/en/stable/getting_started.html

[wwwy3y3]

@vietnguyengit thanks for the feedback! It's the first time I've heard of ZARR.

Could you let us know how you use ZARR store and why you think it's important to support? thanks!

[leap233]

Apache Doris
please !!!

[tmotyl]

SQLite

[mesbahkhan]

InfluxDB

[ijtarano]

Dremio MCP https://github.com/dremio/dremio-mcp/tree/main

[nhtha]

Hello everyone,
Any plan for full-text-search solutions (eg. ELK) support?
Regards,
Ha Nguyen

[abdelhameedhamdy]

SQLite

[tmotyl]

aleady requested #327 (comment)

[JinCheng666]

达梦数据库管理系统 DM8

[oankit]

Salesforce

[oankit]

Databricks

[brunabaldasso98]

Cognite

[shanebelgal1992]

Redshift

[deepaksaipendyala]

MongoDB

[vinay-berrydb]

Mongo support has already been requested, by doing a simple find in page(ctrl+f) before posting you would have known.

[deepaksaipendyala]

Thank you for doing ctrl+f, much appreciated.

[vinay-berrydb]

Couchbase

[k-alnuaimi]

Azure Log Analytics

[kalatalo]

Intersystems IRIS