ts-mysql-autocomplete

An autocomplete engine for MySQL queries.

Features

• Autocompletes keywords, table names, and column names
• Supports all versions of MySQL
• Supports database schema

Installation

yarn add ts-mysql-autocomplete
# or
npm install ts-mysql-autocomplete

Usage

import { MySQLAutocomplete } from 'ts-mysql-autocomplete'

const autocompleter = new MySQLAutocomplete()

const entries1 = autocompleter.autocomplete('SELEC', 5)
console.log(entries1) // [ 'SELECT' ]

const entries2 = autocompleter.autocomplete('SELECT * FROM us', 16)
console.log(entries2) // [ 'users' ]

Related

• ts-mysql-analyzer - A MySQL query analyzer.
• ts-mysql-parser - A standalone, grammar-complete MySQL parser
• ts-mysql-schema - A schema extractor for MySQL
• ts-mysql-uri - Parse a MySQL connection URI
• ts-antlr4-scanner - A scanner for antlr4-based lexers

License

MIT

stevenmiller888.github.io  ·  GitHub @stevenmiller888  ·  Twitter @stevenmiller888