> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/connectors/other/mariadb-jupyter-kernel/using-the-kernel.md).

# Using the MariaDB Jupyter Kernel

{% columns %}
{% column %}
{% content-ref url="/pages/VX44M0j0MAcjknDkoaGe" %}
[General MariaDB Jupyter Kernel Usage Information](/docs/connectors/other/mariadb-jupyter-kernel/using-the-kernel/general-mariadb-jupyter-kernel-usage-information.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
General usage guide for the MariaDB Jupyter Kernel, explaining how to open a notebook, select the kernel, try it via MyBinder, and work with sample notebooks on GitHub.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/lhtvrecLPk8HCBLn8PhJ" %}
[MariaDB Jupyter Kernel Magic Commands](/docs/connectors/other/mariadb-jupyter-kernel/using-the-kernel/mariadb-jupyter-kernel-magic-commands.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Magic commands reference for the MariaDB Jupyter Kernel, covering `lsmagic`, line/bar/pie plot commands, `df` export, `load`, and the delimiter cell magic.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/ipsUkjHTGg08JdpZZXyN" %}
[MariaDB Jupyter Kernel Restrictions and Limitations](/docs/connectors/other/mariadb-jupyter-kernel/using-the-kernel/mariadb-jupyter-kernel-restrictions-and-limitations.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Known restrictions of the MariaDB Jupyter Kernel include one SQL statement per cell, single line magic per cell, no mixing of magic and SQL, and required semicolon delimiters.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/1cQ6n0zDHVSeDWCNJfte" %}
[SQL Autocompletion and Introspection](/docs/connectors/other/mariadb-jupyter-kernel/using-the-kernel/sql-autocompletion-and-introspection.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The MariaDB Jupyter Kernel provides TAB-triggered SQL autocompletion for keywords, databases, tables, columns, and user accounts, plus SHIFT-TAB introspection for schema and function docs.
{% endcolumn %}
{% endcolumns %}