This message was deleted.

hi! thanks for joining our community! we have a section in our docs with generic instructions: https://jupysql.readthedocs.io/en/latest/connecting.html, we use SQLAlchemy under the hood so you can check the docs as well: https://docs.sqlalchemy.org/en/20/dialects/mysql.html we're currently working on add specific examples for each major engine to simplify this!

I tried this and got %sql mysql+pymysql://userid:pwd@hostname/dbname

Connection info needed in SQLAlchemy format, example:
               <postgresql://username:password@hostname/dbname>
               or an existing connection: dict_keys(['duckdb://'])
No module named 'pymysql'
Connection info needed in SQLAlchemy format, example:
               <postgresql://username:password@hostname/dbname>
               or an existing connection: dict_keys(['duckdb://'])

looks like you’re missing the pymysql package

Thanks, so silly of me to forget the basics. Got so carried away with the SQL. It works now.

No worries! To be fair, the error message is kind of confusing, we’re working on improving these parts, so if you have any other feedback please let us know!

Please join #C03R6FJ7H2R as well 🙂