Tutorial: Set Up a Database Tools MCP Server and Integrate with an MCP Client

The objective of this tutorial is to create a Database Tools MCP Server, secure it with domain and application roles, and integrate with an MCP client such as the Cline extension in Visual Studio Code.

By the end, you will have:

• An MCP Server with a Database Tools connection
• A toolset (Built-in SQL tools)
• Users or groups mapped to Application Roles
• An MCP client that connects to the server using a Personal Access Token or Token-based Authentication.