Execute SQL on temporary sqlite database created in memory. The tool is good for complex data manipulation and calculations. It can work as calculator or calendar. Use this tool only if explicitly asked by the user.
Arguments
Name
Type
Description
database
string
Permanent database to execute the query on. By default, the "main" database is used.
query
string
The SQL query to execute.
params
object
Bindings for the query.
data
object
Data to insert to the database before query execution. The data should
be provided as object where key is a name of table and value is an
array of objects
output
any
Where to output the result (default is result).
tool
string
Tool to execute for each record.
args
object
Arguments for the tool.
sleep
number
Sleep time between the cycle iterations in seconds. Default value is 1.