Skip to main content
Glama
mgcrea

mcp-sqlite

by mgcrea

mcp-sqlite

MCP tool server providing SQLite database access for AI agents.

Tools

Tool

Description

sqlite_query

Execute SQL queries (read-only by default)

sqlite_list_tables

List all tables in the database

sqlite_describe_table

Get the schema/structure of a table

Related MCP server: mcp-sqlite

Configuration

Variable

Default

Description

SQLITE_DB_PATH

data.db

Path to the SQLite database file

SQLITE_READONLY

true

Enforce read-only mode

MCP_PORT

8080

HTTP server port

MCP_HOST

0.0.0.0

HTTP server host

MCP_TRANSPORT

http

Transport mode: http or stdio

Set SQLITE_READONLY=false to enable read/write mode (INSERT, UPDATE, DELETE, etc.).

Development

make install   # Install dependencies
make server    # Run HTTP server
make stdio     # Run in stdio mode
make lint      # Lint code
make format    # Format code
make spec      # Run tests

Usage with .mcp.json

{
  "mcpServers": {
    "sqlite": {
      "type": "stdio",
      "command": "docker",
      "args": [
        "run", "--rm", "-i",
        "-v", "/path/to/data.db:/data/data.db:ro",
        "-e", "MCP_TRANSPORT=stdio",
        "-e", "SQLITE_DB_PATH=/data/data.db",
        "ghcr.io/mgcrea/mcp-sqlite"
      ]
    }
  }
}

Docker

make docker-build
make docker-run

Related MCP Connectors

Related MCP Servers

  • A
    license
    Not graded
    quality
    C
    maintenance
    An MCP server that enables AI agents to interact with SQLite databases by querying schemas, executing SQL, and inspecting table metadata. It supports safe database access through configurable read-only modes, query timeouts, and dry-run execution plans.
    MIT
  • F
    license
    Not graded
    quality
    D
    maintenance
    MCP server that provides SQLite database operations. Allows AI assistants to query, modify and manage SQLite databases through the Model Context Protocol.
    -
  • A
    license
    Not graded
    quality
    C
    maintenance
    An MCP server providing SQLite database access for AI agents, enabling SQL execution, schema inspection, CRUD operations, and data export.
    MIT