SQLite MCP Server

Stabledatabase

★1420 starsTypeScriptAnthropic

About

Overview

The SQLite MCP Server provides tools for AI agents to work with SQLite databases. Designed for local data analysis and business intelligence, it supports creating tables, inserting data, running analytical queries, and maintaining a memo system for tracking insights discovered during analysis sessions. Perfect for lightweight data exploration and prototyping.

Capabilities

Tools & Capabilities

⚡read_query

Execute a SELECT query to read data from the database

⚡write_query

Execute an INSERT, UPDATE, or DELETE query

⚡create_table

Create a new table in the database

⚡list_tables

List all tables in the database

⚡describe_table

Get the schema of a specific table

⚡append_insight

Add a business insight memo to the analysis log

Setup

Installation

bash

Install

npx -y @modelcontextprotocol/server-sqlite /path/to/database.db

Examples

Example Usage

javascript

Usage

Add to your Claude Desktop config:
{
  "mcpServers": {
    "sqlite": {
      "command": "npx",
      "args": ["-y", "@modelcontextprotocol/server-sqlite", "./analysis.db"]
    }
  }
}

Quick Info

AuthorAnthropic

LanguageTypeScript

StatusStable

Stars★ 1420

Last UpdatedFeb 12, 2026