Quickstart
Get started with MCP in less than 5 minutes
MCP is a protocol that enables secure connections between host applications, such as Claude Desktop, and local services. In this quickstart guide, you’ll learn how to:
- Set up a local SQLite database
- Connect Claude Desktop to it through MCP
- Query and analyze your data securely
While this guide focuses on using Claude Desktop as an example MCP host, the protocol is open and can be integrated by any application. IDEs, AI tools, and other software can all use MCP to connect to local integrations in a standardized way.
Claude Desktop’s MCP support is currently in developer preview and only supports connecting to local MCP servers running on your machine. Remote MCP connections are not yet supported. This integration is only available in the Claude Desktop app, not the Claude web interface (claude.ai).
How MCP works
MCP (Model Context Protocol) is an open protocol that enables secure, controlled interactions between AI applications and local or remote resources. Let’s break down how it works, then look at how we’ll use it in this guide.
General Architecture
At its core, MCP follows a client-server architecture where a host application can connect to multiple servers:
- MCP Hosts: Programs like Claude Desktop, IDEs, or AI tools that want to access resources through MCP
- MCP Clients: Protocol clients that maintain 1:1 connections with servers
- MCP Servers: Lightweight programs that each expose specific capabilities through the standardized Model Context Protocol
- Local Resources: Your computer’s resources (databases, files, services) that MCP servers can securely access
- Remote Resources: Resources available over the internet (e.g., through APIs) that MCP servers can connect to
In This Guide
For this quickstart, we’ll implement a focused example using SQLite:
- Claude Desktop acts as our MCP client
- A SQLite MCP Server provides secure database access
- Your local SQLite database stores the actual data
The communication between the SQLite MCP server and your local SQLite database happens entirely on your machine—your SQLite database is not exposed to the internet. The Model Context Protocol ensures that Claude Desktop can only perform approved database operations through well-defined interfaces. This gives you a secure way to let Claude analyze and interact with your local data while maintaining complete control over what it can access.
Prerequisites
- macOS or Windows
- The latest version of Claude Desktop installed
- uv 0.4.18 or higher (
uv --version
to check) - Git (
git --version
to check) - SQLite (
sqlite3 --version
to check)
Installation
Create a sample database
Let’s create a simple SQLite database for testing:
Configure Claude Desktop
Open your Claude Desktop App configuration at ~/Library/Application Support/Claude/claude_desktop_config.json
in a text editor.
For example, if you have VS Code installed:
Add this configuration (replace YOUR_USERNAME with your actual username):
This tells Claude Desktop:
- There’s an MCP server named “sqlite”
- Launch it by running
uvx mcp-server-sqlite
- Connect it to your test database
Save the file, and restart Claude Desktop.
Test it out
Let’s verify everything is working. Try sending this prompt to Claude Desktop:
Claude Desktop will:
- Connect to the SQLite MCP server
- Query your local database
- Format and present the results
Claude Desktop successfully queries our SQLite database 🎉
What’s happening under the hood?
When you interact with Claude Desktop using MCP:
-
Server Discovery: Claude Desktop connects to your configured MCP servers on startup
-
Protocol Handshake: When you ask about data, Claude Desktop:
- Identifies which MCP server can help (sqlite in this case)
- Negotiates capabilities through the protocol
- Requests data or actions from the MCP server
-
Interaction Flow:
-
Security:
- MCP servers only expose specific, controlled capabilities
- MCP servers run locally on your machine, and the resources they access are not exposed to the internet
- Claude Desktop requires user confirmation for sensitive operations
Try these examples
Now that MCP is working, try these increasingly powerful examples:
Add more capabilities
Want to give Claude Desktop more local integration capabilities? Add these servers to your configuration:
Note that these MCP servers will require Node.js to be installed on your machine.
More MCP Clients
While this guide demonstrates MCP using Claude Desktop as a client, several other applications support MCP integration:
Zed Editor
A high-performance, multiplayer code editor with built-in MCP support for AI-powered coding assistance
Cody
Code intelligence platform featuring MCP integration for enhanced code search and analysis capabilities
Each host application may implement MCP features differently or support different capabilities. Check their respective documentation for specific setup instructions and supported features.
Troubleshooting
Next steps
Was this page helpful?