Voice of the DBA

Tag: syndicated

Monday Monitor Tips: Configuring Access to the MCP Server
I have been experimenting with MCP servers in a few ways, including the Redgate Monitor MCP Server. It took me a few tries, and some help from engineers to get connected. I’ll cover how I did this in Claude and Visual Studio Code in this post, and try to warn you about a few places I made mistakes.

This is part of a series of posts on Redgate Monitor. Click to see the other posts.

Creating A Token

I’m not going to bore you with the setup and configuration of the Redgate Monitor instance. That procedure might change by release, so I’ll assume you’ve got the MCP server enabled.

To access the MCP server, you need to give your AI agent a token. This authorizes the MCP server to connect to Redgate Monitor and read data. These are read only tokens, and designed for the MCP and the tools that are available.

In the configuration, there is an Access Tokens area. Click here.

Click Create Token on the next screen. This is in the upper right.

On the next screen, give your token a name, description, and set an expiration date. The default is one year.

Make sure you select the MCP type. I messed this up the first time.

Below this, pick the servers the MCP token can access. I’ve selected just the Production serer group, but you can set this as needed. I’d make sure the name and/or description lets you know what can be accessed.

You will get a review screen, to verify what you’ve done. Accept that and you’ll get a dialog with the token value. Make sure you save this securely somewhere.

Once you’ve created this, it’s in a list, and you can click the “view details, which shows you what the token can access, as you can see below. You cannot get the token itself anymore.

Configuring VS Code

I’m going to show this working in VS Code. I opened the Command Palette and selected the MCP: Open User Configuration, as shown.

Inside the config, I pasted this inside the “servers” key. This should be a sub element, and this goes alongside any other MCP servers.:
```
"redgate-monitor": {
  
 "type": "http",
  
 "url": "https://<your-monitor-host>/mcp",

 "headers": {
  
 "Authorization": "Bearer ${input:redgate-mcp-token}"

 }

 }
```
Then inside the “inputs” key, add this:
```
{

 "id": "redgate-mcp-token",

 "type": "promptString",

 "description": "Redgate Monitor MCP token",

 "password": true

 }
```
The save this. When you start the MCP server, it will ask you for your token. Paste the value in and then you should connect. You do this from the MCP: List Servers item in the command palette. This should give you output like this, with a connection message and tools discovered:

If I open a chat, and add the MCP as a tool, I can ask questions. Here’s a question I asked and the initial responses from the LLM.

Once this is done, I’ll get a list of the alerts. I did approve some PoSh commands where the LLM stored results from Redgate monitor and then tried to process those after writing them to a temp file.

\

This is the raw LLM trying to use tools and fumbling around. With a few skills and guidance, this will run smoother, quicker, and more efficiently in your environment.

Summary

The Redgate Monitor MCP server is a great way to start using AI to analyze all the data in your database estate that Redgate Monitor collects. There were 7 tools when I started, but within a few weeks there were 11. By the time you read this, there are likely going to be even more.

Give Redgate Monitor a try and learn how to use MCP servers to link your LLM to Redgate Monitor and start analyzing systems in a more natural manner.

Redgate Monitor is a world-class monitoring solution for your database estate. Download a trial today and see how it can help you manage your estate more efficiently.
August 24, 2026
The Book of Redgate: Evidence

We aren’t the only company that does this, but Redgate Software does try to be data driven. Across my 18 years, I’ve had plenty of people use evidence from customers, from usage data, from market research, and more to justify a decision.

I think Google and quite a few other companies have called this being “data-driven.”

The text on the next page continues the sentence:

not on people’s opinions, the volume of their voices or who they are. When the evidence changes, we are prepared to change our minds. We will thank, and never shoot, the messenger.

I will say that this has skewed a bit over time, as I find that evidence is subject to interpretation and I’ve certainly seen some people cherry picking evidence to support their decision. Sometimes by asking for certain evidence.

However, we did realize there were issues and have tried to correct. I was part of a yearlong project last year that impacted marketing, product, and engineering where we focused on getting more information from more customers, and especially being careful to get evidence from multiple sources, including different geographies. We had a bias to the UK, so we tried to correct for that, and I think we made some strides.

