Summary
This server wraps Python's sqlite3 library and exposes it through MCP tools. You get connection management (connect, close, commit, rollback), direct SQL execution (execute_query, execute_many, execute_script), schema inspection (list_tables, get_table_info), and convenience CRUD operations for common database tasks. Reach for this when you want Claude to interact with SQLite databases without writing custom integration code. It handles the full lifecycle from opening connections to running queries to managing transactions. The tool set is comprehensive enough for both quick data queries and more complex database operations.
Plug Mailtrap into your AI workflow and let it handle the email.
Connect Mailtrap MCP →
Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →
Make coding agent sessions - Searchable, Shareable, Vendor-neutral & Scored.
Try For Free →
Your agent targets a perfect 10 Code Health score. Deterministic. Every commit.
Try For Free →
Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →
belt cli automatically finds the best tools and skills for your agent. image, video, music, tts...
one prompt install →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
Featured
Plug Mailtrap into your AI workflow and let it handle the email.
Connect Mailtrap MCP →Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →Make coding agent sessions - Searchable, Shareable, Vendor-neutral & Scored.
Try For Free →Your agent targets a perfect 10 Code Health score. Deterministic. Every commit.
Try For Free →Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →belt cli automatically finds the best tools and skills for your agent. image, video, music, tts...
one prompt install →