SQLite MCP Server

Name: SQLite MCP Server
Author: javsanmar5

@javsanmar5

关于 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.

基本信息

分类

数据库

许可证

MIT

运行时

node

传输方式

stdio

发布者

javsanmar5

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

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

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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.