execute_sqlite_query

Caution

This tool is experimental. The name, the arguments, or the behavior of this tool may change in the future.

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 temporary "main" database is used.
query	string	The SQL query to execute.
params	object	Bindings for the query.
schema	object	The DB schema declared in SQL language to create the database before inserting data and executing 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

Type: array

The result of the database query.