How to Use MCP Server in VSCode: Setup Guide for 2026

MCP (Model Context Protocol) servers let Claude read your business data directly—Shopify inventory, Google Sheets invoices, Gmail—so you can ask questions and get answers from real numbers. Setting one up in VSCode means editing a configuration file and pasting a few lines. The barrier isn’t technical complexity; it’s that most guides assume you know what JSON is, where VSCode keeps its settings, and why you need a file path. This one starts from zero.

The first time takes longer because you’re learning where the files live. After that, adding a new server is two minutes.

MCP Server vs. Standard Claude: What You Actually Get

Feature	Standard Claude (claude.ai)	Claude with MCP Server in VSCode
Data access	Only what you paste into the chat window	Live connection to your business tools (Sheets, Shopify, databases)
Setup time	Zero—open browser, start typing	First server takes longer (authentication setup); subsequent servers are faster
Cost	$20/month for Claude Pro, or free tier	Same $20/month Pro subscription + VSCode (free) + MCP server software (mostly free, some paid integrations)
Use cases	Writing, brainstorming, one-off questions	“Show me last month’s top-selling products”, “Draft replies to unread support emails”, “Update inventory counts”
Technical requirement	None	Comfortable editing a text file, following file path instructions
Privacy	You control what you paste	MCP server reads from connected tools—review permissions carefully
Mobile access	Works on phone, tablet	Desktop only (VSCode requirement)

Pick Standard Claude If…

You’re writing product descriptions, blog posts, or customer emails where you paste the context yourself. The browser interface is faster to open than VSCode, works on your phone during commutes, and doesn’t require any file management. If your workflow is “write this based on these three paragraphs I’m giving you,” the MCP setup adds nothing.

You also avoid the privacy trade-off: MCP servers request broad access to connected tools (“read all files in this Google Drive folder”, “access all Shopify orders”). Standard Claude sees only what you explicitly paste.

Pick MCP Server in VSCode If…

You ask Claude the same data questions weekly—”which products had the most returns?”, “how many support tickets mentioned shipping delays?”, “what’s our inventory value right now?” With an MCP server, Claude pulls current numbers instead of you exporting a CSV, pasting it, and explaining the column headers every time.

The win is repetitive reporting and multi-step workflows. Example: a business owner who connects Claude to Airtable (project tracker), Stripe (payment history), and Gmail could prompt: “Draft a status email for projects due this week, include outstanding invoices over $500.” Claude would compose it with real project names and dollar amounts pulled from those sources. The value is in eliminating the manual export-and-paste loop.

Where Each Option Falls Short

Standard Claude makes you the data courier. Every question needs a fresh export. If your answer depends on cross-referencing two tools (Shopify orders + Stripe refunds), you’re downloading two CSVs, pasting both, and writing a prompt that explains how they relate. By the third time, you’re annoyed.

MCP in VSCode is desktop-only, so you can’t check a quick number from your phone. The setup documentation uses developer jargon (“clone the repo”, “install dependencies”) without explaining what those words mean. Anthropic maintains an official list of MCP servers at github.com/anthropics/anthropic-mcp-servers, but finding one for your tools means searching GitHub or hoping someone built it. If you use a niche platform (Kajabi, Teachable, Squarespace), you might find nothing pre-built. Writing your own MCP server requires Python or TypeScript, which defeats the “non-developer” premise.

The privacy model is also coarser than standard Claude. You grant the MCP server access to an entire tool (all Google Sheets, all Shopify data), not individual files. If you share your laptop, anyone opening VSCode can query that data.

Step-by-Step: Setting Up Your First MCP Server in VSCode

1. Install VSCode and the Claude Extension

Download Visual Studio Code from code.visualstudio.com (free, works on Windows, Mac, Linux). Open it, click the Extensions icon in the left sidebar (looks like four squares), search for “Claude”, and install the extension published by Anthropic. You’ll be prompted to sign in with your Claude Pro account. The free Claude tier does not support MCP servers as of September 2026.

