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.
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →
Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →
Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →
On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →
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
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →