Logo and icon for Chat With Your Data, a ChatGPT plugin with description: Conversational analysis over your databases and spreadsheets.. Find out more on Plugin Surf, the best plugin database.

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.

Learn how to use Chat With Your Data effectively! Here are a few example prompts, tips, and the documentation of available commands.

Example prompts

  1. Prompt 1: "Perform analysis on databases and spreadsheets."

Features and commands

Feature/CommandDescription
get_available_sourcesThis command provides the sources available for querying data. It returns a list of available data sources with their names, descriptions, and IDs.
linkDBThis 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.
linkSheetThis command allows you to link a Google Sheet to the conversation. You need to provide the name, purpose, and URL of the sheet.
manipulateSheetThis 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.
queryDBThis 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_sourceThis command updates the active data source for the conversation. You need to provide the ID of the data source to set as active.
updateSourceThis 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.

Configuration

User authenticationOAuth2
API documentation

For AI

Namechat_with_data
DescriptionPerform analysis on databases and spreadsheets.

Updates

First added26 June 2023

Similar plugins