2. Locate Your MCP Configuration File

This is the part that trips people up. VSCode stores MCP settings in a JSON file, and the location depends on your operating system:

• Windows: C:\Users\YourName\AppData\Roaming\Code\User\globalStorage\anthropic.claude\mcp_config.json
• Mac: ~/Library/Application Support/Code/User/globalStorage/anthropic.claude/mcp_config.json
• Linux: ~/.config/Code/User/globalStorage/anthropic.claude/mcp_config.json

Replace YourName with your actual Windows username. On Mac, the Library folder is hidden by default—in Finder, hold Option and click the Go menu to reveal it. If the file doesn’t exist yet, create a new text file at that path and name it mcp_config.json.

3. Choose and Install an MCP Server

Anthropic maintains a list at github.com/anthropics/anthropic-mcp-servers. Pre-built options include Google Drive, Slack, PostgreSQL databases, GitHub, and Filesystem (local files). Third-party developers have added Shopify, Airtable, and Notion servers—search “MCP server” + your tool name on GitHub.

For this example, we’ll use the Google Sheets MCP server. Most MCP servers are Node.js or Python scripts. The Sheets server requires Node.js installed on your computer—download from nodejs.org (the LTS version, currently 20.17 in September 2026). After installing Node, open your terminal (Command Prompt on Windows, Terminal on Mac) and run:

npm install -g @anthropic/mcp-server-google-sheets

The -g flag installs it globally so VSCode can find it. The command finishes with a confirmation message showing the install path.

4. Edit the Configuration File

Open mcp_config.json in any text editor (Notepad, TextEdit, or VSCode itself). Paste this structure:

{
  "mcpServers": {
    "google-sheets": {
      "command": "node",
      "args": [
        "/usr/local/lib/node_modules/@anthropic/mcp-server-google-sheets/dist/index.js"
      ],
      "env": {
        "GOOGLE_APPLICATION_CREDENTIALS": "/Users/YourName/Documents/google-credentials.json"
      }
    }
  }
}

What each piece does:

• "google-sheets": A name you choose. This is how you’ll refer to this server in Claude. Use lowercase, no spaces.
• "command": "node": Tells VSCode to run this server using Node.js.
• "args": The file path to the MCP server code you just installed. On Windows, it’s usually C:\Users\YourName\AppData\Roaming\npm\node_modules\@anthropic\mcp-server-google-sheets\dist\index.js. On Mac, run npm root -g in Terminal to find the exact path, then add /@anthropic/mcp-server-google-sheets/dist/index.js to the end.
• "env": Environment variables the server needs. Google Sheets requires authentication credentials (see next step).

5. Set Up Authentication

The Google Sheets MCP server needs permission to read your spreadsheets. Go to console.cloud.google.com, create a new project (name it “Claude MCP” or similar), enable the Google Sheets API, and create a service account. Download the JSON key file—it’s a text file with your credentials. Save it somewhere permanent (Documents folder works) and paste that full file path into the GOOGLE_APPLICATION_CREDENTIALS line above.

Google Cloud Console walks you through each screen, but if you’ve never used it, expect to click through several admin panels. The documentation at cloud.google.com/iam/docs/service-accounts-create covers service account creation step-by-step.

6. Restart VSCode and Test

Close and reopen VSCode. Open the Claude panel (click the Claude icon in the left sidebar). You should see “google-sheets” listed under Available MCP Servers. In the chat, type: “List the sheets in [paste your Google Sheet URL here].” If it returns sheet names, it’s working.

Real Small Business Use Cases

A Shopify store owner who connects the Shopify MCP server could ask: “Which five products had the lowest stock levels yesterday?” Claude would return the list with current counts. Follow-up: “Draft a restock email to my supplier for those items.” The workflow eliminates the manual export from Shopify’s admin panel.

A freelance designer who connects Filesystem MCP (reads local folders) could ask: “How many client project folders did I create in August 2026?” Then: “Generate an invoice summary with project names and dates for my accountant.” Claude reads folder names and timestamps, formats the output. This replaces manually counting folders and typing names into a spreadsheet.

