Microsoft SQL Server

This documentation describes the integration of MindsDB with Microsoft SQL Server, a relational database management system developed by Microsoft. The integration allows for advanced SQL functionalities, extending Microsoft SQL Server’s capabilities with MindsDB’s features.

​

Prerequisites

Before proceeding, ensure the following prerequisites are met:

1. Install MindsDB locally via Docker or Docker Desktop.
2. To connect Microsoft SQL Server to MindsDB, install the required dependencies following this instruction.

​

Connection

Establish a connection to your Microsoft SQL Server database from MindsDB by executing the following SQL command:

CREATE DATABASE mssql_datasource 
WITH ENGINE = 'mssql', 
PARAMETERS = {
    "host": "127.0.0.1",
    "port": 1433,
    "user": "sa",
    "password": "password",
    "database": "master"
};

Required connection parameters include the following:

• user: The username for the Microsoft SQL Server.
• password: The password for the Microsoft SQL Server.
• host The hostname, IP address, or URL of the Microsoft SQL Server.
• database The name of the Microsoft SQL Server database to connect to.

Optional connection parameters include the following:

• port: The port number for connecting to the Microsoft SQL Server. Default is 1433.
• server: The server name to connect to. Typically only used with named instances or Azure SQL Database.

​

Usage

Retrieve data from a specified table by providing the integration name, schema, and table name:

SELECT *
FROM mssql_datasource.schema_name.table_name
LIMIT 10;

Run T-SQL queries directly on the connected Microsoft SQL Server database:

SELECT * FROM mssql_datasource (

    --Native Query Goes Here
    SELECT 
      SUM(orderqty) total
    FROM Product p JOIN SalesOrderDetail sd ON p.productid = sd.productid
    JOIN SalesOrderHeader sh ON sd.salesorderid = sh.salesorderid
    JOIN Customer c ON sh.customerid = c.customerid
    WHERE (Name = 'Racing Socks, L') AND (companyname = 'Riding Cycles');

);

​

Troubleshooting Guide