AgentSQL

About AgentSQL ChatGPT Plugin

Interact with your Snowflake databases or your csv files with ease using AgentSQL. Whether you're an experienced SQL developer or just starting out, this plugin is designed to simplify your database interactions. With AgentSQL, you can seamlessly query and retrieve data from your Snowflake databases or csv files directly within your chat.

AgentSQL provides a user-friendly interface that guides you through the process of querying your data. It automatically detects the type of data source you're using, whether it's csv files or a Snowflake database, and adjusts its behavior accordingly. For csv files, AgentSQL interacts only with the tables returned from the data source endpoint, displaying the file names instead of table names. On the other hand, for Snowflake databases, it prompts you to specify the database and tables you want to interact with before generating the queries.

To ensure compatibility with Snowflake, all queries generated by AgentSQL are compatible with the Snowflake database. It handles the database interaction on the plugin side, allowing you to focus on retrieving and analyzing the data. AgentSQL also provides a simple and intuitive table view format to present the query results, making it easy for you to understand and analyze the data.

Get started with AgentSQL today and streamline your database interactions within ChatGPT!

How to use AgentSQL ChatGPT Plugin

Returns the type of data source from the user

To determine the type of data source you're using, simply invoke the plugin with the following prompt: "Check my data source". AgentSQL will return whether you're working with csv files or a Snowflake database. If it's csv files, AgentSQL will interact only with the tables returned from this endpoint, displaying the file names instead of table names.

Sends whether user liked or disliked a generated query

After AgentSQL generates a query, you can provide feedback on whether you liked or disliked the query. Use the following prompt to send your feedback: "I like this query" or "I dislike this query". This feedback helps AgentSQL improve its query generation and provide more accurate results in the future.

Generates a Snowflake query based on the user input

AgentSQL simplifies the process of generating Snowflake queries based on your input. To generate a query, provide the necessary details such as the database, schema, and table name. For example, you can use the prompt: "Generate a query for database 'my_database', schema 'my_schema', and table 'my_table'". AgentSQL will handle the database interaction on the plugin side and generate the appropriate Snowflake query.

Returns a schema from the Snowflake database based on a table name

If you need to retrieve the schema associated with a table in your Snowflake database, you can use AgentSQL to fetch the schema. Simply provide the table name in the prompt, for example: "Get the schema for table 'my_table'". AgentSQL will return the schema associated with the specified table.

Start using AgentSQL today to simplify your database interactions and retrieve valuable insights from your Snowflake databases or csv files within ChatGPT!