---
title: "Microsoft SQL Server integration for LuumenAI"
url: "https://www.luumen.ai/integrations/microsoft-sql-server/"
entity: SoftwareIntegration
category: "Databases & data platforms"
audience: "SRE, DevOps, platform engineering, IT operations"
---

# Microsoft SQL Server integration for LuumenAI

Query Microsoft SQL Server state safely; maintenance held for approval.

## What LuumenAI can do with Microsoft SQL Server

LuumenAI connects to Microsoft SQL Server with Service account and exposes 16 tools (10 read-only · 6 write). Reads answer immediately; writes are shown as a plan and require approval by default, configurable per tool by an administrator.

## Key facts

- Authentication: Service account
- Tools available: 16 tools (10 read-only · 6 write)
- Plan: available on all plans
- Category: Databases & data platforms

## About Microsoft SQL Server with LuumenAI

Bring Microsoft SQL Server state into the investigation: schema, running queries, locks, and replication. Read-only queries show their SQL before running; kills, failovers, and maintenance are held for approval and audited.

## Example tools

Read-only (10 in total):

- `Describe schema & objects` — Tables, indexes, and jobs as context for the investigation.
- `Run read-only query` — Ask a question of the data with the SQL shown before it runs.
- `Inspect running queries & locks` — See what is slow or blocked right now.
- `List databases & tables` — What exists and how big it is.
- `Explain query` — The plan a query will use.
- `Get replication status` — Replica lag and health.
- `List jobs & schedules` — Pipelines and their next run.
- `Get job run logs` — Why a job succeeded or failed.

Write and destructive (6 in total, approval required by default):

- `Kill session or job` — Terminate a runaway session as an approved action.
- `Run maintenance` — Vacuum, reindex, or failover inside a reviewed runbook.
- `Rerun job` — Retry a failed run with the same inputs.
- `Pause schedule` — Stop a pipeline from running.
- `Grant or revoke access` — Change a grant as an approved action.
- `Create index` — Add an index inside a reviewed change.

## Frequently asked questions

### How does LuumenAI connect to Microsoft SQL Server?

Authorize once with Service account. Luumen lists the scopes each action needs before you approve the connection, and credentials never appear in the chat.

### Can LuumenAI change things in Microsoft SQL Server on its own?

Read actions answer immediately. Anything that writes is shown as a plan and requires approval by default. Administrators configure that per tool.

### Is there an audit trail?

Every call to Microsoft SQL Server — read or write, approved or declined — is recorded with the actor, the input, and the result.

Full page: https://www.luumen.ai/integrations/microsoft-sql-server/