SQLite MCP Server

Name: SQLite MCP Server
Author: javsanmar5

@javsanmar5

About SQLite MCP Server

Implementation of an MCP (Model Context Protocol) Server for SQLite. It provides an AI model with context and the ability to execute SQL queries.

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "mcp-server.sqlite": {
      "command": "docker",
      "args": [
        "build",
        "-t",
        "mcp/sqlite",
        "."
      ]
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is SQLite MCP Server?

A Model Context Protocol (MCP) server implemented in TypeScript that provides an interactive interface for executing SQL queries, managing database schemas, and synthesizing business insights from an SQLite database. It is designed for AI clients that support MCP, such as Claude Desktop.

How to use SQLite MCP Server?

Clone the repository, build the Docker image (docker build -t mcp/sqlite .), then add the provided JSON configuration to your AI client’s configuration file, specifying --db-path (e.g., test_db.sqlite3). After restarting the client, the tools list_tables and read_query become available.

Key features of SQLite MCP Server

list_tables – lists all tables in the SQLite database
read_query – executes SELECT queries on the database
Runs as a Docker container for easy deployment
Integrates with MCP‑compatible AI clients like Claude Desktop

Use cases of SQLite MCP Server

Querying a SQLite database directly from an AI assistant
Listing all tables to understand database structure
Running SELECT queries with conditions (e.g., SELECT * FROM users WHERE age > 18)
Synthesizing business insights from database content via AI

FAQ from SQLite MCP Server

What is MCP?

Model Context Protocol (MCP) is a standardized way for AI models to interact with external tools and services. It allows AI assistants to perform actions like running database queries through a defined protocol interface.

How do I set up SQLite MCP Server with Claude Desktop?

On Windows, press Win+R, type %appdata%\Claude, create or edit claude_desktop_config.json with the Docker configuration shown in the README, save, and restart Claude Desktop.

Where is the database file stored?

The database is inside the Docker container at the path specified by --db-path. The volume mount -v mcp-test:/mcp persists data across container restarts.