A newsletter writer who connects Gmail MCP could ask: “Summarize subscriber questions from the last seven days that mentioned ‘pricing.'” Claude scans, groups by theme, drafts an FAQ section. The alternative is searching Gmail manually, copying each email into a doc, and writing the summary yourself.

What Changed Recently and What to Watch

Anthropic released MCP in November 2025, but early documentation assumed developer audiences. In June 2026, they added the VSCode extension with a GUI for managing servers. Before that, you edited a hidden settings file manually with no validation—one typo broke everything. The extension shows which servers are running and surfaces error messages when authentication fails.

As of September 2026, Anthropic’s official server list includes options for Google Drive, Slack, PostgreSQL, GitHub, and Filesystem. Third-party developers have published Shopify, Airtable, and Notion servers on GitHub. The count grows weekly—search “MCP server” on GitHub to see current options. Zapier announced an MCP server beta in August 2026 according to their blog, which would connect Claude to their app directory indirectly. No public release date yet.

The authentication step remains the biggest friction point. Google, Microsoft, and Shopify all require OAuth or service account setup, each with different steps. Anthropic has hinted at a simplified auth flow coming in late 2026, but no specifics yet.

Frequently Asked Questions

How do I use an MCP server in VSCode?

Install VSCode and the Claude extension from Anthropic, then edit the mcp_config.json file (location varies by OS—see Step 2 above) to add your chosen MCP server. You’ll paste a configuration block that tells VSCode where the server code lives and what credentials it needs. Restart VSCode, and the server appears in the Claude panel. Type a question that requires data from the connected tool—Claude fetches it live instead of you pasting a CSV.

What is an MCP server and why would I use it?

An MCP (Model Context Protocol) server is a small program that connects Claude to external tools like Google Sheets, Shopify, or your email. Instead of copying data into Claude manually, the MCP server fetches it live. You’d use it if you ask Claude the same data-driven questions repeatedly—sales reports, inventory checks, email summaries—and you’re tired of exporting CSVs every time. It turns Claude into a business intelligence assistant that works with your actual numbers.

Do I need coding experience to set up an MCP server in VSCode?

No, but you need to be comfortable editing a text file and following file path instructions carefully. The setup involves pasting a configuration block into a JSON file and replacing placeholder paths with your actual folder locations. If you’ve ever edited a WordPress config file or followed a “how to install a mod” guide, you have the skills. The hardest part is the authentication step (getting API credentials from Google, Shopify, etc.), which is clicking through admin panels, not writing code.

What’s the difference between MCP server and regular Claude?

Regular Claude (claude.ai in a browser) only sees what you paste into the chat. An MCP server in VSCode lets Claude read directly from connected tools—your spreadsheets, databases, email—without you copying data over. Regular Claude is faster for one-off questions. MCP Claude is better for recurring reports or questions that need current data from multiple sources. You’re trading setup time for permanent convenience on repetitive tasks.

Can I use MCP servers with Claude for my small business?

Yes, if you have a Claude Pro subscription ($20/month as of September 2026). The free Claude tier doesn’t support MCP servers. Small business use cases include connecting Claude to Shopify for inventory questions, Google Sheets for sales tracking, Gmail for customer support triage, or Airtable for project status reports. The limitation is finding a pre-built MCP server for your specific tools—popular platforms are covered, niche ones might not be.

Where can I find pre-built MCP servers to install?

Anthropic’s official list is at github.com/anthropics/anthropic-mcp-servers, covering Google Drive, Slack, PostgreSQL, GitHub, and Filesystem as of September 2026. For third-party servers, search GitHub for “MCP server” + your tool name. The community subreddit r/ClaudeAI maintains a crowdsourced list. Expect more SaaS companies to publish official MCP servers through late 2026—Notion, Airtable, and HubSpot have all announced plans but no public release dates yet.

Photo by Diva Plavalaguna on Pexels