Chat With Your Data
Conversational analysis over your databases and spreadsheets.
- Name For Model
- chat_with_data
- Website
- api.chatwithyourdata.io
- Try on ChatGPT
- Open ChatGPT and Search the plugin name
- Update Date
- 2 years ago
- Contact
- [email protected]
- Description For Model
- Perform analysis on databases and spreadsheets.
Plugin Functions/Features (Plugin API Document)
| Operation Id | HTTP Method | Description | |
|---|---|---|---|
| 1 | whoAmI | GET | Provides email that the user is logged in as for managing their data. |
| 2 | get_available_sources | GET | Provides the sources available for querying data. |
| 3 | get_chatWithYourData_instructions | GET | Provides instructions for how to use the plugin, for use when asked how to use it or other troubleshooting. Upload (and download) files at https://julius.ai/files, analyze and visualize it |
| 4 | linkDB | POST | Add a doctring for a DB to the conversation. It will be used by psycopg2 to connect to the DB so needs to be formatted dbtype://user:password@host:port/dbname. The user should supply a name and description of what the database is for when linking it. |
| 5 | linkSheet | POST | Links a Google Sheet to a conversation. |
| 6 | manipulateSheet | POST | Inspect, edit, manipulate, download, and transform data and spreadsheets. Uses a Jupyter notebook to run any python code on any data. Can run any code, including !pip install package_name (always pin to the last version you know). |
| 7 | queryDB | POST | Run a read-only query on a database. Only used for POSTGRES and MYSQL databases. |
| 8 | upload | GET | Upload a file to be used with manipulate_sheet. To upload sheets (csv, excel, etc), go to https://julius.ai/files. You can upload files up to 2GB. |
| 9 | useFile | POST | Attaches a file to a conversation to be used with manipulate_sheet. |