Mcp Sqlite3

io.github.daedalusPublished by GitHub account daedalusv0.1.3Updated Oct 24, 2026

MCP server exposing sqlite3 library functionality

VerifiedSTDIODesktop onlyDatabasesDeveloper Tools

Overview

AI-generated overview

Local MCP server that exposes SQLite database functionality, letting an assistant open connections, run SQL, inspect schemas and edit rows.

What you can do
  • Open and close SQLite database connections and control transactions with commit and rollback
  • Run SQL: single queries, parameterized batches, and full scripts
  • Inspect schemas: list tables and read table structure
  • Change data and structure: create or drop tables, insert, update, delete and select rows
When to use it
Useful when an assistant needs to work with a local SQLite file: exploring a database, answering questions from its tables, or making controlled schema and data changes during a session.
Requirements
Runs as a local process over stdio, installed from the PyPI package mcp-sqlite3 (pip install mcp-sqlite3), so a Python environment is needed. No authentication, environment variables or headers are declared. Desktop-only; not available as a web executable.
Before you install
The tools can write to the database: create and drop tables, insert, update and delete rows, and run arbitrary SQL scripts. Point it only at databases you are willing to modify, and keep backups, since a drop or delete is not reversible without a rollback or backup.

Installation

In SourceWeft

  1. Open Mcp Sqlite3 in the dashboard and add it to a workspace.
  2. Enable the server for the chats that should use its tools.

Desktop only via STDIO. STDIO servers start a local process, so they need the SourceWeft desktop host.

Other MCP clients

Follow the launch instructions in the repository.

README

mcp-sqlite3

MCP server exposing sqlite3 library functionality

[PyPI] [Python] [Ruff]

Install

bash
pip install mcp-sqlite3

Usage

python
from mcp_sqlite3 import mcp_server
mcp_server.run()

CLI

bash
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

bash
git clone https://github.com/daedalus/mcp-sqlite3.gitcd mcp-sqlite3pip install -e ".[test]"
# run testspytest
# formatruff format src/ tests/
# lintruff check src/ tests/
# type checkmypy src/

MCP Server

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

Source: README.md at commit d9496f9

Tools

0
SourceWeft has not started this package in its sandbox yet, so its tools are not known.

Version history

1
  1. v0.1.3LatestSep 16, 2026

Score

50% of the applicable checks met

How complete this listing is, computed from the registry entry, the endpoint and public sources. Not a rating of the server and not a statement that it is safe or working today: reachability is a dated check, and no installs or reviews go into the score.

  • Reached in the last 30 days25 pts

    Keep the endpoint answering the MCP handshake; SourceWeft probes it every 30 days.

  • Auth declared10 pts

    Declare the credential headers in the registry entry, or keep the endpoint answering the probe so its auth can be classified.

  • Tools listed15 pts

    Answer tools/list without a credential, or ship a package that starts in a sandbox without one.

  • DescriptionRequired15 pts
  • Logo10 pts
  • Documentation15 pts
  • License10 pts