Logo and icon for Definitive Facts, a ChatGPT plugin with description: Ask questions using 100+ relational datasets - sports, finance, and more at https://definitive.io/datasets.
. Find out more on Plugin Surf, the best plugin database.

Definitive Facts

Ask questions using 100+ relational datasets - sports, finance, and more at https://definitive.io/datasets.

Definitive Facts plugin generates and executes SQL queries against various relational datasets through natural language text input. It supports more than 100 datasets related to sports, finance, etc. You can ask questions and receive definitive facts for your queries. Do not send SQL to the generate-SQL endpoint and execute only the SQL generated by this endpoint. It shows the SQL text to the user while generating. The execution result comes in Python pandas compatible JSON format, which you can download using the URL shown in execution result. Try Definitive Facts and get accurate data with ease!

Learn how to use Definitive Facts effectively! Here are a few example prompts, tips, and the documentation of available commands.

Example prompts

  1. Prompt 1: "Find datasets related to climate change research."

  2. Prompt 2: "Generate a SQL query based on this natural language question: 'What are the top-selling products in the past year?'"

  3. Prompt 3: "Execute this SQL query and provide the result: 'SELECT * FROM sales_data WHERE date >= '2022-01-01''"

  4. Prompt 4: "Can you generate a natural language response to this question: 'What is the average price of products in category XYZ?'"

  5. Prompt 5: "Poll the result of a SQL query execution with execution ID '12345' and retrieve the JSON format."

Features and commands

Feature/CommandDescription
find_datasetsThis command allows you to find datasets that may help answer a natural language question. You need to provide the question and it will return the matching dataset IDs.
generate_sqlThis command generates a SQL query or a natural language response based on a provided natural language question. You can also specify a dataset ID if necessary. It returns a task ID that can be used to retrieve the result.
execute_sqlThis command executes a provided SQL query and returns the execution ID for the result. You need to provide the SQL and the dataset ID.
poll_generate_sql_resultThis command is used to poll the result of a generated SQL query. It should be called repeatedly until the result is ready. You need to provide the task ID. It returns the result of the generate-sql endpoint.
poll_execute_sql_resultThis command is used to poll the result of an executed SQL query. It should be called repeatedly until the result is ready. You need to provide the execution ID and the desired format (urls, md, or json). It returns the result of the execute-sql endpoint, or a list of URLs if the format is 'urls'.

Configuration

User authenticationWith API key
API documentation

For AI

Namedefinitive_facts
Descriptiondefinitive facts for generating and executing sql queries against relational datasets. only send natural language text to the generate-sql endpoint. only send sql to the execute-sql endpoint. only execute sql generated by the generate-sql endpoint. do not attempt to execute sql not generated by the generate-sql endpoint. when generating sql, show the sql text to the user. prefer showing the url of sql execution result to the user. they might want to download it. the execution result in JSON format is python pandas compatible. remind the user of this.

Updates

First added20 June 2023

Similar plugins