Skip to content

Databases & warehouses

Microsoft SQL Server MCP server for SQL Server and Azure SQL

Microsoft SQL Server and Azure SQL hold the data of countless line-of-business applications and reporting databases, from ERP back ends to data marts that feed SSRS and Power BI reports.

Microsoft SQL Server

Available now: Nexatron answers Microsoft SQL Server questions with user-level access that inherits your existing Microsoft SQL Server permissions.

Updated

Can Claude, ChatGPT or Copilot access Microsoft SQL Server data?

Yes. To connect Claude, ChatGPT or Copilot to Microsoft SQL Server, add Nexatron from Claude’s connector directory, or by its MCP server URL in ChatGPT and Copilot. Then connect it in Nexatron. Users sign in with their own Microsoft SQL Server account (or your SSO), and Nexatron inherits their existing permissions.

What Microsoft SQL Server data a question reads

Databases, schemas, tables and views
Application and reporting tables, including indexed views.
Row-level security
Security policies with predicate functions that filter rows for each user.
Dynamic data masking
Masked columns that show obscured values to users without UNMASK permission.
Catalog views
sys.tables, sys.columns and extended properties, read at setup to learn the schema and column descriptions.

Microsoft SQL Server questions people ask

  • What were sales by territory and month this fiscal year, from the reporting database?
  • Which work orders have been open for more than 14 days, by site?
  • How did average days sales outstanding change over the last six months?
  • Which customers exceeded their credit limit on open orders?
  • What were the top 20 items by margin last quarter?

Who asks Microsoft SQL Server questions

Finance and operations
Questions on the reporting databases that today feed SSRS or Excel.
Database owners
A read-only path that keeps every user within their own SQL Server login and its permissions.
Application owners
Questions on the databases behind line-of-business apps, such as ERP back ends, with every user limited to their existing database permissions.

How Nexatron connects to Microsoft SQL Server

API and sign-in
A SQL Server connection over TLS with each user’s own SQL Server or Azure SQL login.
User-level access
Questions run under the person’s own login, so database roles, object permissions, row-level security and masking apply. Every query is checked as a single read-only SELECT before it runs and is shown in T-SQL with the answer.
Read-only
Questions only read Microsoft SQL Server; asking a question never changes Microsoft SQL Server data.
Setup
An administrator enables Microsoft SQL Server in Nexatron. Users link their own Microsoft SQL Server account, or sign in through your SSO, the first time they ask. Queries run in Microsoft SQL Server, with no warehouse to load.

Microsoft SQL Server in Claude’s connector directory

Nexatron is listed in Claude’s MCP connector directory, so a Claude user can add it without a custom server URL. Its hosted MCP server answers Microsoft SQL Server questions for Claude, ChatGPT and Microsoft Copilot with user-level access, and the same governed answer as the Nexatron app. It is Nexatron’s own server, not one published by the vendor.

  1. Connect Microsoft SQL Server to your Nexatron workspace.
  2. In Claude, add Nexatron from Claude’s connector directory. In ChatGPT or Copilot, add a custom MCP connector with Nexatron’s server URL.
  3. Sign in with your own Nexatron identity (OAuth 2.1), then ask your Microsoft SQL Server questions.

Server URL for a custom connector: https://api.nexatron.io/api/v1/mcp

Microsoft SQL Server questions and answers

Does it work with Azure SQL Database and Managed Instance?
Yes. Both accept SQL logins over TLS, as on-premises SQL Server does when it is reachable from Nexatron.
How are time zones handled?
T-SQL has no session time zone, so date questions like today or last month are computed from UTC and the answer states it. Conversions use Windows time-zone names with AT TIME ZONE.
Can it replace SSRS reports?
It answers ad hoc questions next to them. Reports remain the place for fixed, scheduled output; a question asked in Teams or Claude gets an answer with its T-SQL so it can be checked against the report.
Can Claude or Copilot read SQL Server with each user’s own login?
Yes. Users link their own SQL Server or Azure SQL login (or sign in through your SSO with Microsoft Entra ID), and questions from Claude, Copilot or Teams run under that login. The database’s audit shows who asked, and no password sits in a prompt or a config file.