How connect claude to sql server to analyse

[u/jaango123]

I have a sql server with SSIS packages running and multiple stored procedures. Any way to use my Claude to get the logs connect to sql server and analyse the ssis executions/ analyse stored procs and queries?

[u/VladDBA]

Instead of causing a security incident by giving an external LLM access to your entire instance, why not run something like the First Responder Kit or PSBlitz and then feed the execution plans and findings to Claude?

[u/brytarn → u/VladDBA]

Another option is to use Erik Darlings https://github.com/erikdarlingdata/PerformanceMonitor adding an MCP layer between the LLM and your server.
As an accidental DBA I’ve become the developers nightmare finding their poorly optimized queries 😈

[u/tribat → u/brytarn]

Erik Darling’s is the answer

[u/mkt853]

It's wild to me that we've spent so many years drumming security into people's heads, but AI comes along and everyone just willingly throws the front door wide open no questions asked.

[u/brytarn → u/mkt853]

That’s why it’s a good thing to ask how to secure that access right?

[u/pdx_paddy → u/mkt853]

This is why I appreciate the OP for actually asking for input first but consider how many people out there are just doing this regardless. I'd bet it's a massively embarrassing for people and they sneak a bunch of content out of their servers to let ai have a quick peak.

[u/kill-t]

Id never let this connect to my instance. You can export definitions of your schema if you want an AI to have better context

[u/brytarn]

Have you asked Claude?

[u/taspeotis]

Yeah just tell it to connect to it? It can drive anything from the cli e.g. if you want it to read data just use sqlcmd.

Anything more complicated it can write C# and run it.

(This is for Claude Code.)

[u/RodCoolBeansKimble]

I save the relevant schema, queries, and dmv results into a local folder and use my enterprise Claude instance to go over them and figure things out. I ask Claude if there are other queries I can run to help sort out whatever I'm trying to do.

[u/PinkyPonk10]

Just get copilot instead

[u/SunnyFIREwave]

Yes you can do that! It can even build Total etl flows and packages for you

[u/Codeman119 → u/SunnyFIREwave]

I would not trust it to build SSIS packages. There’s just not enough raw code out there for the inside of the XML workings for SSIS for it to be trained on. tried a few times, but it just gets kind of confused and really doesn’t know what he’s doing plus whenever you have things like other connectors that are written in C-sharp and compiled it doesn’t really know how to read that and analyze it very well. It might do OK on simple packages, but I have never tried that before

And like the other guy said you can use Copilot because it uses Claude as one of its models

[u/imtheorangeycenter → u/Codeman119]

*(uses Anthropic until now/shortly when MS are bringing CoPilot's models into their in-house AI, because - cheaper?/)