Microsoft SQL Server (MSSQL)

Category: SQL Status: base

Connects to Microsoft SQL Server. Supports full SQL querying, schema browsing, migrations, and ORM code generation.

Connection Settings

Field	Default	Description
host	localhost	Server hostname or IP
port	1433	TCP port
user	(empty)	Login username (default: sa)
password	(empty)	Password (8–128 chars, mixed case + digits + symbols)
dbname	(empty)	Database name (default: master)
url	(empty)	Full connection URL (overrides above fields)

Authentication

SQL Server login credentials. For Windows Authentication, configure appropriately in the ODBC driver settings.

Supported Actions

• execute — run T-SQL queries
• download — export table or query result
• delete — drop tables
• liquibase — Liquibase migration support
• transfer_table — copy table to another connector
• drawing_nodes / dbdiagram — visualize table relationships
• stream_table — stream table data
• python_description / django_description / sqlalchemy_description — generate ORM model code
• search_by_value — search within fetched table data

Required Setup

Requires the pyodbc Python package and the msodbcsql18 system driver:

pip install pyodbc

Install the Microsoft ODBC Driver 18 for SQL Server from: https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server

External Links

• https://learn.microsoft.com/en-us/sql/sql-server/