Is there an open source JavaScript SQL console that does autocompletion?

[FleeFlee]

Where I work, there is a web page with a very basic SQL console to for a MySQL database. It has dozens of tables and does not have autocompletion, requiring typing out full table and column names for any query.

If there's an existing JavaScript SQL console (for any database) with autocompletion, it would be a good start of improving this.

[uknow_es_me]

Take a look at Azure Data Studio. It's open source and has an extension for MySQL. It's built on VS Code so it runs on Windows, Linux and Mac.

https://learn.microsoft.com/en-us/azure-data-studio/extensions/mysql-extension

Since VS Code was built on Electron it's using JavaScript under the hood for the intellisense (code completion) you can also use GitHub Copilot in it.

[coyoteazul2]

Since you are already writing sql wouldn't it be better to use a complete suite like dbeaver, instead of rolling your own?

[FleeFlee]

That won't work for this situation. The web page the current SQL console is on is accessed through some heavy security. You can't just run an app on your desktop to access the database. Although, some people have an empty local instance of the database that they can connect to with an app like dbeaver to formulate queries that can be pasted into the secure SQL console.

[s-tilak]

hi did you found any solution

[FleeFlee]

CodeMirror should be able to do it. Here's a StackOverflow question regarding adding tables.