A dockable chat window for SQL Server Management Studio 21 / 22, powered by Claude through your own Claude account. Claude can understand the database you are connected to, run queries and (with your approval) changes against it, edit the SQL files in your repository, and rewrite, open or execute query windows in SSMS.
Open it from View > SSMS Claude Chat in SSMS.
Website and documentation: https://tanmays0406.github.io/ssms-claude-chat/ (public repo TanmayS0406/ssms-claude-chat: docs, issues and the Sponsor button).
Claude is instructed to stay on topic: SQL Server, T-SQL, stored procedures, schema design, performance, SSMS and the scripts in your repository. Other requests get a one-line polite refusal. (This is a system-prompt rule, so treat it as a strong default rather than a security boundary.)
- Sign in with Claude: the button at the top of the window runs the official Claude Code CLI sign-in
(
claude auth login) in a console window and your browser. The extension never sees or stores your Claude credentials; the CLI keeps them. Sign out runsclaude auth logout. - Understands your database: Claude gets tools to look at the server and database of the
active query window:
get_connection_info,list_databases,list_objects,describe_object(columns, keys, indexes, foreign keys, parameters, row count, full definition),get_dependencies(what an object uses and what uses it) andrun_query(always read-only). - Stored procedures: Claude reads a procedure's definition and dependencies before explaining it, writes
new or changed procedures as
CREATE OR ALTERin the editor or your repository, deploys them withexecute_sqlwhen you ask, and runs them withEXEC(subject to the approval setting below). - Diagrams: ask for a flowchart of a procedure, an ER diagram of some tables or a call chain, and Claude
calls
show_diagram, which opens a Mermaid diagram in your browser with Download SVG and Copy source buttons. Pages are kept in%LOCALAPPDATA%\SsmsChatExtension\diagrams. Rendering loads Mermaid from cdn.jsdelivr.net, so it needs internet access (the source is always on the page). - One-click database diagram: the DB diagram button lists the databases on the active connection's server;
tick one or more (and optionally a schema) and it draws an ER diagram straight from the catalog - no AI call,
no tokens used:
- Solid lines are declared foreign keys.
- Dashed lines are inferred relationships: a column such as
Invoices.CustomerId,Customer_IDorCustomerKeyis linked to the single-column primary key of aCustomer/Customers/tblCustomertable when the types are compatible (all integer types match each other), and a distinctive key name such asProductCodematches itself. Matches named after the table win, then the same schema, the same database, and finally the other selected databases - so links across databases, which SQL Server cannot declare, show up too. A column that is its table's whole primary key becomes a 1:1 link. - Each database gets its own colour; under the diagram the page lists every inferred relationship with the reason (review them - they are guesses) and the views / procedures / functions that read other databases.
- Large selections are trimmed to 200 tables (tables with relationships first), and above 40 tables only key
columns are shown. Claude can do the same with
show_database_diagram(one or more databases).
- One-click procedure tuning with a before / after benchmark: the Tune procedures (lightning bolt) button
opens a dialog with a Database drop-down (the online databases your login can open; your query window's
database is preselected, and system databases are hidden unless one is the current database) and a Stored
procedures drop-down. The drop-down lists the procedures of the chosen database, with executions, average time
and logical reads from the plan cache (
sys.dm_exec_procedure_stats, when your login may read it), and is read again whenever you pick another database. Tick as many as you like (up to 10 per run, all from that database; Slowest 5 picks the ones that used the most time; the filter box narrows a long list; procedures createdWITH ENCRYPTIONare greyed out because their text cannot be read), choose the number of timed runs and click Tune and benchmark. Claude is told which database you picked, so this works even when your query window is connected to another one. It reads each procedure and its dependencies, gathers evidence with read-only queries, writes an optimized copy named<name>_Optimizedthat returns the same results (the original is never changed) and callscreate_benchmark_plan, which opens a test plan in a new query window. The plan is a script you read and run with F5; nothing runs until you do:- Every procedure and its copy run 2 warm-up + N timed times (no supporting change: alternating run by run, so
drift of the machine hits both equally; with a supporting change such as an index: all before runs, then
the change is applied, then all after runs). Each run records elapsed time, CPU time and logical reads
from
sys.dm_exec_requests. - Result grid: mean before and after, time saved % = (before - after) / before x 100, speed-up = before / after, the same for logical reads and CPU, Welch's t = (meanb - meana) / sqrt(sdb^2 / nb + sda^2 / na), the 95% confidence interval of the time saved (difference +/- 1.96 x SE) and a verdict: FASTER / SLOWER needs |t| >= 2 and a change of at least 5%; anything smaller is NO MEANINGFUL DIFFERENCE. More grids show mean / median / SD / min / max, an overall total, errors and every raw run.
- Result check: both versions run once more into table variables and their rows are compared (same rows, same order). A copy that returns different rows is flagged DO NOT USE - the results differ, however fast it is.
- Safety: every run is wrapped in
BEGIN TRAN ... ROLLBACKby default; optimized copies must be named*_Optimized, so a plan can never overwrite another procedure; a cleanup block at the end of the script drops the copies and undoes supporting changes. Switch on Query Options > Results > Grid > Discard results after execution before running, and use a test copy for procedures that change data (rollback does not undo mail, files, linked servers or sequence values). Needs SQL Server 2016 SP1 or later. - Claude cannot run procedures itself, so it never quotes timings: the numbers come from your run of the plan.
- Every procedure and its copy run 2 warm-up + N timed times (no supporting change: alternating run by run, so
drift of the machine hits both equally; with a supporting change such as an index: all before runs, then
the change is applied, then all after runs). Each run records elapsed time, CPU time and logical reads
from
- Runs SQL for you:
execute_sqlruns any script (INSERT / UPDATE / DELETE, CREATE / ALTER, EXEC,GObatches), commits it and gives Claude the results;execute_query_windowpresses F5 on the active query window so you see the results grid in SSMS. What happens depends on Settings > Let Claude run SQL that changes the database:- Ask me before each change (default): SSMS opens a dialog with Claude's reason, the server / database and the full SQL in a scrollable box (resize the dialog, switch Wrap long lines off, or use Copy SQL to review it elsewhere); nothing runs unless you click Yes (No is the default button, and Esc declines).
- Off: both tools refuse; Claude can still explore with
run_queryand put scripts in the editor. - Allow without asking: runs immediately. Only use this against development databases.
- Object Explorer stays current: after
execute_sqlcreates, alters, drops or renames objects, the database node in Object Explorer and the IntelliSense cache are refreshed automatically (so new tables and procedures appear without pressing F5 there). Afterexecute_query_window, the refresh happens once the query finishes. Claude can also callrefresh_object_explorer. A database that is not expanded in Object Explorer simply loads fresh when you open it. - Edits your repository: Claude works in the repository folder set in Settings and can create and edit
files there. Read-only
git status/diff/log/showare always allowed; what else Claude may do depends on Settings > Claude permissions (see below). - Edits SSMS query windows:
get_query_window,replace_query_window(one Ctrl+Z undoes it) andopen_new_query_window(connected like the active window). These only change the text; running it isexecute_query_window(above). - Attach files and screenshots: Attach... picks files (SQL scripts,
.sqlplanexecution plans, logs, CSV, images, PDF; up to 10 per message, 20 MB each), or drop them on the input box. Screenshot opens the Windows snipping overlay and attaches what you select; Ctrl+V in the message box also attaches a copied image or copied files. Attachments are copied to%LOCALAPPDATA%\SsmsChatExtension\attachments(kept 30 days), that folder is passed to the CLI with--add-dir, and Claude reads each file with its Read tool, in every permission mode. - Chat history: every conversation is saved (
%LOCALAPPDATA%\SsmsChatExtension\history, one JSON file per chat). History lists them; opening one shows its messages and continues the same Claude session (--resume), so Claude still remembers it. New chat starts a fresh conversation; Delete removes one. - Model and effort: pick the model (
opus,sonnet,haiku,fable, or type any model id) and the effort level (low...max) in Settings; the header shows what is active. - Themes: the palette icon in the header picks a theme (Follow SSMS (default), Light, Dark, Claude,
Claude Dark, Midnight, Nord, Solarized) and an accent colour. Changes apply immediately and are saved as
Theme/Accentinsettings.json. Colours live inUI/ChatTheme.cs: each theme is a background, text and accent colour, and every other brush is blended from those. Toolbar icons are Segoe Fluent Icons / Segoe MDL2 Assets glyphs. - About links: the bottom of Settings links to the documentation, website, issue tracker and sponsor page
(
UI/ProjectLinks.cs). - Run status: under each reply a status line shows what Claude is doing with the elapsed time (Thinking…, Running SSMS describe_object: dbo.Orders…, Writing…) and ends as Done in 12s, Stopped after 5s or Failed after 3s.
- Tool activity shows in the reply as
› SSMS describe_object: dbo.Orders,› Edit: C:\repo\proc.sql, and so on. - Still there: streaming replies, Stop, Include selected / current query as context, Insert into query window, Copy.
- Claude Code CLI (
claude) on the same machine: install it from https://claude.com/claude-code (native installer~/.local/bin/claude.exeornpm i -g @anthropic-ai/claude-code). The window finds it onPATHor in those folders; otherwise set the path in Settings. - A Claude subscription (Pro / Max / Team / Enterprise) or Console account to sign in with.
SSMS Claude Chat window ──stdin──▶ claude -p --output-format stream-json --resume <session> (cwd = repository folder)
▲ │ built-in tools: Read / Edit / Write / Grep ... inside the repository
└──── streamed reply ─────┤
└─ MCP over http://127.0.0.1:<random port>/mcp (random bearer token)
└─ "ssms" tools inside SSMS: database + query windows
- Every message runs
claude -pin the repository folder with the chosen--permission-mode,--modeland--effort,--allowedTools mcp__ssmsplus read-only git, the extension's instructions via--append-system-prompt-file, and an--mcp-configfile that points to a small MCP server hosted inside SSMS. That file lives in%LOCALAPPDATA%\SsmsChatExtension\mcp-<pid>.json; the token changes every SSMS session. - Database tools use the connection of the active query window, created by SSMS itself (Windows, SQL and Microsoft Entra logins all work). If that is not possible, set a connection string override in Settings (stored DPAPI-encrypted for your Windows user, with an extension-specific entropy value so other programs running as you cannot decrypt it by calling DPAPI blindly; a value saved by an earlier version is re-encrypted on first load).
run_queryis read-only by design: statements that write,EXEC, transactions,USE,OPENROWSETand similar are rejected before they run, and every query also runs inside a transaction that is always rolled back, with a 30 second timeout and a row limit.execute_sqlruns batch by batch (split onGO, like SSMS) with autocommit and a 5 minute timeout per batch, and stops at the first error, reporting which batches were already committed. The approval dialog is the safety net, so read it; if you need a hard guarantee, connect with a login that has only the permissions you want Claude to have.
Settings (top of the window), saved to %LOCALAPPDATA%\SsmsChatExtension\settings.json:
| Setting | Meaning |
|---|---|
| Repository folder | Where Claude works and may edit files. Empty = a private scratch folder (...\SsmsChatExtension\workspace). |
| Claude permissions | Edit files in the repository folder (acceptEdits, default) / Auto mode (auto: Claude Code's safety classifier approves actions, including shell commands, and blocks risky ones) / Read-only (default: anything that needs permission is refused). |
| Let Claude run SQL that changes the database | Off / Ask me before each change (default) / Allow without asking. Applies in every Claude permission mode. |
| Model | --model: opus, sonnet, haiku, fable or any model id. Empty = Claude Code's default. |
| Effort | --effort: low, medium, high, xhigh, max. Empty = the model's default. Available levels depend on the model. |
| Connection string override | Optional. Used for database tools instead of the active query window. |
| Claude Code CLI path | Optional full path to claude.exe / claude.cmd. |
You can also add a CLAUDE.md to the repository folder to give Claude project conventions (naming, style,
which databases are which); the CLI picks it up automatically.
- Download the latest setup from the SSMS Claude Chat website's Download button, or directly: SsmsClaudeChat-Setup.exe (this repository is private, so its Releases page is only visible to you; the link above always serves the newest setup).
- Close SSMS and run the setup. It needs no admin rights.
- Start SSMS and open View > SSMS Claude Chat.
Setup finds SSMS 21 / 22 and installs the extension with the VSIXInstaller.exe that ships with SSMS
(double-clicking a .vsix does not work for SSMS 21+). Running a newer setup upgrades in place. Remove it from
Settings > Apps > Installed apps > SSMS Claude Chat.
Setup options: /SSMSPATH="D:\...\Release\Common7\IDE" if SSMS lives in a non-standard folder,
/VERYSILENT for an unattended install.
Windows may show a SmartScreen warning because the setup is not code-signed: click More info > Run anyway.
Needs Visual Studio 2022 or newer with the Visual Studio extension development workload (or the Build Tools),
and Inno Setup 6 (winget install JRSoftware.InnoSetup).
.\Build-Installer.ps1 # version from source.extension.vsixmanifest
.\Build-Installer.ps1 -Version 1.5.0 # stamps 1.5.0 into the manifest and assembly firstThis restores NuGet packages, builds the VSIX and creates dist\SsmsClaudeChat-Setup-<version>.exe
(plus the .vsix).
You can also open SsmsChatExtension.sln in Visual Studio and build it there. dotnet build cannot build
a VSIX; use Visual Studio or MSBuild.
Microsoft Store (and SmartScreen) want the setup and every PE file in it signed. The workflow signs with
Azure Artifact Signing on pushes to main: the extension DLL
right after compiling (so the copy inside the VSIX is signed), the setup and its uninstaller (through Inno Setup's
SignTool), and then checks the setup's signature. It turns on once these repository variables are set:
| Variable | Value |
|---|---|
ARTIFACT_SIGNING_PROFILE |
Certificate profile name in the signing account (signing is off while this is empty) |
ARTIFACT_SIGNING_ACCOUNT |
Signing account name, default Signs |
ARTIFACT_SIGNING_ENDPOINT |
Account endpoint, default https://eus.codesigning.azure.net/ |
AZURE_CLIENT_ID |
Entra app with a GitHub OIDC federated credential for repo:TanmayS0406/SSMSClaude-Script:ref:refs/heads/main and the Artifact Signing Certificate Profile Signer role on the signing account |
Locally: .\Build-Installer.ps1 -SignCommand '"...\signtool.exe" sign /fd SHA256 /tr http://timestamp.acs.microsoft.com /td SHA256 /dlib "...\Azure.CodeSigning.Dlib.dll" /dmdf "...\metadata.json"'.
.github/workflows/build.yml publishes a GitHub release on every push to main, so the download links above
always get the newest build. The version bumps automatically: the patch number of the newest v* tag goes up by
one (1.4.0, 1.4.1, 1.4.2, ...) and is stamped into the VSIX manifest and assembly before building.
- New minor/major version: raise the version in
source.extension.vsixmanifest(e.g. to1.5.0) and push; that push releases exactly1.5.0, and later pushes continue from there. - Specific version: push a tag (
git tag v2.0.0,git push origin v2.0.0). - Pull requests only build; the setup is under the run's Artifacts.
Pushes to main also upload to the private downloads container of the ssmschatdl0b9391 storage account
(resource group Joiner-dev, subscription Joinery), one folder per version, plus version.json at the root
pointing at the newest one:
downloads/
version.json {"version": "1.4.7", "path": "1.4.7/SsmsClaudeChat-Setup-1.4.7.exe", ...}
1.4.7/SsmsClaudeChat-Setup-1.4.7.exe
1.4.7/SsmsClaudeChat-1.4.7.vsix
The website's Download button goes to https://ssmsclaudechat-dl.azurewebsites.net/download, an Azure Function
(download-function/, Consumption plan, .NET 10 isolated) that reads version.json, redirects to a five-minute
read-only link for that setup and queues a count. A second function drains the queue into the Downloads table of
the free-tier Azure SQL database (downloads, serverless, auto-pauses; the queue absorbs the cold start). Only the
version and the time are stored. The function writes with a downloads_writer user that can INSERT and nothing
else; its connection string is the SqlConnection app setting.
The same function serves the security report at /security/{file} (security.json, badge.json, banner.svg,
sbom.spdx.json, nothing else). security.yml publishes those files under security/ in the private container, and the
website repository's Update security report workflow reads them from the function, so the container never needs
public access.
Deploy after changing it: dotnet publish -c Release -o publish-out in download-function/, zip the output (forward
slashes in entry names) and az functionapp deploy --type zip --src-path publish.zip to ssmsclaudechat-dl.
The upload is skipped until one of these is set (Settings > Secrets and variables > Actions):
| Name | Kind | Value |
|---|---|---|
AZURE_STORAGE_SAS_TOKEN |
secret | SAS token for the downloads container with create + write rights (no leading ?) |
AZURE_CLIENT_ID |
variable | Alternative to the SAS: App ID of an Entra app with a federated credential for repo:TanmayS0406/SSMSClaude-Script:ref:refs/heads/main and Storage Blob Data Contributor on the container; also needs AZURE_TENANT_ID and AZURE_SUBSCRIPTION_ID |
AZURE_STORAGE_ACCOUNT |
variable | ssmschatdl0b9391 (AZURE_STORAGE_CONTAINER optionally overrides downloads) |
Everything goes through one interface, Services/IChatService.cs; ChatServiceProvider.Current defaults to
ClaudeCodeChatService. EchoChatService is a no-AI stub that is handy for UI work:
ChatServiceProvider.Current = new EchoChatService();| Path | Purpose |
|---|---|
src/SsmsChatExtension/SsmsChatPackage.cs |
Package entry point, registers the View menu command and the tool window |
src/SsmsChatExtension/VSCommandTable.vsct, PackageIds.cs |
Menu definition and the GUIDs / IDs it uses |
src/SsmsChatExtension/source.extension.vsixmanifest |
VSIX identity and the SSMS install target |
src/SsmsChatExtension/UI/ |
WPF chat control, view model, tool window and the dialogs (SQL approval, database diagram, procedure tuning) |
src/SsmsChatExtension/Services/ |
IChatService, the echo stub, the message models and the chat history store |
src/SsmsChatExtension/Services/Claude/ |
Claude Code CLI wrapper (sign-in, status), the chat service, settings |
src/SsmsChatExtension/Mcp/ |
Loopback MCP server and the ssms tools Claude calls |
src/SsmsChatExtension/Database/ |
Active query window connection (via SSMS internals), the read-only query runner and the GO-aware executor; the ER diagram builder (SchemaDiagram); for procedure tuning, the per-database procedure list (StoredProcedureCatalog), the request and chat message the dialog produces (ProcedureTuneRequest), the before / after benchmark script generator (BenchmarkPlan) and the safe object-name parser it uses (SqlObjectName) |
src/SsmsChatExtension/Diagrams/ |
Mermaid diagram pages opened by show_diagram |
src/SsmsChatExtension/Editor/SsmsEditor.cs |
Reads / writes / opens / executes query windows through DTE |
src/SsmsChatExtension/Editor/SsmsObjectExplorer.cs |
Refreshes Object Explorer and the IntelliSense cache after schema changes |
installer/SsmsClaudeChat.iss |
Inno Setup script for the setup .exe |
download-function/ |
Azure Function behind the website's Download button: newest-setup redirect and download counter |
Build-Installer.ps1 |
Builds the VSIX and the setup .exe |
.github/workflows/build.yml |
CI build and tag-triggered GitHub releases |
- "Claude Code CLI not found": install it, or set Claude Code CLI path in Settings, then click Refresh.
- Sign-in console says the command is unknown: update the CLI (
claude update), or runclaudeonce in a terminal and type/login, then click Refresh. - "SSMS database tools unavailable" or No database connection: click into a connected query window before sending, or set a connection string override.
- Tune procedures: "Slowest 5" is greyed out: the login cannot read the plan cache statistics (it needs
VIEW SERVER STATE, orVIEW SERVER PERFORMANCE STATEon SQL Server 2022), or nothing has run since the plans were cached. You can still tick procedures by hand. - Tune procedures: a database is missing from the drop-down: only online databases the login can open are listed, and system databases are hidden unless one is the connection's current database.
- Tune procedures: "Could not read the stored procedures of ...": the text after the colon is SQL Server's reason (for example no access to that database). Pick another database, or connect with a login that can read it.
- No "SSMS Claude Chat" in the View menu: run
Ssms.exe /updateconfigurationonce from the SSMSCommon7\IDEfolder to rebuild the extension cache, then restart SSMS. - Install fails: open the newest
VSIXInstaller_*.login%TEMP%, or run setup with/LOG="%TEMP%\setup.log". - Extension misbehaves after startup: run
Ssms.exe /logand check%APPDATA%\Microsoft\SSMS\...\ActivityLog.xml. - The active-window connection comes from SSMS internals (
ServiceCache.ScriptFactory,UIConnectionInfoUtil) read via reflection; if a future SSMS moves them, the connection string override still works. - Microsoft has not published a stable SSMS extensibility SDK, so a future SSMS update may need small changes
(the
Microsoft.VisualStudio.Ssmsinstall target in the manifest and the 17.14.x SDK package versions are the first places to look).
The publisher name ("Tanmay Seth") lives in source.extension.vsixmanifest, AssemblyInfo.cs and installer/SsmsClaudeChat.iss.
SSMS Claude Chat is free. Sponsoring keeps it maintained and pays for code signing and hosting.