Chat With Your Data
Conversational analysis over your databases and spreadsheets.
The Chat With Your Data plugin allows you to easily analyze your databases and spreadsheets through a text-based chat interface. With this plugin, you can ask questions in natural language and get insights in seconds, without having to navigate complex data analysis software. Whether you're a business owner, marketer, or just someone who wants to get a better understanding of their data, Chat With Your Data makes it easy and accessible. Plus, with interactive visualizations, you can quickly see patterns and trends in your data. Say goodbye to confusing spreadsheets and hello to data insights with Chat With Your Data.
How to
Comments (0)
API docs
Learn how to use Chat With Your Data effectively! Here are a few example prompts, tips, and the documentation of available commands.
Example prompts
- Prompt 1: "Perform analysis on databases and spreadsheets."
Features and commands
| Feature/Command | Description |
|---|---|
get_available_sources | This command provides the sources available for querying data. It returns a list of available data sources with their names, descriptions, and IDs. |
linkDB | This command allows you to link a database to the conversation. You need to provide the connection string for the database in the format dbtype://user:password@host:port/dbname, as well as a name and description for the database. |
linkSheet | This command allows you to link a Google Sheet to the conversation. You need to provide the name, purpose, and URL of the sheet. |
manipulateSheet | This command allows you to run Python Pandas queries on the linked sheet. You need to provide the query code, which should modify the DataFrame (df=[...]), and specify any outputs (output=...) that need to be converted to markdown. This command can generate both plots and tables, and can also export data. |
queryDB | This command allows you to run read-only queries on the linked database. You need to provide the query code, formatted as a valid SQL query. This command can provide data or plots as output. |
update_conversation_active_data_source | This command updates the active data source for the conversation. You need to provide the ID of the data source to set as active. |
updateSource | This command allows you to update the connection string and metadata for a data source. You need to provide the data source ID, connection string, data type (either "database" or "google_sheet"), name, and purpose. |