Skip to content

MCP Server Integration

Set up the Model Context Protocol server for AI-assisted development with Claude, ChatGPT, and other AI development tools.


Overview

The VBASoftware MCP Server integrates with the Model Context Protocol (MCP) to make VBASoftware's API and SDK definitions available to AI development tools such as Claude, ChatGPT, Cursor, and other AI-enabled IDEs.

This allows AI assistants to understand your APIs, generate accurate code, and guide integrations — without ever accessing production data or client systems.


What is MCP?

The Model Context Protocol (MCP) is an open standard that enables AI tools to securely access structured context about APIs, SDKs, and documentation.

The VBASoftware MCP server is available at:

https://vbasoftware-dev-api.redocly.app/mcp

How MCP Works

  1. Context Provider (VBASoftware MCP Server) exposes API schemas and documentation
  2. AI Tool (Claude, ChatGPT, IDE) connects to the MCP server
  3. Enhanced Development - AI has full context about VBAPI capabilities
  4. Code Generation - AI can generate accurate, working code examples

VBASoftware MCP Benefits

  • SDK Awareness — AI assistants understand available API endpoints, models, and parameters
  • Accurate Code Generation — Generate working API calls in your preferred language
  • Documentation Context — AI can reference the same SDK docs and schemas used by developers
  • Safe Integration — No runtime data access or client system exposure

🔌 VBASoftware MCP Capabilities

API-Aware Development

  • Exposes OpenAPI and SDK metadata to AI tools
  • Enables assistants to generate correct API calls, authentication headers, and response handling code
  • Supports context-specific examples (e.g., "Show me how to create an enrollment in C#")

Safe by Design

  • No access to client databases or live data
  • No real API calls are executed through the MCP connection
  • Provides documentation-only context for code generation
  • Read-only access to API schemas and documentation

Setting Up MCP Integration

MCP Server Endpoint

The VBASoftware MCP server is available at:

https://vbasoftware-dev-api.redocly.app/mcp

Quick Setup

Most MCP-compatible tools allow adding an HTTP MCP server via a simple configuration entry. Below is an example for configuring an MCP server within Visual Studio. Consult your development environment's documentation for configuring MCP servers.

Visual Studio .mcp.json file.

{
  "inputs": [],
  "servers": {
    "vbasoftware-api": {
      "type": "http",
      "url": "https://dev-vbapi-docs.vbasoftware.com/mcp",
      "headers": {}
    }
  }
}

The MCP integration transforms AI-assisted development from generic programming help to expert-level VBAPI guidance. Once configured, your AI tools become VBAPI specialists that can help with everything from initial learning to complex integration challenges.