Out-of-tree DuckDB extension that exposes the experimental PEG-based SQL autocomplete stack with catalog-aware suggestions (schemas, tables, columns, functions, files, keywords).
The implementation is ported from the in-tree extension/autocomplete work on duckdb/duckdb so it can ship and iterate without waiting for upstream merge.
| Name | Kind | Purpose |
|---|---|---|
sql_smart_auto_complete(sql VARCHAR, ...) |
Table function | Rows of suggestions with position, type, score, and optional extra character. Named parameters: max_suggestion_count, max_file_suggestion_count, max_exact_suggestion_count. |
This extension registers the same PEG parser extension hook as the in-tree autocomplete stack so sql_smart_auto_complete can resolve the matcher cache.
LOAD smart_autocomplete;
FROM sql_smart_auto_complete('SELECT * FRO');This repo follows the DuckDB extension template layout (extension_config.cmake, extension-ci-tools, distribution workflow). To propose listing on community extensions, add a descriptor in duckdb/community-extensions once your CI produces signed artifacts you are happy with.
See LICENSE. Autocomplete sources retain DuckDB’s licensing lineage from the upstream contribution.
- docs/README.md — template-oriented notes (submodules, CLion, distribution).
- docs/UPDATING.md — bumping DuckDB / CI tool versions.