SQLite MCP Server

A Model Context Protocol (MCP) server for SQLite databases.

Features

• Read Query: Execute SELECT queries
• Write Query: Execute INSERT, UPDATE, DELETE queries
• Create Table: Create new tables
• List Tables: List all tables in the database
• Explain Query: Explain query execution plans

Configuration

The server can be configured using environment variables or a .env file:

• DB_PATH: Path to the SQLite database file (default: ./data.db)
• SERVER_MODE: Server mode, either stdio (default), sse, or streamableHttp

Usage

1. Clone the repository
2. Install dependencies:

   go mod tidy
   

3. Run the server:

   go run .
   

Tools

• read_query: Execute a SELECT query
  • query: The SQL query string
• write_query: Execute an INSERT/UPDATE/DELETE query
  • query: The SQL query string
• create_table: Create a new table
  • schema: The CREATE TABLE statement
• list_tables: List all tables
• explain_query: Explain a query plan
  • query: The SQL query to explain