MCP SQLite Tool

A VS Code extension that enables AI agents to interact with SQLite databases through the Model Context Protocol (MCP).

What is this?

This extension installs and manages the mcp-sqlite-tool server, which allows AI assistants like Claude to read, query, and manipulate SQLite database files directly from your VS Code workspace.

Quick Start

1. Install the extension from the VS Code marketplace
2. Run the setup command - Press Ctrl+Shift+P and type "mcp-sqlite: Install & Configure Server"
3. Choose configuration scope - Global (for all projects) or Workspace (current project only)
4. Start the server - The extension will prompt you to start the server automatically

Available Commands

Press Ctrl+Shift+P and type "mcp-sqlite:" to see all available commands:

• mcp-sqlite: Install & Configure Server - Install the Python package and add server to MCP configuration
• mcp-sqlite: Start Server - Start the MCP SQLite server
• mcp-sqlite: Stop Server - Stop the running server
• mcp-sqlite: Restart Server - Restart the server
• mcp-sqlite: Check Server Status - View current server status
• mcp-sqlite: Edit Configuration - Open mcp.json file to edit MCP server configuration

Requirements

• Python 3.7+ with pip installed
• VS Code 1.102.0 or newer
• AI assistant that supports MCP (like Claude Desktop)

How it works

1. The extension installs the mcp-sqlite-tool Python package via pip
2. Adds the server configuration to your MCP configuration file (mcp.json)
3. Your AI assistant can then connect to the server to interact with SQLite files
4. AI can read schemas, execute queries, and manage database files in your workspace

Configuration

The server is added to your MCP configuration under the servers section in either:

• Global: %USERPROFILE%\AppData\Roaming\Code\User\mcp.json (Windows)
• Workspace: .vscode/mcp.json in your current workspace

You can choose to install it globally (all workspaces) or locally (current workspace only).

Configuration Format

The extension adds this configuration to your mcp.json file:

{
 "servers": {
  "sqlite-query": {
   "command": "mcp-sqlite-tool",
   "type": "stdio"
  }
 }
}

Support

For issues or questions, please visit our mrbean.dev.