Chat With Your Data

Chat With Your Data

Conversational analysis over your databases and spreadsheets.

Name For Model
chat_with_data
Update Date
6 months ago
Description For Model
Perform analysis on databases and spreadsheets.

Plugin Functions/Features (Plugin API Document)

Operation IdHTTP MethodDescription
1whoAmIGETProvides email that the user is logged in as for managing their data.
2get_available_sourcesGETProvides the sources available for querying data.
3get_chatWithYourData_instructionsGETProvides 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
4linkDBPOSTAdd 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.
5linkSheetPOSTLinks a Google Sheet to a conversation.
6manipulateSheetPOSTInspect, 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).
7queryDBPOSTRun a read-only query on a database. Only used for POSTGRES and MYSQL databases.
8uploadGETUpload 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.
9useFilePOSTAttaches a file to a conversation to be used with manipulate_sheet.