SQLite MCP Server

@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.

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.

What commands does SQLite MCP Server expose?

It exposes two commands: list_tables (list all tables) and read_query (execute SELECT queries).

What runtime or dependencies are required?

The server is distributed as a Docker image, so Docker is required. No additional runtime setup is needed beyond building or pulling the image.

Frequently asked questions

What is MCP?

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.

What commands does SQLite MCP Server expose?

It exposes two commands: `list_tables` (list all tables) and `read_query` (execute SELECT queries).

What runtime or dependencies are required?

The server is distributed as a Docker image, so Docker is required. No additional runtime setup is needed beyond building or pulling the image.

Comments

Basic information

More Databases MCP servers

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

617

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412

PostgreSQL Model Context Protocol (PG-MCP) Server

stuzero

540

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K