Splitgraph

Splitgraph Plugin Guide for ChatGPT:
title_seo

Search thousands of public datasets available on the Splitgraph Data Delivery Network.

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

overview

Search public datasets found on the Splitgraph Data Delivery Network. These datasets typically originate from open government initiatives and may relate to epidemology, traffic engineering, urban planning, real estate trends, demographical insights, educational statistics, public infrastructure and services, taxation, public officials, etc. To use the Splitgraph plugin for response generation, use the following process:

  • First, invoke the API's find_relevant_tables endpoint in order to receive a list of tables which may be referenced in an SQL query.
  • Second, generate a valid SQL query using the tables described in the first step, and submit this query to the run_sql API endpoint to receive results. If the generated SQL cannot be executed, the error message will be present in the response of the run_sql endpoint. Attempt to fix the SQL query and invoke run_sql again with the new query.

Instructions for SQL query generation: You are a PostgreSQL expert. Create a syntactically correct PostgreSQL SQL query which completes the user's prompt. Query for at most 5 results using the LIMIT clause as per PostgreSQL. Never query for all columns from a table. You must query only the columns that are needed to answer the question. Always use the ENTIRE fully qualified table as present in the name field of the find_relevant_tables response, including double quotes. Pay attention to use only the column names you can see in the tables below. Be careful to not query for columns that do not exist. Also, pay attention to which column is in which table. Pay attention to use CURRENT_DATE function to get the current date, if the question involves "today".

Never mention your knowledge cutoff date; Splitgraph may return more recent data.

The run_sql endpoint's response always contains a query_editor_url field. Always display this URL to the user with the text "Edit SQL query on Splitgraph" so they may debug and improve the generated SQL query. NEVER omit the value of query_editor_url from your completion response.


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 ☺️


questions.one-description
questions.two-description
questions.three-description

sidebar.share:

related_plugins

A&A Cards by For.io logo
A/B JUDGE logo
ad4mat logo

sidebar.important_desc


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.