SQLite MCP

SQLite Features

•SQL query execution
•Table creation and management
•Schema inspection
•Business insights generation
•Continuous memo updates
•Interactive demonstration mode
•Automatic sample data generation

SQLite Setup & Configuration

Requirements

•UV package manager or Docker
•Claude Desktop
•SQLite database file

Installation Instructions

# UV Installation
uv run mcp-server-sqlite --db-path ~/test.db

# Docker Installation
docker build -t mcp/sqlite .
docker run --rm -i -v mcp-test:/mcp mcp/sqlite --db-path /mcp/test.db

Configuration

# UV Configuration
{
  "mcpServers": {
    "sqlite": {
      "command": "uv",
      "args": [
        "--directory",
        "parent_of_servers_repo/servers/src/sqlite",
        "run",
        "mcp-server-sqlite",
        "--db-path",
        "~/test.db"
      ]
    }
  }
}

# Docker Configuration
{
  "mcpServers": {
    "sqlite": {
      "command": "docker",
      "args": [
        "run",
        "--rm",
        "-i",
        "-v",
        "mcp-test:/mcp",
        "mcp/sqlite",
        "--db-path",
        "/mcp/test.db"
      ]
    }
  }
}

SQLite Available Tools

•read_query
•write_query
•create_table
•list_tables
•describe-table
•append_insight

SQLite Required Inputs

query

Type: string
Description: SQL query to execute
Required: Yes

table_name

Type: string
Description: Name of table for schema operations
Required: No

insight

Type: string
Description: Business insight to append to memo
Required: No

SQLite Use Cases

•Database querying and analysis
•Schema management
•Business intelligence
•Data exploration
•Automated insights generation
•Database administration
•Sample data testing

Frequently Asked Questions

A Model Context Protocol server implementation that provides database interaction and business intelligence capabilities through SQLite. This server enables running SQL queries, analyzing business data, and automatically generating business insight memos.

UV package manager or Docker, Claude Desktop, SQLite database fileView detailed requirements

Follow the installation instructions in the setup section above.View installation guide

SQLite MCP provides the following tools:

•read_query
•write_query
•create_table
•list_tables
•describe-table
•append_insight

Featured MCPs

Github

This server provides integration with Github's issue tracking system through MCP, allowing LLMs to interact with Github issues.

Sequential Thinking

An MCP server implementation that provides a tool for dynamic and reflective problem-solving through a structured thinking process. Break down complex problems into manageable steps, revise and refine thoughts as understanding deepens, and branch into alternative paths of reasoning.

Puppeteer

A Model Context Protocol server that provides browser automation capabilities using Puppeteer. This server enables LLMs to interact with web pages, take screenshots, execute JavaScript, and perform various browser-based operations in a real browser environment.

Overview