3D MCP Cursor Visualization
SQLite MCP Logo - AI-Powered Development Tool for Cursor IDE

SQLite MCP

Model Context Protocol Integration

Overview

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.

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