mcp-sqlite is a Model Context Protocol (MCP) server designed to provide comprehensive SQLite database interaction capabilities. It allows users to perform database operations through the MCP protocol, including full CRUD (Create, Read, Update, Delete) operations, database exploration and introspection, and execution of custom SQL queries.
Key capabilities:
- Database information: retrieve detailed information about the connected database, list all tables, and obtain table schema details.
- CRUD operations: insert new records, query records (with filtering, limit, and offset support), update records, and delete records.
- Custom SQL: execute custom SQL queries with support for parameterized queries.
Usage: Define the command in the MCP server settings of your IDE and provide the database path as an argument. For specific configuration instructions, please refer to the project documentation.
Applicable scenarios: Suitable for developers who need to interact with SQLite databases through the MCP protocol, for example, directly operating the database in an MCP-enabled IDE.
Limitations: Information regarding platform compatibility, performance limitations, pricing models, etc., is not yet available.
