SQLite MCP Server

An user-friendly Python-based MCP server that enables natural language interaction with local SQLite databases through the Claude Desktop application. This project simplifies data analysis and exploration by translating plain English queries into SQL, eliminating the need for manual query writing.

Features

• Natural Language Processing: Query your database using intuitive, plain English questions.
• Local SQLite Integration: Seamlessly connect to any SQLite database file stored on your local system.
• Privacy and Security: All data operations are performed locally, ensuring your data remains private and secure.
• User-Friendly Setup: Straightforward installation and configuration process for quick setup.

Demo

How It Works

The SQLite MCP Server leverages the mcp (Model Context Protocol) library to expose your SQLite database as a set of accessible tools for Claude Desktop. When a natural language query is submitted via Claude Desktop, the server translates it into an optimized SQL query, executes it against the specified database, and returns the results in a clear, human-readable format.

Getting Started

Prerequisites

• Python: Version 3.10 or higher
• Claude Desktop: Available from Anthropic

Installation

1. Clone the Repository

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

2. Install Dependencies

   Ensure you have Python 3.10+ installed, then run:

   pip install -r requirements.txt
   

Configuration

1. Database Placement

   Place your SQLite database file (e.g., your_database_name.db) in the root directory of the project.

2. Update Configuration

   Open the sqlite_mcp_server.py file and set the DATABASE_PATH variable to the name of your database file:

   # Define database path
   DATABASE_PATH = Path("your_database_name.db")
   

Running the Server

Start the MCP server with the following command:

mcp install sqlite_mcp_server.py

This command initializes the server, making it available for Claude Desktop to connect and process queries.

Usage

Once the server is running, connect to it via Claude Desktop and begin exploring your data with natural language queries. Example queries include:

• "List all tables in the database."
• "Show the columns in the 'customers' table."
• "Find all customers located in London."
• "Calculate the total number of orders."

The server will translate these queries into SQL, execute them, and return the results directly in Claude Desktop.

Contributing

We welcome contributions from the community! To contribute:

1. Fork the repository.
2. Create a new branch for your feature or bug fix (git checkout -b feature/your-feature-name).
3. Commit your changes (git commit -m "Add your feature").
4. Push to your branch (git push origin feature/your-feature-name).
5. Open a pull request with a detailed description of your changes.

For bug reports or feature requests, please open an issue on the GitHub repository.

License

This project is licensed under the MIT License. See the LICENSE file for details.

Contact

For questions or support, please reach out via the GitHub Issues page or contact the maintainer at dharshanathi21@gmail.com.