%sqlcmd connect#

New in version 0.10.1.

%sqlcmd connect displays a widget that allows you to create new connections and manage existing ones.


Since %sqlcmd connect uses the optional ipywidgets package:

pip install ipywidgets --upgrade

Create a new connection#

Click on the + Create new connection button and fill out the form:


Delete a connection#

Click on trash bin icon and confirm:


Edit an existing connection#

Click on the pencil button, edit details, and click on Update:


Connect to an existing connection#

Click on the Connect button:


The connections file#

All your connections are stored in the %config SqlMagic.dsn_filename file (~/.jupysql/connections.ini by default). You can change the file location and edit it manually, to learn more, see: Using a connection file