SQLite MCP Server
About
A Model Context Protocol (MCP) server implementation using TypeScript for interacting with an SQLite database. It provides an interactive interface for executing SQL queries, managing database schemas, and synthesizing business insights within an extensible protocol framework…
Details
- Author
- MCP-Mirror
- Downloads
- 117
- Categories
- Database
Jump to
- Supports SELECT queries via the read_query command
- Enables database schema management through MCP tools
- Runs inside a Docker container for easy deployment
- Configurable database file path (--db-path flag)
- Integrates with AI clients that support MCP (e.g., Claude Desktop)
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
SQLite MCP ServerCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Build the Docker image from the repository, then configure your AI client’s mcpServers JSON to run the container with command docker, arguments including mount volume and --db-path flag. After restarting the client, the MCP tools become available. On Windows you may need to manually kill the process for changes to take effect.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"sqlite mcp server": {
"santos-404_mcp-server.sqlite": {
"command": "docker",
"args": [
"build",
"-t",
"mcp/sqlite",
"."
]
}
}
}
}McpServers
{
"santos-404_mcp-server.sqlite": {
"command": "docker",
"args": [
"build",
"-t",
"mcp/sqlite",
"."
]
}
}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 |
|---------|-------------|---------|
| 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:
1. Press Windows Key + R to open the Run dialog
2. Type %appdata%\Claude and press Enter
3. Create a new file called claude_desktop_config.json if it doesn't exist already
4. Add the configuration from step 2 of the setup instructions above
5. Save the file and restart Claude Desktop
6. 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!
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
