[Feature]: Add support for creating datasources by importing connection strings

[GreenFlux]

Is there an existing issue for this?

• [X] I have searched the existing issues

Summary

Currently Appsmith only supports connection strings for creating MongoDB datasources. This feature request is for a new Connection String Importer to be added at the top level in the Create Datasource list, rather than add a string importer input to each separate datasource form.

This would be similar to the curl importer, and would be an intermediate form, before landing on the actual datasource form. It should be able to test the string to ensure it is valid for the given protocol, and if valid, create a new draft datasource of the correct type, with all values filled in.

Why should this be worked on?

• Saves users time in configuring datasources
• Avoids errors in creating configuration (mixing up database_name/user_name, typos, etc)
• Most databases provide connection strings
• Increases activation and user's success rate of creating datasources

This library may be helpful in parsing DB URLs: https://npm.runkit.com/parse-database-url

@GreenFlux has provided regex for various DBs here .

mysql://(?<username>[^:]+):(?<password>[^@]+)@(?<hostname>[^:/]+):(?<port>\d+)/(?<database_name>.+)

mssql://(?<username>[^:]+):(?<password>[^@]+)@(?<hostname>[^:/]+):(?<port>\d+)/(?<database_name>.+)

postgresql://(?<username>[^:]+):(?<password>[^@]+)@(?<hostname>[^:/]+):(?<port>\d+)/(?<database_name>.+)

oracle://(?<username>[^:]+):(?<password>[^@]+)@(?<hostname>[^:/]+):(?<port>\d+)/(?<database_name>.+)

redshift://(?<username>[^:]+):(?<password>[^@]+)@(?<hostname>[^:/]+):(?<port>\d+)/(?<database_name>.+)

redis://:(?<password>[^@]+)@(?<hostname>[^:/]+):(?<port>\d+)

snowflake://(?<username>[^:]+):(?<password>[^@]+)@(?<hostname>[^:/]+)

firestore://(?<project_id>.+)

elasticsearch://(?<username>[^:]+):(?<password>[^@]+)@(?<hostname>[^:/]+):(?<port>\d+)

[GreenFlux]

cc @rlnorthcutt @sumitsum

[GreenFlux]

I could contribute a regex to go with each protocol if it helps. I could use named groups so each form input is matched and labeled in the output.

[sumitsum]

Hi @GreenFlux thanks for offering the help. If possible, can you please create a document with various regex and share the link here ?

[GreenFlux]

@sumitsum , will do. I can have this for you early next week.