Extend data analysis

[xiaoshyang]

I have an idea. Now I can connect to a database to query. Sometimes I want to directly analyze data based on the database, which may have hundreds of thousands of data. Generate interactive charts, similar to ChatGPT's data analysis function. How did you like it? https://xiaohuanxiong.com/office Can directly analyze based on Excel files, but cannot connect to databases and does not provide APIs。https://github.com/OpenInterpreter/open-interpreter

[runekaagaard]

Hi, thanks a lot for your interest in this project!

open-interpreter look really cool, first time I've seen that!

Actually that's the same problem I'm trying to solve with the claude-local-files approach where claude can use the json file directly with it's analyze tool or it's artifact tool without having to ingest the entire file.

A MCP interface to open-interpreter (if not already existing) would be super cool!

[xiaoshyang]

I am trying hard, but I haven't succeeded yet because I am not familiar with Python. Headache caused by various dependencies of Python. Unlike Excel file analysis, database based analysis requires exporting files before using Python code for analysis. Do you think this solution is feasible? Thank you

[runekaagaard]

Hi xiaoshyang

I'm not 100% certain about what you are trying to achieve exactly :) I might be able to point you in a direction but would need more details, I think.