- Notifications
You must be signed in to change notification settings - Fork8
Autocomplete recommendations for SQL statements
License
NotificationsYou must be signed in to change notification settings
modeldba/sql-autocomplete
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
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';constsqlAutocomplete=newSQLAutocomplete(SQLDialect.MYSQL,['myDatabaseTableName'],// Optional['aColumnName']);// Optionalconstsql1='SELECT * FR';constoptions1=sqlAutocomplete.autocomplete(sql1);console.dir(options1);// [ AutocompleteOption { value: 'FROM', optionType: 'KEYWORD' } ]constsql2='SELECT * FROM myDatab';constoptions2=sqlAutocomplete.autocomplete(sql2);console.dir(options2);// [ AutocompleteOption { value: 'myDatabaseTableName', optionType: 'TABLE' } ]
sql-autocomplete is a project created and maintained bymodelDBA, a database IDE for modern developers.modelDBA lets you visualize SQL as you type and edit tables easily with a no-code table editor.
About
Autocomplete recommendations for SQL statements
Topics
Resources
License
Uh oh!
There was an error while loading.Please reload this page.
Stars
Watchers
Forks
Packages0
No packages published
Uh oh!
There was an error while loading.Please reload this page.
Contributors2
Uh oh!
There was an error while loading.Please reload this page.