SQLite-MCP

# SQLite MCP Server [](https://www.python.org/)  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](https://www.anthropic.com/claude) ### Installation 1. **Clone the Repository** ```bash 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: ```bash 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: ```python # Define database path DATABASE_PATH = Path("your_database_name.db") ``` ### Running the Server Start the MCP server with the following command: ```bash 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](https://github.com/your-username/sqlite-mcp-server/issues). ## License This project is licensed under the MIT License. See the [LICENSE](LICENSE) file for details. ## Contact For questions or support, please reach out via the [GitHub Issues page](https://github.com/your-username/sqlite-mcp-server/issues) or contact the maintainer at dharshanathi21@gmail.com.