SQLite MCP Server

Integrations

Enables execution of SQL queries against an SQLite database, with support for SELECT operations to retrieve and analyze data stored in the database.

SQLite MCP Server

A Model Context Protocol (MCP) server implementation using TypeScript for interacting with an SQLite database. This server provides an interactive interface for executing SQL queries, managing database schemas, and synthesizing business insights—all within an extensible protocol framework.

Not familiar with MCP? Check out the What is an MCP? section below.

Features

Command	Description	Example
`list_tables`	List all tables on the SQLite database	-
`read_query`	Execute SELECT queries on the SQLite database	`SELECT * FROM users WHERE age > 18`

Installation & Setup

git clone https://github.com/javsanmar5/mcp-server.sqlite.git
cd mcp-server.sqlite

Since this hasn't been published as an npm package yet, we'll focus on the Docker installation method:

1. Build the Docker image

docker build -t mcp/sqlite .

2. Configure your AI client

Add the following to your AI client's configuration file:

"mcpServers": {
  "sqlite": {
    "command": "docker",
    "args": [
      "run",
      "--rm",
      "-i",
      "-v",
      "mcp-test:/mcp",
      "mcp/sqlite",
      "--db-path",
      "test_db.sqlite3"
    ]
  }
}

If you don't know what is that json file you might want to see the Client Configuration Guide.

3. Restart your AI client

After restarting, the MCP Tools should be available in your AI client's interface. On Windows, you may need to manually kill the process for the changes to take effect.

Documentation

What's an 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, accessing external APIs, or manipulating files through a defined protocol interface.

MCPs extend AI capabilities beyond conversation by providing structured access to tools and data sources without requiring direct integration into the AI model itself.

Tutorial: Setting up with Claude Desktop

Claude Desktop is one of many AI clients that support MCP servers. Here's how to set it up on Windows:

Press Windows Key + R to open the Run dialog
Type %appdata%\Claude and press Enter
Create a new file called claude_desktop_config.json if it doesn't exist already
Add the configuration from step 2 of the setup instructions above
Save the file and restart Claude Desktop
You should now see the SQLite tools available in your Claude interface

License

This project is licensed under the MIT License.

Contributing

This project was created primarily for learning purposes. However, if you'd like to contribute, feel free to submit a Pull Request and I'll review it.

Thanks for your interest!

This server cannot be installed

security - not tested

license - permissive license

quality - not tested

hybrid server

The server is able to function both locally and remotely, depending on the configuration or use case.

A Model Context Protocol server implementation that enables AI assistants to execute SQL queries and interact with SQLite databases through a structured interface.

Related MCP Servers

Cursor DB MCP Server
jbdamask
-
security
F
license
-
quality
A Model Context Protocol server that enables AI assistants to explore and interact with Cursor IDE's SQLite databases, providing access to project data, chat history, and composer information.
Last updated -
10
Python
MSSQL MCP Server
JexinSam
-
security
A
license
-
quality
A Model Context Protocol server that enables secure and structured interaction with Microsoft SQL Server databases, allowing AI assistants to list tables, read data, and execute SQL queries with controlled access.
Last updated -
20
Python
MIT License
SQLite MCP Server
jacksteamdev
A
security
A
license
A
quality
A Model Context Protocol server that provides database interaction capabilities through SQLite, enabling users to run SQL queries, analyze business data, and automatically generate business insight memos.
Last updated -
6
9
TypeScript
MIT License
Microsoft SQL Server MCP Server
RichardHan
A
security
A
license
A
quality
A Model Context Protocol server that enables secure interaction with Microsoft SQL Server databases, allowing AI assistants to list tables, read data, and execute SQL queries through a controlled interface.
Last updated -
1
108
Python
MIT License

View all related MCP servers

SQLite MCP Server