Naturally Pacifist Marsupials

    sql-autocomplete
    TypeScript icon, indicating that this package has built-in type declarations

    1.1.1 • Public • Published

    sql-autocomplete

    Generate valid autocomplete suggestions for keywords, tables, or columns.

    Supports MySQL, T-SQL (SQL Server), PL/pgSQL (PostgreSQL) and PL/SQL (Oracle) dialects.

    Install

    npm install sql-autocomplete

    Full documentation can be found here

    Get Started

    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' } ]

    Created By

    modelDBA logo

    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.

    Install

    npm i sql-autocomplete

    DownloadsWeekly Downloads

    280

    Version

    1.1.1

    License

    MIT

    Unpacked Size

    357 kB

    Total Files

    19

    Last publish

    Collaborators

    • modeldba