Database Connections

MySQL connection setup

MySQL connector is available in AI Data Analyst conversational notebooks. Click DB Connector in the prompt box, configure MySQL details, test connection, and save.

MySQL connector form in MLJAR Studio AI Data Analyst

Required fields

  • host
  • port
  • database
  • user
  • password

Connection flow

  1. Open AI Data Analyst notebook.
  2. Click DB Connector.
  3. Select MySQL and fill required fields.
  4. Click Test connection.
  5. If Python driver packages are missing, MLJAR Studio asks to install and installs them.
  6. When test succeeds, click Save connection.
  7. Review scanned tables and choose which should be available to the LLM.
  8. Click final Save.

SQL block in conversational notebook

SQL queries are shown in a compact block by default. Users can expand the block to inspect full SQL text.

Collapsed SQL code block in MLJAR Studio conversational notebook

Expanded SQL block view:

Expanded SQL code block in MLJAR Studio conversational notebook
« Previous
PostgreSQL
Next »
SQL Server