Search Shortcut cmd + k | ctrl + k
AutoComplete Extension

The autocomplete extension adds supports for autocomplete in the CLI client. The extension is shipped by default with the CLI client.

Behavior

For the behavior of the autocomplete extension, see the documentation of the CLI client.

Functions

Function Description
sql_auto_complete(query_string) Attempts autocompletion on the given query_string.

Example

SELECT *
FROM sql_auto_complete('SEL');

Returns:

suggestion suggestion_start
SELECT 0
DELETE 0
INSERT 0
CALL 0
LOAD 0
CALL 0
ALTER 0
BEGIN 0
EXPORT 0
CREATE 0
PREPARE 0
EXECUTE 0
EXPLAIN 0
ROLLBACK 0
DESCRIBE 0
SUMMARIZE 0
CHECKPOINT 0
DEALLOCATE 0
UPDATE 0
DROP 0

GitHub

The autocomplete extension is part of the main DuckDB repository.

About this page

Last modified: 2024-03-02