SQLite

About

SQLite-MCP-Server is a general-purpose tool designed to manage SQLite databases by exposing SQL execution capabilities via the MCP protocol. It offers robust functionality including support for all common SQL operations (SELECT, INSERT, UPDATE, DELETE, CREATE), built-in protection against SQL injection through parameterized queries, and flexible communication options like stdio, Server-Sent Events (SSE), and streamable-HTTP. This allows developers to integrate SQLite database interactions into diverse applications with ease, providing a standardized and secure interface for database operations.

Key Features

• Execute arbitrary valid SQL queries, including SELECT, INSERT, UPDATE, DELETE, and CREATE
• Built-in protection against SQL injection using parameterized queries
• Supports multiple communication modes: stdio, Server-Sent Events (SSE), and streamable-HTTP
• Configurable IP address, port, and logging level for server operation
• Automatic creation of a 'demo.db' SQLite database file upon service startup
• 0 GitHub stars

Use Cases

• Programmatically interacting with SQLite databases from external applications or services
• Developing custom applications that require secure and standardized SQL execution capabilities
• Integrating SQLite database operations into systems utilizing various communication protocols like HTTP-based streams