sqlite-mcp-server
6
SQLite MCP Server is a Model Context Protocol server aimed at managing and analyzing SQLite databases. It features schema exploration, data management, and statistical analysis. The server also implements several security measures to ensure safe operations.
SQLite MCP Server
A Model Context Protocol (MCP) server providing comprehensive SQLite database management features. Capabilities include:
Features
- Schema Exploration
- Listing tables in the database
- Viewing detailed schema information
- Examining column types and constraints
- Data Management
- Executing read-only SQL queries
- Performing data modifications (UPDATE, INSERT, DELETE)
- Ensuring safe execution with error handling
- Data Analysis
- Conducting basic statistical analysis
- Detailed analysis including categorical data distributions
- Automatic type detection and statistical measures
Prerequisites
- Python 3.8 or higher
- SQLite database file
- Optional: Claude Desktop for integration
Installation
- Install required Python packages.
- Download the SQLite MCP server script.
- Optional: Install for Claude Desktop integration.
Security Considerations
- Input validation for SQL operations
- Separation of read-only queries from modifications
- Error handling and SQL injection protection
Contributing
Contributions through Pull Requests are welcome.
License
Licensed under the MIT License.