Microsoft SQL Server Connector

Microsoft SQL Server is a relational database management system developed by Microsoft.

Start for free View documentation

4.8 on G2

Weld · Data Sources

Microsoft SQL ServerYour warehouseLive

Pick the tables to sync, and they appear here with their status.

Lands in

Queryable over MCP

How it works

Set up in minutes.
No code, no maintenance.

Microsoft SQL Server

Destination

Host

account.microsoft sql server.com

Database

analytics_db

Overview

Microsoft SQL Server, both ways.
As a source or your warehouse.

Microsoft SQL Server is a relational database management system developed by Microsoft. Weld works with Microsoft SQL Server in both directions: replicate its tables into another warehouse, or use Microsoft SQL Server as the warehouse your other sources load into. Either way the data lands in a clean, documented schema that analysts can query with SQL or dbt, and agents can query over the Weld MCP server.

Weld MCP server

Ask your agent.
It can reach Microsoft SQL Server.

Connect Claude, Cursor, ChatGPT or your own agent to Weld over MCP. It finds the Microsoft SQL Server tables Weld has synced and queries your warehouse.

DiscoverSynced tables, columns and freshness
QuerySQL against your warehouse
OperateCheck, rerun and refresh syncs

Set up the MCP server

Claude CodeOpus 5

ConnectedWeld MCP

Which Microsoft SQL Server tables do we have, and which one is the largest?

Looking up what the Microsoft SQL Server connection has synced.

●weld·search_available_references

⎿raw.mssql.*

tables, columns and freshness

●weld·get_reference_schema

⎿columns, types and nullability

●weld·run_query

⎿select count(*) from {{raw.mssql.…}}

submitted

●weld·get_query_status

⎿DONE

●weld·get_query_result

⎿rows returned

✓Answered from Microsoft SQL Server data in your warehouse

>Ask about your Microsoft SQL Server dataMCP

Destinations

Load Microsoft SQL Server into any warehouse.
Set up in minutes, no code.

Resources

Everything you need.
To get started.

Documentation

Microsoft SQL Server setup guide

Step-by-step instructions to configure and start syncing.

MCP server

Connect your agents

Set up Claude, Cursor, ChatGPT or Codex against your Weld workspace.

Weld Connect API

Build custom connectors

Use the Weld Connect API to build and publish your own connector.

FAQ

Common questions

Answers to frequently asked questions about Weld connectors.

Weld Connect API

Set it up in code.
One REST API.

Use the Weld Connect REST API to create Microsoft SQL Server connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.

Explore Weld Connect API reference

POST/elt_syncs

# Create a Microsoft SQL Server ELT sync
curl -X POST https://connect.weld.app/elt_syncs \
  -H "x-api-key: $API_KEY" \
  -d '{
    "connection_id": "conn_abc123",
    "integration_id": "mssql",
    "destination_schema_name": "mssql_data",
    "sync_interval": "0 * * * *"
  }'
▌