Jupyter Notebook: Cell magic `%%sql` not found

Problem

When using Jupyter Notebook in PyCharm, the SQL button is missing from the toolbar, and attempting to use SQL cells results in the error UsageError: Cell magic %%sql not found

Cause

com.intellij.dataspell.jupyter.customCells plugin is disabled in the disabled_plugins.txt file located in the configuration directory.

Resolution

1. Remove the disabled_plugins.txt File

   • Delete the disabled_plugins.txt file from the configuration directory.
   • Restart PyCharm.

2. Re-enable the com.intellij.dataspell.jupyter.customCells Plugin

   • Remove the line below from disabled_plugins.txt file:

     com.intellij.dataspell.jupyter.customCells
     

3. Save and restart PyCharm.