SQLite MCP Server

Example Use Cases

• 1

  Execute read queries on SQLite databases.

• 2

  Perform write operations like insert, update, or delete on SQLite databases.

• 3

  Manage database schema by creating tables or listing existing tables.

Description

This MCP server allows execution of SQL queries including SELECT, INSERT, UPDATE, DELETE, and CREATE TABLE on SQLite databases. It supports listing tables and explaining query execution plans, facilitating database management and query optimization. The server can be configured via environment variables and supports multiple server modes such as stdio, sse, and streamableHttp.