📊 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

[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 ❤️

[cyyeh]

Databricks SQL Database/Lakehouse

ref: #322

[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

[wwwy3y3]

Hi @thaddeuscleo thanks for the suggestion. Since we already got MySQL as an option above, could we only keep Clickhouse in this comment ?

Thanks.

[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.

[fabricebaranski]

Apache Druid

[MasaruKitajima]

MongoDB support will be appreciated.

[HelenGuohx]

Snowflake

[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!

[imtarundhiman]

MongoDB

[ragingbal]

Apache Doris

[prav3929]

Teradata

[tomthebuzz]

Doris &
DB2

[mayurp-yb]

Support for YugabyteDB

[SurenderSardana99]

Databrick Sql

[SurenderSardana99]

Any Data base without ER

[AnishNair94]

Apache Pinot.

Using pinot as olap store and for user facing reporting interface. Wren AI will be really awesome tool to integrate with User Reporting Interface @cyyeh

[samantagupta29]

AWS Athena

[avirup48]

Snowflake

[johnfelipe]

SAP
SAP Ariba Procurement
SAP Ariba Source
SAP Business One
Business Objects BI
SAP ByDesign
SAP Concur
SAP Fieldglass
SAP Gateway
SAP HANA
SAP HANA XS Advanced
SAP Hybris C4C
SAP Netweaver Gateway
SAP SuccessFactors

[MGomaa435]

Add support to generic database driver, and also adding different data virtualization connectors like tibco data virtualization and, denodo.

[axoxymous-coder]

Amazon Redshift