{"id":43871,"library":"sql-autocomplete-parsers","title":"SQL Autocomplete Parsers","description":"Provides autocompletion and error highlighting for various SQL dialects such as ClickHouse, PostgreSQL, MySQL, and others. Current stable version is 1.22.0, with active development. It uses Jison grammar files to generate parsers and ships TypeScript types. Key differentiators: multi-dialect support, extensible architecture, and custom parser extensions for autocomplete logic. Released under Apache-2.0.","status":"active","version":"1.22.0","language":"javascript","source_language":"en","source_url":"ssh://git@github.com/gravity-ui/sql-autocomplete-parsers","tags":["javascript","typescript"],"install":[{"cmd":"npm install sql-autocomplete-parsers","lang":"bash","label":"npm"},{"cmd":"yarn add sql-autocomplete-parsers","lang":"bash","label":"yarn"},{"cmd":"pnpm add sql-autocomplete-parsers","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"Grammar compiler used to generate parsers","package":"jison","optional":false}],"imports":[{"note":"Default export is not available; named export only.","wrong":"const AutocompleteParser = require('sql-autocomplete-parsers').AutocompleteParser","symbol":"AutocompleteParser","correct":"import { AutocompleteParser } from 'sql-autocomplete-parsers'"},{"note":"Parses SQL and returns autocomplete suggestions and errors.","symbol":"parse","correct":"import { parse } from 'sql-autocomplete-parsers'"},{"note":"TypeScript type for the result object.","symbol":"AutocompleteResult","correct":"import type { AutocompleteResult } from 'sql-autocomplete-parsers'"}],"quickstart":{"code":"import { AutocompleteParser, parse } from 'sql-autocomplete-parsers';\n\nasync function main() {\n  const parser = new AutocompleteParser({ dialect: 'clickhouse' });\n  await parser.init();\n  const result = parse(parser, 'SELECT * FROM ', 14);\n  console.log(result.suggestions);\n}\n\nmain().catch(console.error);","lang":"typescript","description":"Initialize parser for ClickHouse dialect and get autocomplete suggestions for a partial SQL query."},"warnings":[{"fix":"Run 'npm run generate' in your project if you need to build parsers","message":"Parser generation must be run with 'npm run generate' before using the library","severity":"breaking","affected_versions":">=1.0"},{"fix":"Use import { ... } from 'sql-autocomplete-parsers'","message":"Default export does not exist; only named exports are available","severity":"gotcha","affected_versions":">=1.0"}],"env_vars":null,"search_vec":"'-2.0':58 '1.22.0':24 'activ':26 'apach':57 'architectur':47 'autocomplet':2,5,53 'clickhous':15 'current':20 'custom':49 'develop':27 'dialect':12,44 'differenti':41 'error':7 'extens':46,51 'file':32 'generat':34 'grammar':31 'highlight':8 'javascript':59 'jison':30 'key':40 'logic':54 'multi':43 'multi-dialect':42 'mysql':17 'other':19 'parser':3,35,50 'postgresql':16 'provid':4 'releas':55 'ship':37 'sql':1,11 'stabl':21 'support':45 'type':39 'typescript':38,60 'use':29 'various':10 'version':22","created_at":"2026-06-05T17:01:52.810138+00:00","updated_at":"2026-06-05T17:01:52.810138+00:00","problems":[{"fix":"Run 'npm run generate' to generate parser files","cause":"Parser generation not run before import","error":"Error: Cannot find module './generated/clickhouseAutocompleteParser'"},{"fix":"Use 'import { AutocompleteParser } from 'sql-autocomplete-parsers''","cause":"Using default import instead of named import","error":"TypeError: AutocompleteParser is not a constructor"},{"fix":"Use one of supported dialects: 'clickhouse', 'postgres', etc.","cause":"Unsupported dialect name","error":"Error: Dialect 'mysql' not supported"}],"ecosystem":"npm","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":"https://github.com/gravity-ui/sql-autocomplete-parsers#readme","github":"ssh://git@github.com/gravity-ui/sql-autocomplete-parsers","docs":null,"changelog":null,"pypi":null,"npm":"sql-autocomplete-parsers","openapi_spec":null,"status_page":null,"smithery":null,"categories":["database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-05","next_check":"2026-09-03","install_tag":null}}