Skip to main content
Glama
mcp-sqlite3

mcp-sqlite3

by daedalus

mcp-sqlite3

MCP server exposing sqlite3 library functionality

PyPI Python Ruff

Install

pip install mcp-sqlite3

Related MCP server: MCP SQLite Server

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

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      Not graded
      quality
      B
      maintenance
      Provides safe, configurable SQL database access via MCP tools, enabling schema introspection, predefined queries, and structured updates with multi-backend support.
      2
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      Provides comprehensive SQLite database interaction through MCP, enabling CRUD operations, custom SQL queries, and database exploration.
      660 npm
      130
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      Enables AI assistants to manage and query SQLite databases through MCP tools, supporting CRUD operations, schema management, and saved views.
      4 npm
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      Provides a set of MCP tools to let AI assistants like Claude, Cursor, and VS Code Copilot interact with SQLite databases, supporting querying, schema management, and data import/export.
      10 npm
      MIT