File size: 1,144 Bytes
3d3d712 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 |
name: sql_pull_data
enabled: true
required: false
description: >-
Pull data from a SQL database.
This plugin takes user requests when obtaining data from database is explicitly mentioned.
Otherwise, confirm with the user if they want to pull data from this database.
The data from this database can only used for anomaly detection.
For example, df, description = sql_pull_data("pull data from time_series table").
parameters:
- name: query
type: str
required: true
description: >-
This is the query in natural language that the user wants to get data from database.
If any specific column or value is mentioned, make sure to include them in the query,
exactly in the right format or form.
returns:
- name: df
type: pandas.DataFrame
description: This is the dataframe containing the data from the database.
- name: description
type: str
description: This is a string describing the data pulled from the database.
configurations:
api_type: openai
api_base:
api_key:
api_version:
deployment_name:
sqlite_db_path: sqlite:///../../../../sample_data/anomaly_detection.db
|