Sqlite Database

🚀 SQLite MCP Server

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

Don't know what MCP is? Check out the "What is MCP?" section below.

✨ Features

📦 Installation and Setup

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

Since this project is not yet published as an npm package, 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 configuration file:

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

If you're not sure what this JSON file is, you may need to check the "Tutorial: Using with Claude Desktop Setup" section.

3. Restart Your AI Client

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

📚 Documentation

What is MCP?

Model Context Protocol (MCP) is a standardized approach for AI models to interact with external tools and services. It allows AI assistants to perform operations such as running database queries, accessing external APIs, or file operations through a defined protocol interface, without integrating these functions directly into the AI model.

MCP extends the capabilities of AI beyond conversations, providing structured access to tools and data sources without direct integration into the AI model itself.

Tutorial: Using with Claude Desktop Setup

Claude Desktop is an AI client that supports MCP servers. Here's how to set it up on Windows:

1. Press Windows Key + R to open the Run dialog box.
2. Enter %appdata%\Claude and press Enter.
3. Create a new file named claude_desktop_config.json if it doesn't exist.
4. Add the configuration from the setup instructions in Step 2.
5. Save the file and restart Claude Desktop.
6. You should now see the SQLite tool in the Claude interface.

📄 License

This project is released under the MIT License.

🤝 Contribution

This project was primarily created for learning purposes. However, if you'd like to contribute, please submit a pull request, and I'll review it.

Thank you for your interest!