Skip to main content
Glama
mgcrea

mcp-sqlite

by mgcrea
OverviewSchemaRelated ServersScoreDiscussions
Python

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-server-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

This server cannot be installed

A
license - permissive license
-
quality - not tested
D
maintenance

How are these scores calculated?

Maintenance

–Maintainers
–Response time
–Release cycle
–Releases (12mo)
Commit activity

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/mgcrea/mcp-sqlite'

If you have feedback or need assistance with the MCP directory API, please join our Discord server