Class DatabaseToolOptions
Configuration options shared by all database tools.
public sealed class DatabaseToolOptions
- Inheritance
-
DatabaseToolOptions
- Inherited Members
Properties
- AllowDdl
Gets or sets whether DDL statements (CREATE, DROP, ALTER, REINDEX) are allowed in the execute tool. Default is
true.
- AllowWrite
Gets or sets whether write operations (INSERT, UPDATE, DELETE, CREATE, etc.) are allowed. Default is
falsefor safety. Set totrueto enable the execute, import, and vacuum tools.
- AllowedPaths
Gets or sets allowed paths for database files. When set, only database files within these directories are accessible.
nullor empty allows all paths.
- BlockedKeywords
Gets or sets SQL keywords that are always blocked regardless of other settings. Default blocks ATTACH, DETACH, and LOAD_EXTENSION for security.
- BlockedPaths
Gets or sets blocked paths for database files. Database files within these directories cannot be accessed.
- CommandTimeoutSeconds
Gets or sets the command timeout in seconds. Default is 30.
- MaxDatabaseSize
Gets or sets the maximum database file size in bytes. Operations on databases exceeding this size are rejected. Default is 100 MB. Set to 0 for unlimited.
- MaxRows
Gets or sets the maximum number of rows returned by query and export operations. Default is 1000. Set to 0 for unlimited.