feature-request: Completion from multiple MySQL databases

[ss-raicangu]

Description

If the MySQL configuration has a multi-database setup, sql-language-server seems to only complete tables and fields from one of the databases at a time. For example, in a query like such.

SELECT *
FROM db1.star
JOIN db2.planet
  ON star.coordinate BETWEEN planet.x AND planet.y;

Possible code location:

sql-language-server/packages/server/src/database_libs/MysqlClient.ts

Line 30 in 03ef816

database: this.settings.database || '',

Finally, supporting multiple databases probably doesn't need to be specific to MySQL but made a specific request to start 🙂 .

Thanks in advance for considering this request 🙂 .

Workaround

In Neovim: As per README: Switch database connection, mapping the workspace/executeCommand method to call switchDatabaseConnection works fine when completing one database at a time.

References

Following issues are possibly related.

• json adapter mode for autocompletion with multiple connections #223