mcp-sqlite3
MCP server exposing sqlite3 library functionality
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 connectionclose_connection- Close a database connectioncommit/rollback- Transaction control
SQL Execution Tools
execute_query- Execute a query and return resultsexecute_many- Execute with multiple parameter setsexecute_script- Execute a SQL script
Schema Tools
list_tables- List all tablesget_table_info- Get table schemacreate_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
Release files for mcp-sqlite3 0.1.3
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| mcp_sqlite3-0.1.3.tar.gz | 9.6 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| mcp_sqlite3-0.1.3-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 19.8 kB
Release files / mcp_sqlite3-0.1.3.tar.gz
| Download URL | mcp_sqlite3-0.1.3.tar.gz |
|---|---|
| Size | 9.6 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
0ab63c47df0123f88a037ba98311ba23e4bc1d54d8e3c7ea78a44d66d5321e58
|
|
BLAKE2b-256 checksum How to use checksums |
a23b732fa769724a374f3e2553818b12e692b8bd6fea70927b8eb4cd17f14f9c
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/6.1.0 CPython/3.13.7
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Mar 31, 2026.
Transparency logRelease files / mcp_sqlite3-0.1.3-py3-none-any.whl
| Download URL | mcp_sqlite3-0.1.3-py3-none-any.whl |
|---|---|
| Size | 10.2 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
c4e0e8373e1709971e364ed6e844cbc4fde130c6b60ad4596f13b2b524b80277
|
|
BLAKE2b-256 checksum How to use checksums |
7c72c0fb26e31acf32eeb680bfe0b844b0b5810b1aa4a5ef189df13a7bdf4315
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/6.1.0 CPython/3.13.7
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Mar 31, 2026.
Transparency log