Find answers from the community

Updated 3 months ago

Hi! I have GPTVectorStoreIndex.from_

Hi! I have GPTVectorStoreIndex.from_documents index and it works great. I want to add my database to that index and retrieve data from database on user query if needed. I use mysql DB. I can not find any working examples for mysql.

4 comments

MMillianz

Have you seen this guide yet? https://docs.llamaindex.ai/en/stable/examples/index_structs/struct_indices/duckdb_sql_query.html#basic-text-to-sql-with-our-nlsqltablequeryengine

zzloy_admin

Hi. One moment

zzloy_admin

Yeah, I saw it, and it's not clear how to implement it, in that example I see it uses DB in memory, but in my case I want to use remote MySql DB connection

MMillianz

When you create the engine you can point it at a remote db. for example:

Plain Text

  ar = AthenaReader()
  engine = ar.create_athena_engine(
    aws_region=aws_region,
    s3_staging_dir=aws_s3_staging_dir,
    database=database,
    workgroup=workgroup
  )

Add a reply