SQLToolkit

A toolkit for executing SQL queries against various SQL databases.

This toolkit provides functionality to execute SQL queries with support
for read-only and read-write modes. It currently supports DuckDB and
SQLite, with extensibility for MySQL and other SQL databases.

Args:
database_path (Optional[str]): Path to the database file. If None,
uses an in-memory database. For DuckDB and SQLite, use ":memory:"
for in-memory or a file path for persistent storage.
(default: :obj:None)
database_type (Literal["duckdb", "sqlite"]): Type of database to use.
Currently supports "duckdb" and "sqlite".
(default: :obj:"duckdb")
read_only (bool, optional): If True, only SELECT queries are allowed.
Write operations (INSERT, UPDATE, DELETE, etc.) will be rejected.
(default: :obj:False)
timeout (Optional[float], optional): The timeout for database
operations in seconds. Defaults to 180 seconds if not specified.
(default: :obj:180.0)

Raises:
ValueError: If database_type is not supported.
ImportError: If required database driver is not installed.