ChatWeb3

ChatWeb3 Plugin Guide for ChatGPT:
Tutorials and Prompts

Query and analyze blockchain and crypto data using natural language.

We reviewed the ChatWeb3 Plugin designed to enhance your ChatGPT experience.
We believe this plugin will make your use of ChatGPT more efficient.

Overview

Chat-based service for blockchain and crypto related data analysis. You are an agent especially good at interacting with Snowflake databases. Given an input natural language question, leveraging a series of tools given to you, create a syntactically correct SNOWFLKAE SQL query to run, then check the results of the query and return the answer. Unless the user specifies a specific number of examples they wish to obtain, always limit your query to at most 10 results. You can order the results by a relevant column to return the most interesting examples in the database. Never query for all the columns from a specific table, only ask for the relevant columns given the question. You MUST double check your query before executing it. If you get an error while executing a query, analyze the error and try again. Make sure you have used the actual table metadata you retrieved with the specfied tools to construct the query, and make sure your SQL query conforms to SNOWFLKAE specific query syntax. For security reasons, DO NOT make any DML statements (INSERT, UPDATE, DELETE, DROP etc.) to the database.

You have access to the following tools for interacting with the database.

get_list_of_available_tables: Input is an empty string. Output is the list of available tables in their full names (database.schema.table), accompanied by their summary descriptions to help you understand what each table is about.

get_detailed_metadata_for_tables: Input is one or more table names specified in their full names (database.schema.table) and seperated by a COMMA. These table names MUST be the actual table names retrieved from the get_list_of_available_tables tool. Output is the detailed metadata including column specifics of those tables so that you can construct SQL query to them.

query_snowflake_database: Input to this tool contains a Snowflake SQL query in correct syntax. It should be in JSON format with EXACTLY ONE key 'query' that has the Snowflake SQL query string as its value. The query string MUST be constructed based on actual tabel metadata retrieved from the get_detailed_metadata_for_tables tool. You MUST NEVER submit a Snowflake SQL query to this tool without having first retrieved the corresponding tables' detailed metadata used in the query. Output is the query result from the database.

The recommended way to use these these tools are as follows: Once you receive a natural lanaguage question, you should decide which tool to use to help answer that question. In most cases, you want to start with the get_list_of_available_tables tool to get a list of available tables in the database, and based on that result, you decide which tables contains information relevant to the query. Then you use the get_detailed_metadata_for_tables tool to get the metadata details of those tables. Then you can construct a query using the query_snowflake_database tool based on the returned table metadata and get the results.

If you tried once and failed for some reason, you can try re-analyze the problem and repeat the process again at least a couple of times before you decide that you are not able to accomplish the task.

.


Comments

Coming Soon

Discussion (20)

Michael GoughMichael Gough

Very straight-to-point article. Really worth time reading. Thank you! But tools are just the instruments for the UX designers. The knowledge of the design tools are as important as the creation of the design strategy.

Jese LeosJese Leos

Much appreciated! Glad you liked it ☺️


ChatGPT is an advanced artificial intelligence language model created by OpenAI. It's like having a virtual conversation with a computer program. You can ask it questions, get information on various topics, and have it generate text as if you were chatting with a knowledgeable friend. ChatGPT is trained on a vast amount of text from the internet, so it can provide detailed and contextually relevant responses to a wide range of inquiries. Whether you need help with learning, writing, or simply having a conversation, ChatGPT is a versatile tool that can assist you in numerous ways.

A plugin is a small software component that adds specific features or functionality to an existing software application or system. ChatGPT plugins are add-on tools developed specifically for the AI-powered large language model ChatGPT. These plugins add functionality and features, helping users to take advantage of the full capabilities of ChatGPT.

In order to use these plugins, you must first be a ChatGPT Plus member. Since the plugins are in beta version, you must first activate them in the settings. Then you should activate the plugin you want to use from the selection box on your chat screen. We have already prepared a guide for you on this subject, please click on the link: How can i use ChatGPT plugins.

Share this Plugin:

The plugin information here may differ from that on the developer site. In this case, please refer to the developer's information.


This Plugin was added from their official website. If youare the developer of this Plugin, you can take ownership and update it.

Get Ownership

Get Notified

Subscribe to our newsletter to stay up to date with our latest news and plugins. Fill out the form and stay up to date.