Back to Directory/Developer Tools

io.github.daedalus/mcp-sqlite3

MCP server exposing sqlite3 library functionality

Developer ToolsPythonv0.1.3

mcp-sqlite3

MCP server exposing sqlite3 library functionality

PyPI Python Ruff

Install

pip install mcp-sqlite3

Usage

from mcp_sqlite3 import mcp_server

mcp_server.run()

CLI

mcp-sqlite3 --help

API

Exposes complete sqlite3 functionality as MCP tools.

Connection Tools

  • connect_database - Open a database connection
  • close_connection - Close a database connection
  • commit / rollback - Transaction control

SQL Execution Tools

  • execute_query - Execute a query and return results
  • execute_many - Execute with multiple parameter sets
  • execute_script - Execute a SQL script

Schema Tools

  • list_tables - List all tables
  • get_table_info - Get table schema
  • create_table / drop_table - DDL operations

CRUD Tools

  • insert_row / update_rows / delete_rows / select_rows

Development

git clone https://github.com/daedalus/mcp-sqlite3.git
cd mcp-sqlite3
pip install -e ".[test]"

# run tests
pytest

# format
ruff format src/ tests/

# lint
ruff check src/ tests/

# type check
mypy src/

MCP Server

mcp-name: io.github.daedalus/mcp-sqlite3

Installation

Source-derived launch command. Check the maintainer’s required arguments and credentials before running:

bash
uvx mcp-sqlite3

Set up in your AI client

Merge this template into ~/Library/Application Support/Claude/claude_desktop_config.json. Keep existing servers. Add any arguments, credentials, and permissions required by the maintainer; this template has not been install-tested.

json
{
  "mcpServers": {
    "io-github-daedalus-mcp-sqlite3": {
      "command": "uvx",
      "args": [
        "mcp-sqlite3"
      ]
    }
  }
}

Restart Claude Desktop completely for changes to take effect. Confirm the server appears connected in the client’s tool list, then try a read-only example from its documentation.

Claude Desktop setup reference

Package

mcp-sqlite3pypi

Compatible MCP Clients

io.github.daedalus/mcp-sqlite3 works with any MCP-compatible client. Copy the config snippet from the Configuration section above and add it to the file shown for your client, then restart the application.

  • Claude Desktop~/Library/Application Support/Claude/claude_desktop_config.jsonRestart Claude Desktop completely for changes to take effect.
  • Cursor~/.cursor/mcp.jsonRestart Cursor for changes to take effect.
  • VS Code.vscode/mcp.jsonReload VS Code window for changes to take effect.
  • Windsurf~/.codeium/windsurf/mcp_config.jsonRestart Windsurf for changes to take effect.
  • Claude Code.mcp.jsonSave at the project root, then start Claude Code in that project and review the MCP server approval prompt. Keep real credentials out of shared files.

Learn More