Results of 1 - 10 of about 82 for mode (0.002 sec.)
- Dot Commands 11633
- Dot commands are available in the DuckDB CLI client. To use one of these commands, begin the line with a period ( . ) immediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, spac
...and files of attached databases .decimal_sep ⟨SEP⟩ Set the decimal separator used when rendering numbers. Only for duckbox mode .dump ⟨TABLE⟩ Render database content as SQL. TABLE is a LIKE pattern for the tables to dump .display_colors ⟨bold/underli...and echo on or off .edit Open an external text editor to edit a query. \e can be used as an alias. See the external editor mode section .excel Display the output of the next command in a spreadsheet. Equivalent to .once -x .exit ⟨CODE⟩ Exit this prog...ram with return-code CODE .headers ⟨on/off⟩ Turn display of headers on or off . Does not apply to duckbox mode .help ⟨-all⟩ ⟨PATTERN⟩ Show help text for PATTERN . Use .help shortcuts to display keyboard shortcuts .highlight ⟨on/off⟩... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- Agent Mode 11579
- New Agent mode was introduced in DuckDB 2.0. Agent mode renders the CLI's output for consumption by an AI coding agent rather than a human at a terminal. It produces compact Markdown tables with explicit result limits, machine-readable erro
...s information on stderr , so that an agent can run queries and reliably parse the results. For the motivation behind agent mode and a benchmark of its effect, see the “Agent Mode in the DuckDB CLI” blog post . Activating Agent Mode Agent mode is acti...(such as AI_AGENT ) is set. The standard output is not a terminal (for example, it is piped to another process). No output mode flag (such as -csv or -json ) was passed. You can also control agent mode explicitly: The -agent and -no-agent command lin...e arguments force the mode on or off. The DUCKDB_AGENT_MODE environment variable forces the mode on ( 1 ) or off ( 0 ). The command line flags take p... - https://man.mtool.work/duckdb/2.0/clients/cli/agent_mode.html
- Command Line Arguments 11538
- The table below summarizes DuckDB's command line options. To list all command line options, use the command: duckdb -help For a list of dot commands available in the CLI shell, see the Dot Commands page . Argument Description -agent Render
...output for an AI coding agent. See the Agent Mode page -ascii Set output mode to ascii -bail Stop after hitting an error -batch Force batch I/O -box Set output mode to box...-column Set output mode to column -cmd COMMAND Run COMMAND before reading stdin -connect [TYPE[:SECRET]] Connect to a remote database. The default...type is quack . A named secret can be provided after the type -c COMMAND Run COMMAND and exit -csv Set output mode to csv -dark-mode Use dark mode colors for syntax highlighting -echo Print commands before execution -f FILENAME Run the s... - https://man.mtool.work/duckdb/2.0/clients/cli/arguments.html
- Output Formats 11538
- The .mode dot command may be used to change the appearance of the tables returned in the terminal output. In addition to customizing the appearance, these modes have additional benefits. This can be useful for presenting DuckDB output elsew
...here by redirecting the terminal output to a file . Using the insert mode will build a series of SQL statements that can be used to insert the data at a later point. The markdown mode is particula...rly useful for building documentation and the latex mode is useful for writing academic papers. Warning Unicode handling in Windows Terminal When long results are displayed in Win...ation. It can be enabled the following way: sql .pager '"C:\Program Files\Git\usr\bin\less.exe" -R' List of Output Formats Mode Description ascii Columns/rows delimited by 0x1F and 0x1E box Tables using unicode box-drawing characters csv Comma-separa... - https://man.mtool.work/duckdb/2.0/clients/cli/output_formats.html
- Friendly CLI 11361
- Along with our Friendly SQL , we provide friendly CLI features. Dark/Light Mode The CLI automatically detects whether the terminal is using a dark or light background and adjusts syntax highlighting colors accordingly. The mode can also be
...set manually using the .highlight_mode command: .highlight_mode dark .highlight_mode light To use a mix of colors suitable for both dark and light backgrounds: ....highlight_mode mixed The mode can also be selected when launching the CLI using the -dark-mode and -light-mode command line arguments : d...uckdb -dark-mode duckdb -light-mode 8-Bit Colors Since DuckDB 1.5, the CLI supports 8-bit colors corresponding to Xterm system colors : .di... - https://man.mtool.work/duckdb/2.0/clients/cli/friendly_cli.html
- Command Line 9099
- Unexpected Markdown Output When Piping If the output of the command line client is piped to another process and an AI agent environment variable (such as AI_AGENT ) is set, the CLI switches to agent mode and prints compact Markdown tables i
...nstead of the usual duckbox tables: echo "SELECT 42 AS x;" | duckdb | cat | x:INTEGER | |---| | 42 | To turn off agent mode, use the -no-agent command line argument or set the DUCKDB_AGENT_MODE environment variable to 0 : echo "SELECT 42 AS x;" |...duckdb -no-agent | cat ┌───────┐ │ x │ │ int32 │ ├───────┤ │ 42 │ └───────┘ Passing an explicit output mode flag, such as -csv or -json , also disables agent mode.... - https://man.mtool.work/duckdb/2.0/guides/troubleshooting/command_line.html
- Safe Mode 8650
- The DuckDB CLI client supports “safe mode”. Safe mode can be enabled from the command line using the -safe argument : duckdb -safe Alternatively, it can be activated during a session using the .safe_mode dot command . In safe mode, the CLI
...te from files. Functions such as read_csv , read_parquet , read_json , etc. cannot read from an external source. Once safe mode is activated, it cannot be deactivated in the same DuckDB CLI session. For more information on running DuckDB in secure en... - https://man.mtool.work/duckdb/2.0/clients/cli/safe_mode.html
- Concurrency 7873
- Handling Concurrency Single Process In in-process mode, DuckDB has two configurable options for concurrency: Read-write mode: one process can both read and write to the database. Read-only mode: multiple processes can read from the database
..., but no processes can write ( access_mode = 'READ_ONLY' ). When using read-write mode, DuckDB supports multiple writer threads using a combination of MVCC (Multi-Ve...rol (see Concurrency within a Single Process ), but all within that single writer process. The reason for this concurrency model is to allow for the caching of data in RAM for faster analytical queries, rather than going back and forth to disk during...pointers, the database catalog, and other items so that subsequent queries on the same connection are faster. Concurrency Model within a Single Process DuckDB supports concurrency within a single process according to the following rules. As long as... - https://man.mtool.work/duckdb/2.0/connect/concurrency.html
- Command Line Client 7737
- Installation To use the DuckDB CLI client, visit the CLI installation page . The latest stable version of the DuckDB command line client is 2.0.0. Installation The DuckDB CLI (Command Line Interface) is a single, dependency-free executable.
...FILENAME⟩ Options The ⟨OPTIONS⟩ part encodes arguments for the CLI client . Common options include: -csv : sets the output mode to CSV -json : sets the output mode to JSON -readonly : open the database in read-only mode (see concurrency in DuckDB ) F...mportant option accepted by .open is the --readonly flag. This disallows any editing of the database. To open in read only mode, the database must already exist. This also means that a new in-memory database can't be opened in read only mode since in...sql option allows setting the database path using a SQL expression: .open --sql "getenv('MY_DB_PATH')" Output Formats The .mode dot command may be used to change the appearance of the tables returned in the terminal output. These include the default... - https://man.mtool.work/duckdb/2.0/clients/cli/overview.html
- Connect 7601
- Connect or Create a Database To use DuckDB, you must first create a connection to a database. The exact syntax varies between the client APIs but it typically involves passing an argument to configure persistence. Since DuckDB 1.5.3, you ca
...adds the CONNECT statement , which directs queries to a remote instance. Persistence DuckDB can operate in both persistent mode, where the data is saved to disk, and in in-memory mode, where the entire dataset is stored in the main memory. Tip Both p...e . For more details on DuckDB's storage format, see the storage page . In-Memory Database DuckDB can operate in in-memory mode. In most clients, this can be activated by passing the special value :memory: as the database file or omitting the databas...e file argument. In in-memory mode, no data is persisted to disk, therefore, all data is lost when the process finishes.... - https://man.mtool.work/duckdb/2.0/connect/overview.html
DuckDB 2.0 Documentation / man.mtool.work