SQL autocompletion based on a database schema

[isNotOkay]

Problem Description

We would like to use monaco as SQL-Editor for SQLite (no other SQL dialect).

For this we started to implement a new registerCompletionItemProvider:

monaco.languages.registerCompletionItemProvider('sql', {
    provideCompletionItems: () => ({
      suggestions: [
        {
          label: 'SELECT',
          insertText: 'SELECT',
          kind: monaco.languages.CompletionItemKind.Keyword
        },
		....
	}))

This has worked quite well so far, but now we are wondering how to implement autocompletion based on the actual database schema.

Example from sql client SQLiteStudio:

Questions

1. Does a completion provider for SQLite already exist, so that we don't have to create our own?
2. How to define autocompletion based on a database schema?

[51yu]

Anyone could shed some light ^^

[guimabdo]

Did you find a way? I'm searching for it.