SQL assist and auto complete
CloudBeaver provides the SQL assist feature, which offers auto-completion of database object names, SQL commands, and other keywords in queries.
When you start typing an SQL code, CloudBeaver suggests auto-complete options based on the context.
Completion engines¶
CloudBeaver offers two SQL completion engines:
- Semantic (default) ā provides the most accurate and context-aware suggestions by analyzing the entire SQL structure and lexical scopes. It improves completion accuracy but may not work correctly with certain database-specific syntax.
- Legacy ā a more straightforward completion engine that suggests SQL elements based only on their position in the query. This can sometimes lead to incorrect or incomplete suggestions, especially in subqueries.
Note
The Semantic engine is actively being improved, but if you encounter issues, switching to Legacy may provide more stable behavior. We still recommend using Semantic for the best overall experience.
Change the completion engine¶
To switch between engines:
- Profile -> Preferences -> SQL Editor -> Completion engine
- (For administrators) Settings -> Administration -> Settings -> SQL Editor -> Completion engine