That being said, I haven’t seen us shoot or blame the messenger for bad news, though sometimes thanks are sometimes not as sincere as they could be. I understand, because contrary news tends to dampen enthusiasm.

I have a copy of the Book of Redgate from 2010. This was a book we produced internally about the company after 10 years in existence. At that time, I’d been there for about 3 years, and it was interesting to learn a some things about the company. This series of posts looks back at the Book of Redgate 15 years later.

August 21, 2026
Accessing the Data API Builder MCP Server from VS Code
I recently started playing with the MCP Server for SQL Server, which is a part of the Data API Builder (DAB). I’m not sure why there wasn’t a separate piece of technology used, but I do think the DAB server is very useful, and I wish more people used it. Adding MCP to it makes some sense, as the REST and GRAPHQL endpoints can be disabled.

This post will look at a few things I did to get the MCP server working.

A Default for New Projects

By default, if you have v2.xx of the Data API Builder, when you create a new project (with dab init), you get this section in your json config file with the mcp entry.:
```
"mcp": {
   "enabled": true,
   "path": "/mcp"
}
```
This is the enabling of the MCP server. In my files, this was added below the “rest” and “graphql” sections under the “runtime” key. You can see this in a larger view of the file.

Once you add this, the MCP server should start up with DAB. The only indication I see in the logs is this message that the endpoints are enabled.

Adding an MCP Server to VS Code

My first experiment here was adding a server to VS Code. This isn’t a clear thing in the docs, to me, so I’ll tell you what worked for me. I already have some MCP servers in VS Code, so I really went through this process.

First, this is an http MCP server, and the URL is the DAB URL (for me: http://localhost:5000/mcp) that I’ll use to connect. I used the instructions in this VS Code article rather than the quickstart in the DAB docs.

In the VSCode command palette, I looked for the “MCP: Add Server” entry, as shown.

I then picked the http option:

Next, I enter the UL. I’ve pasted mine in here.

Give this a name. This isn’t clear in docs, but this is the name that you’ll use when starting this MCP server. I chose dab-northwind-mcp, which lets me know this corresponds to my config file and it’s a dab server.

Next we decide where this is available. I usually choose workspace, but the setting depends on what you doing with this server. I tend to aim to keep things more tightly configured, so that if I need it elsewhere, I can learn how to adjust that, or add this as an item for another workspace.

I then get my mcp.json file, which is the config file for the MCP servers in VS Code. These servers are a part of the “servers” key, as an sub-document below that. Each of these is a separate entry in JSOn. I essentially have two of the same here, the sql-northwind and dab-northwind-mcp point to the same server.

Starting the MCP Server

If you look at the image above, there’s a “start” link that VS Code adds as an annotation to the entry. You can click that. For me, I usually go back to the command palette and get to the “MCP: List Servers” entry.

Then I see a list of servers and I’ll select the one I want. In this case, that’s the dab-northwind-mcp one.

I see a few items. The configuration will open the mcp.json. It brings up output by default. I’ll pick “Start Server”

I can see in the output it starts. notice I have some errors, this is because the DAB server wasn’t running. I started it, and then went through the process above to get it restarted. You can see tools were discovered.

That’s it. The MCP server is active and running. I’ll do another post on how I can use this.
August 19, 2026
The Fringe Festival

I was lucky enough to take a vacation a decade ago in Edinburgh with my wife. She came over to the UK with me for a quick trip. We had never been to Scotland together, so we trained up and stayed in Stirling. We walked around the area, visited the Wallace Monument and toured Edinburgh. We hiked up Arthur’s Seat and piled stones on a sunny August afternoon.

We hadn’t planned it, but the Edinburgh Fringe Festival was going on at the time. We saw lots of street performers and wandered into a few comedy and music shows in random places. It was a fun time and we’ve always wanted to go back.

We’re back this year. We trained up earlier today and are spending a few days here, taking in a few shows and unwinding from life. My wife has had a busy year with work and we’ve been aiming to get away every month and recharge a bit. This is our August trip after a few days in Napa in July.

In the spirit of Amy Abel learning to recharge and detoxing, we’re getting away. I don’t know that we’ve avoiding technology, but we are avoiding the work things that create stress and take away from life.

Make sure you take your vacation and get breaks away from the things that stress you out.

August 14, 2026