Generate valid autocomplete suggestions for keywords, tables, or columns.
Supports MySQL, T-SQL (SQL Server), PL/pgSQL (PostgreSQL) and PL/SQL (Oracle) dialects.
npm install sql-autocomplete
import { SQLAutocomplete, SQLDialect } from 'sql-autocomplete'; const sqlAutocomplete = new SQLAutocomplete(SQLDialect.MYSQL, ['myDatabaseTableName'], // Optional ['aColumnName']); // Optional const sql1 = 'SELECT * FR'; const options1 = sqlAutocomplete.autocomplete(sql1); console.dir(options1); // [ AutocompleteOption { value: 'FROM', optionType: 'KEYWORD' } ] const sql2 = 'SELECT * FROM myDatab'; const options2 = sqlAutocomplete.autocomplete(sql2); console.dir(options2); // [ AutocompleteOption { value: 'myDatabaseTableName', optionType: 'TABLE' } ]
sql-autocomplete is a project created and maintained by modelDBA, a database IDE for modern developers. modelDBA lets you visualize SQL as you type and edit tables easily with a no-code table editor.