Database Connections

SQL Server connection setup

SQL Server connector is available in AI Data Analyst conversational notebooks via DB Connector.

SQL Server connector form in MLJAR Studio AI Data Analyst

Required fields

  • host
  • port
  • database
  • schema
  • user
  • password

Additional requirement

MS SQL Server requires OS-level ODBC runtime/driver in addition to Python packages.

  • Linux/macOS: unixODBC + msodbcsql18
  • Windows: ODBC Driver 18 for SQL Server

Connection flow

  1. Open AI Data Analyst notebook.
  2. Click DB Connector and select SQL Server.
  3. Fill all fields and click Test connection.
  4. Install missing Python driver packages if prompted.
  5. When test succeeds, click Save connection.
  6. Select LLM-visible tables after table scan.
  7. Click final Save.
« Previous
MySQL
Next »
Databricks